Schedule

Date Topic Slides Notes Video
Jan 16, 2023 Martin Luther King Day — No Class
Jan 18, 2023 #01 — History of Databases
  • M. Stonebraker, et al., What Goes Around Comes Around, in Readings in Database Systems, 4th Edition, 2006 (Optional)
  • M. Stonebraker, et al., What Goes Around Comes Around... And Around ( CMU Only ), 2023 (Optional)
Jan 23, 2023 #02 — Modern Analytical Database Systems (No In-Class Lecture)
Jan 25, 2023 Legal Problems — No Class
Jan 30, 2023 #03 — Storage Models & Data Layout
Feb 01, 2023 #04 — OLAP Indexes
Feb 06, 2023 #05 — Database Compression
Feb 08, 2023 #06 — Query Execution & Processing
Feb 13, 2023 Query Scheduling
Feb 15, 2023 Vectorized Execution
Feb 20, 2023 Query Compilation
Feb 22, 2023 Vectorization vs. Compilation
Feb 27, 2023 Parallel Join Algorithms (Hashing)
Mar 01, 2023 Student Project Proposals
Mar 06, 2023 Spring Break — No Class
Mar 08, 2023 Spring Break — No Class
Mar 13, 2023 Parallel Join Algorithms (Sorting)
Mar 15, 2023 Multi-Way Joins
Mar 20, 2023 Server-side Logic Execution
Mar 22, 2023 Networking Protocols
Mar 27, 2023 Optimizer Implementation (Overview)
Mar 29, 2023 Optimizer Implementation (Top-Down vs. Bottom-Up)
Apr 03, 2023 Student Project Updates
Apr 05, 2023 Cost Models
Apr 10, 2023 System Analysis (Dremel / BigQuery)
Apr 12, 2023 System Analysis (Databricks / Spark)
Apr 17, 2023 System Analysis (Snowflake)
Apr 19, 2023 System Analysis (DuckDB)
Apr 24, 2023 System Analysis (Velox)
Apr 26, 2023 Guest Speaker: Ippokratis Pandis (PhD'07) (Amazon Redshift)