Lecture 12 of 22 · Advanced Database Systems
11: User-Defined Function Optimizations
Advanced Databases
Lectures
Andy Pavlo
Advanced Databases · 22 lectures
CMU 15-721, Spring 2024
22 lectures
0: Course Overview & Logistics
1: Modern OLAP Database Systems
2: Data Formats & Encoding Part 1
3: Data Formats & Encoding Part 2
4: Query Execution & Processing Part 1
5: Query Execution & Processing Part 2
6: Vectorized Query Execution Using SIMD
7: JIT Query Compilation & Code Generation
8: Query Scheduling & Coordination
9: Parallel Hash Join Algorithms
10: Multi-Way Join Algorithms / Worst-Case Optimal Joins11: User-Defined Function Optimizations
12: Database Networking Protocols
13: Query Optimizer Implementation 1
14: Query Optimizer Implementation 2
15: Query Optimizer Implementation 3
17: Google BigQuery / Dremel
18: Databricks Photon / Spark SQL
19: Snowflake Data Warehouse Internals
20: DuckDB Embedded Database System
21: Yellowbrick Data Warehouse System
22: Amazon Redshift Data Warehouse System