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 12:30pm-1:50pm ET
- Location:
- Porter Hall 100 (CMU Students Only)
- Textbook:
- Database System Concepts (7th Edition)
- Discussion:
- Piazza
Instructors
| Name | Office Hours | Location | |
|---|---|---|---|
 |
Jignesh Patel | Monday 2:00-3:00pm | GHC 9103 |
Teaching Assistants
| Name | Office Hours | Location | |
|---|---|---|---|
 |
Zixi (Tom) An | Monday 2:00-3:00pm | GHC 5th Floor (Commons, Table 1) |
 |
Shivang Dalal | Monday 4:00-5:00pm | GHC 5th Floor (Commons, Table 1) |
 |
Yuanxin Cao | Tuesday 2:30-3:30pm | GHC 5th Floor (Commons, Table 1) |
 |
Yuchen Liang | Tuesday 3:30-4:30pm | GHC 5th Floor (Commons, Table 1) |
 |
Ruijie Zhai | Wednesday 4:00-5:00pm | GHC 5th Floor (Commons, Table 1) |
 |
Lan Lou | Wednesday 6:30-7:30pm | GHC 5th Floor (Commons, Table 1) |
 |
Amy Cheng | Thursday 2:00-3:00pm | GHC 5th Floor (Commons, Table 1) |
 |
Ritu Pathak | Thursday 3:00-4:00pm | GHC 5th Floor (Commons, Table 1) |
 |
Avery Qi | Friday 1:00-2:00pm | GHC 5th Floor (Commons, Table 1) |
 |
Alexis Schlomer | Friday 2:00-3:00pm | GHC 5th Floor (Commons, Table 1) |
House DJ
| Name | Equipment | Playlist | |
|---|---|---|---|
 |
DJ 2PL | Denon DJ SC LIVE 4 | Spotify |