23 - Larger-than-Memory Database Architectures (CMU Databases / Spring 2020)
24
24 - Server-Side Logic Execution (CMU Databases / Spring 2020)
25
25 - Databases on New Hardware (CMU Databases / Spring 2020)
Description:
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.