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
Yuchen Liang
Drew Ripberger
Sumukh Venkatesh Monday 3:00-4:00pm GHC 5th Floor (Commons, Table 2) GHC 5th Floor (Commons, Table 2)
Aditya Chopra
Karen Wu Thursday 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)
Andrew Zhao Friday 3:30-4:30pm GHC 5th Floor (Commons, Table 2) GHC 5th Floor (Commons, Table 2)
Roy Huang Wednesday 3:30-4:30pm GHC 5th Floor (Commons, Table 2) GHC 5th Floor (Commons, Table 2)

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.