Overview

Dive into advanced database systems concepts through this comprehensive course from Carnegie Mellon University. Explore in-memory databases, transaction models, concurrency control protocols, indexing techniques, storage models, compression methods, recovery protocols, query processing and optimization, and emerging trends like self-driving databases. Learn from expert lectures covering topics such as multi-version concurrency control, garbage collection, latch-free data structures, trie data structures, networking protocols, parallel join algorithms, query compilation, and vectorized execution. Gain insights into real-world database implementations with a guest lecture from SAP HANA. Develop a deep understanding of modern database system architectures and design principles over 26 detailed sessions.

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

Reviews

5.0 rating, based on 1 Class Central review

Start your review of Advanced Database Systems - Spring 2019

Larry Zhong

This 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…

This 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 and optimization to distributed databases and data streams. Real-world examples and demonstrations are used effectively to complement the theoretical concepts.
Students complete sizable programming assignments applying the techniques learned. This hands-on experience reinforces the concepts discussed in class.
There are also biweekly exams to evaluate understanding. Additionally, a semester research project delves deeper into a selected database topic or system.
The pacing is rigorous but flexible, accommodating different student backgrounds. Comprehensive course notes and textbooks further support learning.
Interaction with the professor and TAs is very good. Overall it provides a rigorous yet practical foundation in advanced databases. Strongly recommended for anyone interested in database research or systems development work. The high quality of instruction and materials makes it an excellent option.

Taught by

Tags

Advanced Database Systems - Spring 2018

Advanced Database Systems - Spring 2020

Advanced Database Systems - Spring 2017

Advanced Database Systems - Spring 2016

Database Management System

Large-Scale Database Systems

Never Stop Learning.