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:
MW 2:00PM-3:20PM
Location:
POS A35
Textbook:
DB System Concepts (7th Ed.)
Discussion:
Piazza
Submissions:
Gradescope

Name Office Hours Location
Jignesh Patel Monday 3:30-4:30pm GHC 9103 GHC 9103

Name Office Hours Location
Andrew Zhao Friday 3:30-4:30pm GHC 5th Floor (Commons, Table 2) GHC 5th Floor (Commons, Table 2)
Drew Ripberger
Roy Huang Wednesday 3:30-4:30pm GHC 5th Floor (Commons, Table 2) GHC 5th Floor (Commons, Table 2)
Zixuan Chen Tuesday 4:00-5:00pm GHC 5th Floor (Commons, Table 3) GHC 5th Floor (Commons, Table 3)
Sumukh Venkatesh Monday 3:00-4:00pm GHC 5th Floor (Commons, Table 2) GHC 5th Floor (Commons, Table 2)
Yuchen Liang
Karen Wu Thursday 3:30-4:30pm GHC 5th Floor (Commons, Table 2) GHC 5th Floor (Commons, Table 2)
Aditya Chopra

Name Equipment Playlist
DJ TBD TBD TBD TBD

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