COP5725 Advanced Database Systems (Spring 2025)

Instructor: Peixiang Zhao

| Syllabus | Announcement | Schedule | Assignment | Project | Resources |



Required Reading Papers
  1. Michael Stonebraker, Andrew Pavlo. What Goes Around Comes Around... And Around.... ACM SIGMOD Record, 2024
  2. Daniel J. Abadi, Samuel R. Madden, Nabil Hachem.Column-Stores vs. Row-Stores: How Different Are They Really? ACM SIGMOD, 2008
  3. Marcus Muller, Lawrence Benson, Viktor Leis. B-Trees Are Back: Engineering Fast and Pageable Node Layouts. ACM SIGMOD, 2025
  4. Goetz Graefe. Volcano - An Extensible and Parallel Query Evaluation System. TKDE'94.
  5. Rui Li, Zongyan He, Jeffrey Xu Yu. Join Optimization Revisited: A Novel DP Algorithm For Join&Sort Order Selection. VLDB Journal'25.
Assignments
  1. Assignment 0 (Database fundamentals): in-class quiz
  2. Assignment 1 (Database fundamentals, Data storage and presentation, Advanced indexing)
  3. Assignment 2 (Query processing, Query Optimization)

    Useful Links
    1. How to read a research paper by Prof. Michael Mitzenmacher
    2. How to read a paper by Prof. S. Keshav