NOTICE: This is an archived version of the course. Click here to view the latest offering.

Course Information

This course is 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), indexing (order preserving trees, hash tables), 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 flex their strong systems programming skills.

Time:
Mon/Wed 2:00pm-3:20pm ET
Location:
Tepper 1403
Textbook:
Database System Concepts (7th Edition)
Discussion:
Piazza

Acknowledgements

Thanks to the following organizations for their course development support.

Instructors

Name Office Hours Location
Andy Pavlo Wednesday 1:00-2:00pm GHC 9019
Jignesh Patel Monday 1:00-2:00pm GHC 9103

Teaching Assistants

Name Office Hours Location
Keren Huang Monday 5:30-6:30pm GHC 5th Floor (Carrel 4)
Mayank Baranwal Tuesday 11:00am-12:00pm GHC 5th Floor (Commons, Table 6)
Wiam Eddahri Tuesday 4:30-5:30pm GHC 5th Floor (Commons, Table 1)
Yuchen Liang Tuesday 5:30-6:30pm GHC 5th Floor (Carrel 4)
Fernando Lisboa Wednesday 10:00-11:00am GHC 5th Floor (Commons, Table 6)
Anurag Choudhary Thursday 3:00-4:00pm GHC 5th Floor (Commons, Table 1)
Ruijie Zhai Thursday 4:00-5:00pm GHC 5th Floor (Commons, Table 1)
Chi Zhang Thursday 5:00-6:00pm GHC 5th Floor (Carrel 4)
Avery Qi Friday 1:00-2:00pm GHC 5th Floor (Commons, Table 1)
Aolei Zhou Friday 2:00-3:00pm GHC 5th Floor (Commons, Table 1)
Abigale Kim Friday 5:00-6:00pm GHC 5th Floor (Carrel 4)

House DJ

Name Equipment Playlist
DJ 2PL Denon DJ SC LIVE 4 Spotify