This course on Advanced Database Systems aims to teach students about various topics such as in-memory databases, concurrency control, indexing, storage models, query execution, join algorithms, logging and recovery, database compression, query planning, and non-volatile memory database systems. The course employs a lecture-based teaching method and is intended for individuals interested in gaining advanced knowledge and skills in database systems.
Overview
Syllabus
Lecture #01 - Course Information & History of Databases [CMU Database Systems Spring 2016].
Lecture #02 - In-Memory Databases [CMU Database Systems Spring 2016].
Lecture #03 - Concurrency Control (Part I) [CMU Database Systems Spring 2016].
Lecture #04 - Concurrency Control (Part II) [CMU Database Systems Spring 2016].
Lecture #05 - Concurrency Control (Part III) [CMU Database Systems Spring 2016].
Lecture #06 - Indexing (Locking & Latching) [CMU Database Systems Spring 2016].
Lecture #07 - Indexing (OLTP) [CMU Database Systems Spring 2016].
Lecture #08 - Indexing (OLAP) [CMU Database Systems Spring 2016].
Lecture #09 - Storage Models & Data Layout [CMU Database Systems Spring 2016].
Lecture #10 - Query Execution & Scheduling [CMU Database Systems Spring 2016].
Lecture #11 - Join Algorithms (Hashing) [CMU Database Systems Spring 2016].
Lecture #12 - Join Algorithms (Sorting) [CMU Database Systems Spring 2016].
Lecture #13 - Logging & Recovery (Physical Logging) [CMU Database Systems Spring 2016].
Lecture #14 - Logging & Recovery (Alternative Methods) [CMU Database Systems Spring 2016].
Lecture #15 - Project Ideas & Extra Credit [CMU Database Systems Spring 2016].
Lecture #16 - Database Compression [CMU Database Systems Spring 2016].
Lecture #17 - Query Planning (Optimizer Implementation) [CMU Database Systems Spring 2016].
Lecture #18 - Query Planning (Cost Models) [CMU Database Systems Spring 2016].
Lecture #19 - Query Compilation [CMU Database Systems Spring 2016].
Lecture #20 - Scan Sharing [CMU Database Systems Spring 2016].
Lecture #21 - Vectorized Execution [CMU Database Systems Spring 2016].
Lecture #22 - Larger-than-Memory Databases [CMU Database Systems Spring 2016].
Lecture #23 - Non-Volatile Memory Database Systems [CMU Database Systems Spring 2016].
Lecture #24 - End-of-Semester + MemSQL Tech Talk [CMU Database Systems Spring 2016].
Taught by
CMU Database group
