COP5725 Advanced Database Systems (Fall 2023)
Instructor: Peixiang Zhao
| Syllabus | Announcement | Schedule | Assignment | Project | Resources |
- E. F. Codd. A Relational Model of Data for Large Shared Data Banks. CACM, 1970
- Michael Stonebraker, Daniel Abadi, Adam Batkin, Xuedong Chen, Mitch Cherniack, Miguel Ferreira, Edmond Lau, Amerson Lin, Sam Madden, Elizabeth O'Neil, Pat O'Neil, Alex Rasin, Nga Tran and Stan Zdonik. C-Store: A Column Oriented DBMS. VLDB'05.
- Patrick O'Neil, Edward Cheng, Dieter Gawlick, and Elizabeth O'Neil. The Log-structured Merge Tree. Acta Informatica, 1996.
- Goetz Graefe. Volcano - An Extensible and Parallel Query Evaluation System. TKDE'94.
-
Xiang Yu, Chengliang Chai, Guoliang Li, Jiabin Liu. Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection. VLDB 2023.
- Assignment 0 (Database fundamentals): in-class quiz
- Assignment 1 (Database fundamentals, Data storage and presentation, Advanced indexing)
- Assignment 2 (Query processing, Query Optimization)