This course on Advanced Database Systems aims to teach students about in-memory databases, transaction models, concurrency control, indexing, storage models, query processing, and optimization techniques. The course covers topics such as multi-version concurrency control, database compression, recovery protocols, parallel algorithms, and self-driving databases. The teaching method includes lectures, discussions, and possibly hands-on projects. This course is intended for students or professionals interested in advanced database concepts and technologies.
Overview
Syllabus
CMU Advanced Database Systems - 01 In-Memory Databases (Spring 2019).
CMU Advanced Database Systems - 02 Transaction Models & In-Memory Concurrency Control (Spring 2019).
CMU Advanced Database Systems - 03 Multi-Version Concurrency Control Design Decisions (Spring 2019).
CMU Advanced Database Systems - 04 Multi-Version Concurrency Control Protocols (Spring 2019).
CMU Advanced Database Systems - 05 MVCC Garbage Collection (Spring 2019).
CMU Advanced Database Systems - 06 Index Locking & Latching (Spring 2019).
CMU Advanced Database Systems - 07 OLTP Indexes: Latch-free Data Structures (Spring 2019).
CMU Advanced Database Systems - 08 OLTP Indexes: Trie Data Structures (Spring 2019).
CMU Advanced Database Systems - 09 Storage Models & Data Layout (Spring 2019).
CMU Advanced Database Systems - 10 Database Compression (Spring 2019).
CMU Advanced Database Systems - 11 Larger-than-Memory Databases (Spring 2019).
CMU Advanced Database Systems - 12 Recovery Protocols (Spring 2019).
CMU Advanced Database Systems - 13 Networking Protocols (Spring 2019).
CMU Advanced Database Systems - 14 Scheduling (Spring 2019).
CMU Advanced Database Systems - 15 Query Processing & Execution (Spring 2019).
CMU Advanced Database Systems - 16 Server-side Logic Execution (Spring 2019).
CMU Advanced Database Systems - 17 Parallel Hash Join Algorithms (Spring 2019).
CMU Advanced Database Systems - 18 Parallel Sort-Merge Join Algorithms (Spring 2019).
CMU Advanced Database Systems - 19 Query Compilation & Code Generation (Spring 2019).
CMU Advanced Database Systems - 20 Vectorized Query Execution (Spring 2019).
CMU Advanced Database Systems - 21 Vectorization vs. Compilation (Spring 2019).
CMU Advanced Database Systems - 22 Query Optimizer Implementation (Part I) (Spring 2019).
CMU Advanced Database Systems - 23 Query Optimizer Implementation (Part 2) (Spring 2019).
CMU Advanced Database Systems - 24 Query Optimizer Cost Models (Spring 2019).
CMU Advanced Database Systems - 25 Self-Driving Databases (Spring 2019).
CMU Advanced Database Systems - 26 Anil Goel (SAP HANA) (Spring 2019).
Taught by
CMU Database group
Tags
Related Courses
Related articles
Reviews
5.0 rating, based on 1 Class Central review
-
Larry ZhongThis is an excellent course that provides an in-depth examination of advanced database techniques and systems. The lectures are very clear and detailed in explaining complex concepts. Each week focuses on a different topic, from query processing an…
