S2024 #00 - Course Overview & Logistics (CMU Advanced Database Systems)
33:17S2024 #01 - Modern OLAP Database Systems (CMU Advanced Database Systems)
1:09:05S2024 #02 - Data Formats & Encoding Part 1 (CMU Advanced Database Systems)
1:23:08S2024 #03 - Data Formats & Encoding Part 2 (CMU Advanced Database Systems)
1:21:48S2024 #04 - Query Execution & Processing Part 1 (CMU Advanced Database Systems)
1:23:43S2024 #05 - Query Execution & Processing Part 2 (CMU Advanced Database Systems)
1:24:55S2024 #06 - Vectorized Query Execution Using SIMD (CMU Advanced Database Systems)
1:18:40Lecture 7: JIT Query Compilation & Code Generation (15-721)
1:21:57Lecture 8: Query Scheduling & Coordination (15-721)
1:24:32Lecture 9: Parallel Hash Join Algorithms (15-721)
1:25:37Lecture 10: Multi-Way Join Algorithms / Worst-Case Optimal Joins (15-721)
1:09:43Lecture 11: User-Defined Function Optimizations (15-721)
1:20:25Lecture 12: Database Networking Protocols (15-721)
1:22:56Lecture 13: Query Optimizer Implementation 1 (15-721)
1:23:31Lecture 14: Query Optimizer Implementation 2 (15-721)
1:20:31Lecture 15: Query Optimizer Implementation 3 (15-721)
43:13Lecture 17: Google BigQuery / Dremel (15-721)
1:08:59Lecture 18: Databricks Photon / Spark SQL (15-721)
1:07:30Lecture 19: Snowflake Data Warehouse Internals (15-721)
1:20:55Lecture 20: DuckDB Embedded Database System (15-721)
1:02:13Lecture 21: Yellowbrick Data Warehouse System (15-721)
1:21:10Lecture 22: Amazon Redshift Data Warehouse System (15-721)
1:04:03Lecture 8: Query Scheduling & Coordination (15-721)
This session delves into advanced query scheduling and coordination strategies within database systems, examining parallel execution models and resource management techniques for concurrent query processing in distributed environments.
Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)
Slides: https://15721.courses.cs.cmu.edu/spring2024/slides/08-scheduling.pdf
Notes: https://15721.courses.cs.cmu.edu/spring2024/notes/08-scheduling.pdf
Lecture 7: JIT Query Compilation & Code Generation (15-721)
Next · Lecture 10Lecture 9: Parallel Hash Join Algorithms (15-721)
