Dive into the world of database systems with this comprehensive lecture series from Carnegie Mellon University's Fall 2018 course. Explore fundamental concepts starting with the relational data model and advanced SQL, then progress through database storage, buffer pools, and various indexing techniques. Learn about query processing, optimization, and execution, including sorting, aggregation, and join algorithms. Delve into concurrency control theories and implementations, covering two-phase locking, timestamp ordering, and multi-version approaches. Understand logging schemes, database recovery, and distributed database architectures for both OLTP and OLAP systems. Gain insights from industry perspectives on modern database systems like VoltDB, CockroachDB, Spanner, and MongoDB. Master the intricacies of database systems through 26 in-depth lectures, providing a solid foundation for both academic understanding and practical application in the field of database management.
Overview
Syllabus
CMU Database Systems - 01 Course introduction & Relational Data Model (Fall 2018).
CMU Database Systems - 02 Advanced SQL (Fall 2018).
CMU Database Systems - 03 Database Storage I (Fall 2018).
CMU Database Systems - 04 Database Storage II (Fall 2018).
CMU Database Systems - 05 Buffer Pools (Fall 2018).
CMU Database Systems - 06 Hash Tables (Fall 2018).
CMU Database Systems - 07 Tree Indexes Part I (Fall 2018).
CMU Database Systems - 08 Tree Indexes Part II (Fall 2018).
CMU Database Systems - 09 Index Concurrency Control (Fall 2018).
CMU Database Systems - 10 Query Processing (Fall 2018).
CMU Database Systems - 11 Sorting & Aggregation Algorithms (Fall 2018).
CMU Database Systems - 12 Join Algorithms (Fall 2018).
CMU Database Systems - 13 Query Optimization (Fall 2018).
CMU Database Systems - 14 Parallel Execution (Fall 2018).
CMU Database Systems - 15 Embedded Logic (Fall 2018).
CMU Database Systems - 16 Concurrency Control Theory (Fall 2018).
CMU Database Systems - 17 Two-Phase Locking Concurrency Control (Fall 2018).
CMU Database Systems - 18 Timestamp Ordering Concurrency Control (Fall 2018).
CMU Database Systems - 19 Multi-Version Concurrency Control (Fall 2018).
CMU Database Systems - 20 Logging Schemes (Fall 2018).
CMU Database Systems - 21 Database Recovery (Fall 2018).
CMU Database Systems - 22 Distributed OLTP Databases Part I (Fall 2018).
CMU Database Systems - 23 Distributed OLTP Databases Part II (Fall 2018).
CMU Database Systems - 24 Distributed OLAP Databases (Fall 2018).
CMU Database Systems - 25 Ethan Zhang [VoltDB] (Fall 2018).
CMU Database Systems - 26 Systems Potpourri [CockroachDB, Spanner, MongoDB] (Fall 2018).
Taught by
CMU Database group
