Intro to Database Systems

Yes, this is the premier course at Carnegie Mellon University on the design and implementation of database management systems. Topics include data models (relational, document, key/value), storage models (n-ary, decomposition), query languages (SQL, stored procedures), storage architectures (heaps, log-structured), indexes + filters (order preserving trees, hash tables, vector indexes), transaction processing (ACID, concurrency control), recovery (logging, checkpoints), query processing (joins, sorting, aggregation, optimization), and parallel architectures (multi-core, distributed). Case studies on open-source and commercial database systems are used to illustrate these techniques and trade-offs. The course is appropriate for students that are prepared to sweat their systems programming skills.

Time:
Mon/Wed 12:30pm-1:50pm ET
Location:
Porter Hall 100
Textbook:
DB System Concepts (7th Ed.)
Discussion:
Piazza

Acknowledgements

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

Instructors

Name Office Hours Location
Jignesh Patel Monday 2:00-3:00pm GHC 9103 GHC 9103

Teaching Assistants

Name Office Hours Location
Aditya Bhatnagar Monday 4:00-5:00pm TBD TBD
Ramsey Boyce Monday 5:00-6:00pm GHC 5th Floor (Commons, Table 3) GHC 5th Floor (Commons, Table 3)
Hyoungjoo Kim Tuesday 3:00-4:00pm GHC 5th Floor (Commons, Table 2) GHC 5th Floor (Commons, Table 2)
Yuchen Liang Tuesday 4:00-5:00pm GHC 5th Floor (Commons, Table 2) GHC 5th Floor (Commons, Table 2)
Christos Laspias Wednesday 4:00-5:00pm GHC 5th Floor (Commons, Table 6) GHC 5th Floor (Commons, Table 6)
Yuqi Xiang Thursday 2:00-3:00pm GHC 5th Floor (Commons, Table 3) GHC 5th Floor (Commons, Table 3)
Joe Inchodikaran Friday 5:00-6:00pm TBD TBD
Alexis Schlomer Friday 5:00-6:00pm TBD TBD