Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

CMU Advanced Database Systems - Spring 2024

CMU Database Group via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Explore advanced database system concepts through this comprehensive university-level course covering modern OLAP systems, query processing, and cutting-edge database technologies. Master data formats and encoding techniques, delve into vectorized query execution using SIMD instructions, and understand JIT compilation for database queries. Learn parallel processing strategies including hash join algorithms and multi-way join optimizations, while examining query scheduling, coordination, and user-defined function optimizations. Investigate database networking protocols and gain deep insights into query optimizer implementation across multiple sessions. Study real-world systems through detailed examinations of Google BigQuery/Dremel architecture, Databricks Photon and Spark SQL, Snowflake's data warehouse internals, DuckDB's embedded approach, Yellowbrick's specialized system, and Amazon Redshift's cloud-native design. Develop expertise in modern database internals, performance optimization techniques, and the architectural decisions behind leading commercial and open-source database systems used in production environments today.

Syllabus

S2024 #00 - Course Overview & Logistics (CMU Advanced Database Systems)
S2024 #01 - Modern OLAP Database Systems (CMU Advanced Database Systems)
S2024 #02 - Data Formats & Encoding Part 1 (CMU Advanced Database Systems)
S2024 #03 - Data Formats & Encoding Part 2 (CMU Advanced Database Systems)
S2024 #04 - Query Execution & Processing Part 1 (CMU Advanced Database Systems)
S2024 #05 - Query Execution & Processing Part 2 (CMU Advanced Database Systems)
S2024 #06 - Vectorized Query Execution Using SIMD (CMU Advanced Database Systems)
S2024 #07 - JIT Query Compilation & Code Generation (CMU Advanced Database Systems)
S2024 #08 - Query Scheduling & Coordination (CMU Advanced Database Systems)
S2024 #09 - Parallel Hash Join Algorithms (CMU Advanced Database Systems)
S2024 #10 - Multi-Way Join Algorithms / Worst-Case Optimal Joins (CMU Advanced Database Systems)
S2024 #11 - User-Defined Function Optimizations (CMU Advanced Database Systems)
S2024 #12 - Database Networking Protocols (CMU Advanced Database Systems)
S2024 #13 - Query Optimizer Implementation 1 (CMU Advanced Database Systems)
S2024 #14 - Query Optimizer Implementation 2 (CMU Advanced Database Systems)
S2024 #15 - Query Optimizer Implementation 3 (CMU Advanced Database Systems)
S2024 #17 - Google BigQuery / Dremel (CMU Advanced Database Systems)
S2024 #18 - Databricks Photon / Spark SQL (CMU Advanced Database Systems)
S2024 #19 - Snowflake Data Warehouse Internals (CMU Advanced Database Systems)
S2024 #20 - DuckDB Embedded Database System (CMU Advanced Database Systems)
S2024 #21 - Yellowbrick Data Warehouse System (CMU Advanced Database Systems)
S2024 #22 - Amazon Redshift Data Warehouse System (CMU Advanced Database Systems)

Taught by

CMU Database Group

Reviews

Start your review of CMU Advanced Database Systems - Spring 2024

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.