Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Explore advanced database system concepts through this comprehensive graduate-level course from Carnegie Mellon University's Database Group covering cutting-edge topics in modern analytical database systems. Delve into the historical evolution of databases before examining contemporary analytical database architectures and their underlying principles. Master fundamental concepts including database storage models, data layout strategies, and specialized indexing techniques designed for analytical workloads. Learn about database compression methods and their impact on query performance, then progress to advanced query execution models and processing techniques. Investigate query scheduling algorithms and discover how vectorized query execution leverages SIMD instructions for performance optimization. Understand query compilation and just-in-time code generation techniques, comparing vectorization approaches with compilation strategies. Examine parallel processing algorithms including hash join and sort-merge join implementations, as well as multi-way and worst-case optimal join algorithms. Study server-side logic execution patterns and user-defined function implementations, along with database networking considerations. Gain deep insights into query optimizer implementations through detailed two-part coverage of optimization strategies and techniques. Analyze real-world database systems through case studies of industry-leading platforms including Google BigQuery and Dremel architecture, Databricks Photon and Spark SQL internals, Snowflake's data warehouse design, DuckDB's analytical engine, Meta's Velox execution framework, and Amazon Redshift's distributed architecture. Each lecture provides practical insights into how these systems solve complex analytical challenges at scale, making this essential learning for database researchers, system architects, and engineers working with large-scale data processing systems.
