This is Carnegie Mellon University's best course on the design and implementation of database management systems. We will go through through data models (relational, document, key/value), storage models (n-ary, decomposition), query languages, storage architectures (heaps, log-structured), indexes + filters (trees, hash tables, vector), transaction processing (ACID, concurrency control), recovery (logging, checkpoints), query processing (joins, sorting, aggregation, optimization), and parallel architectures (multi-core, distributed). We will also use case studies on open-source and commercial database systems to illustrate these techniques and trade-offs. This course is appropriate for students that are ready to commit to a database-centric lifestyle and flex their systems programming skills.

Time:
Mon/Wed 2:00pm-3:20pm ET
Location:
Hall of Arts 160
Textbook:
DB System Concepts (7th Ed.)
Discussion:
Piazza
Submissions:
Gradescope

Name Office Hours Location
Andy Pavlo Wednesday 4:00-5:00pm GHC 9019 GHC 9019
Jignesh Patel Monday 3:30-4:30pm GHC 9103 GHC 9103

Name Office Hours Location
Saransh Malik TBA GHC 5th Floor (Commons) GHC 5th Floor (Commons)
Saileshwar Karthik TBA GHC 5th Floor (Commons) GHC 5th Floor (Commons)
Joseph Amirtharaj TBA GHC 5th Floor (Commons) GHC 5th Floor (Commons)
Aditya Chopra TBA GHC 5th Floor (Commons) GHC 5th Floor (Commons)
Stephen Chien TBA GHC 5th Floor (Commons) GHC 5th Floor (Commons)
Yilei Huang TBA GHC 5th Floor (Commons) GHC 5th Floor (Commons)
Xinyu Tang TBA GHC 5th Floor (Commons) GHC 5th Floor (Commons)
Elizabeth Terveen Thursday 9:30am - 10:30am GHC 5th Floor (Commons) GHC 5th Floor (Commons)

Name Equipment Playlist
DJ Cache Roland SP-404MKII Spotify Spotify

Thanks to the following organizations for their support towards course development as part of the CMU-DB Affiliates Program.