Advanced Database Systems - Spring 2020
Dive into advanced database systems through this comprehensive course from Carnegie Mellon University's Spring 2020 semester. Explore the evolution of databases, in-memory architectures, multi-version concurrency control, OLTP indexing, storage models, compression techniques, recovery protocols, networking, and scheduling. Master query execution, processing, compilation, and code generation, while comparing vectorized execution to compilation. Examine hash join algorithms, parallel sorting techniques, and query optimizer implementation. Investigate cost models, larger-than-memory architectures, server-side logic execution, and the impact of new hardware on database systems. Gain in-depth knowledge of cutting-edge database technologies and design principles over 25 detailed lectures spanning more than 31 hours.