Dive into advanced database systems concepts through this comprehensive lecture series from Carnegie Mellon University's Spring 2017 course. Explore the evolution of databases, in-memory architectures, concurrency control mechanisms, indexing techniques, storage models, compression strategies, logging and checkpoint protocols, query optimization and execution, parallel algorithms, and emerging technologies. Learn about vectorized execution, larger-than-memory databases, and non-volatile memory systems. Gain insights from industry experts with a special tech talk on Apache Impala and Kudu. Enhance your understanding of cutting-edge database technologies and their practical applications in this intensive, 25-lecture course designed for advanced learners in computer science and database management.
Overview
Syllabus
L01 - Course Information & History of Databases [CMU Database Systems Spring 2017].
L02 - In-Memory Databases [CMU Database Systems Spring 2017].
L03 - Concurrency Control Challenges [CMU Database Systems Spring 2017].
L04 - Optimistic Concurrency Control [CMU Database Systems Spring 2017].
L05 - Multi-Version Concurrency Control [CMU Database Systems Spring 2017].
L06 - Index Locking & Latching [CMU Database Systems Spring 2017].
L07 - Latch-free OLTP Indexes (Part I) [CMU Database Systems Spring 2017].
L08 - Latch-free OLTP Indexes (Part II) [CMU Database Systems Spring 2017].
L09 - OLAP Indexes [CMU Database Systems Spring 2017].
L10 - Storage Models & Data Layout [CMU Database Systems Spring 2017].
L11 - Database Compression [CMU Database Systems Spring 2017].
L12 - Logging Protocols [CMU Database Systems Spring 2017].
L13 - Checkpoint Protocols [CMU Database Systems Spring 2017].
L14 - Optimizer Implementation (Part I) [CMU Database Systems Spring 2017].
L15 - Optimizer Implementation (Part II) [CMU Database Systems Spring 2017].
L16 - Optimizer Cost Models [CMU Database Systems Spring 2017].
L17 - Query Execution & Scheduling [CMU Database Systems Spring 2017].
L18 - Parallel Join Algorithms (Hashing) [CMU Database Systems Spring 2017].
L19 - Parallel Join Algorithms (Sorting) [CMU Database Systems Spring 2017].
L20 - Query Compilation [CMU Database Systems Spring 2017].
L21 - Vectorized Execution (Part I) [CMU Database Systems Spring 2017].
L22 - Vectorized Execution (Part II) [CMU Database Systems Spring 2017].
L23 - Larger-than-Memory Databases [CMU Database Systems Spring 2017].
L24 - Non-Volatile Memory Databases [CMU Database Systems Spring 2017].
L25 - Apache Impala/Kudu Tech Talk [CMU Database Systems Spring 2017].
Taught by
CMU Database group
Tags
Related Courses
Reviews
4.0 rating, based on 1 Class Central review
-
Fidele FisonI can tell you that 15-721 Advanced Database Systems is a graduate-level course that covers advanced topics in database systems, including query optimization, transaction processing, distributed databases, and data mining. The course has a heavy focus on research papers and requires significant programming assignments. It is generally considered a challenging but rewarding course for students interested in database systems.
