Dive into advanced database systems concepts through this comprehensive lecture series from Carnegie Mellon University's Spring 2016 course. Explore the evolution of database technology, in-memory databases, concurrency control, indexing techniques for OLTP and OLAP, storage models, query execution, join algorithms, logging and recovery methods, database compression, query planning and optimization, query compilation, scan sharing, vectorized execution, larger-than-memory databases, and non-volatile memory database systems. Gain insights into cutting-edge database technologies and their practical applications in this intensive course spanning over 27 hours of in-depth lectures.
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
