Advanced Database Systems
Course ID 15721
Description This course is a comprehensive study of the internals of modern database management systems. It will cover the core concepts and fundamentals of the components that are used in large-scale analytical systems (OLAP). The class will stress both efficiency and correctness of the implementation of these ideas.
Key Topics
Modern Database System Architectures
Query Optimization
Concurrency Control
Query Execution
Indexing
Logging & Recovery
Distributed Database Systems
Implementation Issues
Required Background Knowledge
The prerequisites are (1) 15-445/645 or an equivalent undergraduate class in databases and (2) 15-410 or an equivalent undergraduate class in operating systems. Students that are unable to meet these requirements must otherwise receive permission from the instructor.
Course Relevance
The course is appropriate for graduate students in software systems and for advanced undergraduates with systems programming skills.
Course Goals
Apply and customize state-of-the-art implementation techniques for single-node database management systems following modern coding practices.
Identify trade-offs among database systems techniques and contrast alternatives for both on-line transaction processing and on-line analytical workloads.
Develop and justify design decisions in the context of a high-performance database system.
Implement and evaluate complex, scalable database systems, with emphasis on providing experimental evidence for design decisions.
Interpret and comparatively criticize state-of-the-art research talks and papers, with emphasis on constructive improvements.
Learning Resources
There will be no textbook. The course will cover papers on the latest in database systems research.
Assessment Structure
Grading will be based on paper reviews, participation, exams, and programming projects.
Course Link
https://15721.courses.cs.cmu.edu