Schedule

  • Date
    Topic
    Mandatory Reading
    Optional Reading
    Presenter
  • 01/08/2026
    Thursday
    Introduction and Data Models
    NA
    What Goes Around Comes Around
    Lin Ma
  • 01/13/2026
    Tuesday
    RDBMS Architecture
    NA
    Anatomy of a Database System (Section 1, 3, 4, 5) & An Overview of Query Optimization in Relational Systems by Chaudhuri
    Lin Ma
  • 01/15/2026
    Thursday
    Course Project Topics Discussion
    NA
    NA
    Lin Ma
  • 01/20/2026
    Tuesday
    Consistency and Isolation Levels
    Serializable Snapshot Isolation in PostgreSQL
    Generalized Isolation Level Definitions
  • 01/22/2026
    Thursday
    Cloud OLTP
    Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases
    Amazon Aurora: On Avoiding Distributed Consensus for I/Os, Commits, and Membership Changes
  • 01/27/2026
    Tuesday
    Indexing
    Automatically Indexing Millions of Databases in Microsoft Azure SQL Database
    Automated Selection of Materialized Views and Indexes for SQL Databases
  • 01/29/2026
    Thursday
    Configuration Tuning
    λ-Tune: Harnessing Large Language Models for Automated Database System Tuning
    Automatic Database Management System Tuning Through Large-scale Machine Learning
  • 02/03/2026
    Tuesday
    Columnar Databases
    C-Store: A Column-oriented DBMS
    Column-Stores vs. Row-Stores: How Different Are They Really?
  • 02/05/2026
    Thursday
    Vectorized Query Processing
    MonetDB/X100: Hyper-Pipelining Query Execution & Vectorwise: Beyond Column Stores
  • 02/10/2026
    Tuesday
    Column-oriented Storage Format
    Dremel: Interactive Analysis of Web-Scale Datasets
    The striping and assembly algorithms & Dremel: A Decade of Interactive SQL Analysis at Web Scale
  • 02/12/2026
    Thursday
    Cloud Analytics
    Building An Elastic Query Engine on Disaggregated Storage
    The Snowflake Elastic Data Warehouse
  • 02/17/2026
    Tuesday
    Big Data Processing
    Resilient Distributed Datasets A Fault-Tolerant Abstraction for In-Memory Cluster Computing
    MapReduce: Simplified Data Processing on Large Clusters
  • 02/19/2026
    Thursday
    Lakehouse
    Delta Lake: High-Performance ACID Table Storage over Cloud Object Stores
    Lakehouse: A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics
  • 02/24/2026
    Tuesday
    Semantic Operators
    Cortex AISQL: A Production SQL Engine for Unstructured Data
    Semantic Operators and Their Optimization: Enabling LLM-Based Data Processing with Accuracy Guarantees in LOTUS
  • 02/26/2026
    Thursday
    Midterm
  • 03/03/2026
    Tuesday
    Winter Break
  • 03/05/2026
    Thursday
    Winter Break
  • 03/10/2026
    Tuesday
    Reusable Execution Engine
    Velox: Meta’s Unified Execution Engine
    The Composable Data Management System Manifesto
  • 03/12/2026
    Thursday
    Embedded Analytics
    Data Management for Data Science Towards Embedded Analytics & DuckDB-Wasm: Fast Analytical Processing for the Web
    DuckDB: an Embeddable Analytical Database
  • 03/17/2026
    Tuesday
    No Class
    Work on Mid-semester Project Presentation
  • 03/19/2026
    Thursday
    Mid-semester Project Presentations
  • 03/24/2026
    Tuesday
    Vector Index
    Efficient and robust approximate nearest neighbor search using Hierarchical Navigable Small World graphs
    Billion-scale similarity search with GPUs
  • 03/26/2026
    Thursday
    Hardware (GPU) Acceleration
    Query Processing on Tensor Computation Runtimes
    Rethinking Analytical Processing in the GPU Era
  • 03/31/2026
    Tuesday
    Evolving Databases for the Cloud and AI era
    NA
    Ippokratis Pandis, Distinguished Engineer, Databricks
  • 04/02/2026
    Thursday
    No Class
    Work on Project Final Presentation
  • 04/07/2026
    Tuesday
    MICE components for Data Analytics engines
    NA
    Felipe Aramburu, Distinguished Solution Architect, NVIDIA
  • 04/09/2026
    Thursday
    Scaling Postgres to the next level at OpenAI
    NA
    Bohan Zhang, Member of Technical Staff, OpenAI
  • 04/14/2026
    Tuesday
    No Class
    Work on Project Final Presentation
  • 04/16/2026
    Thursday
    Project Final Presentations 1
  • 04/21/2026
    Tuesday
    Project Final Presentations 2