This course covers advanced topics in database systems, focusing on areas such as in-memory databases, concurrency control, indexing, storage models, query optimization, parallel algorithms, and database execution. The course aims to teach students the skills needed to design and implement efficient and scalable database systems. The teaching method includes lectures, readings, and hands-on assignments. This course is intended for students or professionals with a background in database systems or computer science looking to deepen their knowledge in advanced database concepts.
Overview
Syllabus
CMU Advanced Database Systems - 01 Course Information & History of Databases (Spring 2018).
CMU Advanced Database Systems - 02 In-Memory Databases (Spring 2018).
CMU Advanced Database Systems - 03 Query Compilation (Spring 2018).
CMU Advanced Database Systems - 04 Optimistic Concurrency Control (Spring 2018).
CMU Advanced Database Systems - 05 Multi-Version Concurrency Control Part I (Spring 2018).
CMU Advanced Database Systems - 06 Multi-Version Concurrency Control Part II (Spring 2018).
CMU Advanced Database Systems - 07 Index Locking & Latching (Spring 2018).
CMU Advanced Database Systems - 08 OLTP Indexes Part I (Spring 2018).
CMU Advanced Database Systems - 09 OLTP Indexes Part II (Spring 2018).
CMU Advanced Database Systems - 10 Storage Models & Data Layout (Spring 2018).
CMU Advanced Database Systems - 11 System Catalogs & Database Compression (Spring 2018).
CMU Advanced Database Systems - 12 Logging Protocols (Spring 2018).
CMU Advanced Database Systems - 13 Database Checkpoints (Spring 2018).
CMU Advanced Database Systems - 14 Networking (Spring 2018).
CMU Advanced Database Systems - 15 Optimizer Implementation Part I (Spring 2018).
CMU Advanced Database Systems - 16 Optimizer Implementation Part II (Spring 2018).
CMU Advanced Database Systems - 17 Cost Models (Spring 2018).
CMU Advanced Database Systems - 18 Query Execution & Scheduling (Spring 2018).
CMU Advanced Database Systems - 19 Parallel Hash Join Algorithms (Spring 2018).
CMU Advanced Database Systems - 20 Parallel Sort-Merge Join Algorithms (Spring 2018).
CMU Advanced Database Systems - 21 Vectorized Query Execution Part I (Spring 2018).
CMU Advanced Database Systems - 22 Vectorized Query Execution Part II (Spring 2018).
CMU Advanced Database Systems - 23 Larger-than-Memory Databases (Spring 2018).
CMU Advanced Database Systems - 24 Databases on New Hardware (Spring 2018).
CMU Advanced Database Systems - 25 Ashish Motivala [Snowflake] (Spring 2018).
Taught by
CMU Database group
