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 #07 — Query Scheduling
Feb 15, 2023 #08 — Vectorized Execution
Feb 20, 2023 #09 — Query Compilation
Feb 22, 2023 #10 — Vectorization vs. Compilation
Feb 27, 2023 #11 — 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 #12 — Parallel Join Algorithms (Sorting)
Mar 15, 2023 #13 — Multi-Way Joins
Mar 20, 2023 #14 — Server-side Logic Execution
Mar 22, 2023 #15 — Networking Protocols
Mar 27, 2023 #16 — Optimizer Implementation (Overview)
Mar 29, 2023 #17 — Optimizer Implementation (Top-Down vs. Bottom-Up)
Apr 03, 2023 #18 — Cost Models
Apr 05, 2023 Student Project Updates
Apr 10, 2023 #19 — System Analysis (Dremel / BigQuery)
Apr 12, 2023 #20 — System Analysis (Databricks / Spark)
Apr 17, 2023 #21 — System Analysis (Snowflake)
Apr 19, 2023 #22 — System Analysis (DuckDB) (Guest Speaker: Mark Raasveldt)
Apr 24, 2023 #23 — System Analysis (Velox)
Apr 26, 2023 #24 — System Analysis (Amazon Redshift) (Guest Speaker: Ippokratis Pandis (PhD'07))