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 will be used to illustrate these techniques and trade-offs. The course is appropriate for students with strong systems programming skills.
- Meeting Time: Mon/Wed 12:00-1:20
- Lecture Location: Posner Hall - Mellon Auditorium
- Textbook: Database System Concepts (6th Edition)
- On-line Discussion: Piazza
Acknowledgements
Special thanks to the following companies for equipment donations and/or support for course development.
