This course offers a hands-on dive into designing and implementing relational database management systems. Students will learn about the internals of a database system—focusing on storage management, indexing, and query execution. By building a fully functional database using C++, students will tackle real-world challenges through engaging programming assignments, gaining practical experience along the way.

# Links

• Central
• OMSCS page
• Course textbook

# Section

• Week 1 - Introduction
• Week 1 - Introduction to BuzzDB
• Week 2 - Storage Management
• Week 3 - Slotted Pages
• Week 3 - What Goes Around Comes Around... And Around...
• Week 4 - Buffer Management
• Week 5 - Multi-threading
• Week 5 - Operating System Support for Database Management
• Week 6 - Hash Tables
• Week 7 - Thread-safe hash tables
• Week 7 - Umbra: A Disk-Based System with In-Memory Performance
• Week 8 - B+tree
• Week 9 - Advanced Indexing Data Structures
• Week 10 - Query Execution
• Week 11 - Operator Framework
• Week 12 - Query Compilation
• Week 13 - Query Optimisation