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