Schedule

  • Date
    Topic
    Mandatory Reading
    Optional Reading
    Presenter
  • 01/09/2025
    Thursday
    Introduction and Data Models
    NA
    What Goes Around Comes Around
    Lin Ma
  • 01/14/2025
    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/16/2025
    Thursday
    Consistency and Isolation Levels
    Serializable Snapshot Isolation in PostgreSQL
    Generalized Isolation Level Definitions
    ZHAJIA, YUNTAOS
  • 01/21/2025
    Tuesday
    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
    ANDRENAN, SAIVAKA, EVANZIMM
  • 01/23/2025
    Thursday
    Indexing
    Automatically Indexing Millions of Databases in Microsoft Azure SQL Database
    Automated Selection of Materialized Views and Indexes for SQL Databases
    JAINARA, SKAMBH
  • 01/28/2025
    Tuesday
    Configuration Tuning
    Automatic Database Management System Tuning Through Large-scale Machine Learning
    AI Meets Database AI4DB and DB4AI
    RJWANG, YRPATEL
  • 01/30/2025
    Thursday
    Columnar Databases
    C-Store: A Column-oriented DBMS
    Column-Stores vs. Row-Stores: How Different Are They Really?
    STONEANN, SHRUJAIN
  • 02/04/2025
    Tuesday
    Vectorized Query Processing
    MonetDB/X100: Hyper-Pipelining Query Execution & Vectorwise: Beyond Column Stores
    JOSHROY, EMRAMEY
  • 02/06/2025
    Thursday
    Query Compilation
    Efficiently Compiling Efficient Query Plans for Modern Hardware
    Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask
    HAOTIANG, DOUGDONG, XZW
  • 02/11/2025
    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
    ARYANJ, JIMMYLI
  • 02/13/2025
    Thursday
    Cloud Analytics
    Building An Elastic Query Engine on Disaggregated Storage
    The Snowflake Elastic Data Warehouse
    PNADIPEL, BODIPATI
  • 02/18/2025
    Tuesday
    Big Data Processing
    Resilient Distributed Datasets A Fault-Tolerant Abstraction for In-Memory Cluster Computing
    MapReduce: Simplified Data Processing on Large Clusters
    NKUZA, PNHALIM, YSINHA
  • 02/20/2025
    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
    NAVEENU, ANIBHAS
  • 02/25/2025
    Tuesday
    Distributed SQL Engine
    Presto: A Decade of SQL Analytics at Meta
    SHAYLP, SOHILR, TOMASGL
  • 02/27/2025
    Thursday
    Midterm
  • 03/04/2025
    Tuesday
    Winter Break
  • 03/06/2025
    Thursday
    Winter Break
  • 03/11/2025
    Tuesday
    Reusable Execution Engine
    Velox: Meta’s Unified Execution Engine
    DIVYAMS, GNILAY
  • 03/13/2025
    Thursday
    Embedded Analytics
    Data Management for Data Science Towards Embedded Analytics & DuckDB-Wasm: Fast Analytical Processing for the Web
    DuckDB: an Embeddable Analytical Database
    MARCUSVC, PRAKHARG, KIRP
  • 03/18/2025
    Tuesday
    No Class
    Work on Mid-semester Project Presentation
  • 03/20/2025
    Thursday
    Mid-semester Project Presentations
  • 03/25/2025
    Tuesday
    Wide-column Stores
    Bigtable: A Distributed Storage System for Structured Data
    Cassandra - A Decentralized Structured Storage System
    ROHANSG, RWCHUA, FATTAHA
  • 03/27/2025
    Thursday
    Key-value Stores
    Dynamo: Amazon's Highly Available Key-value Store
    Eventual Consistency Today Limitations, Extensions, and Beyond
    JACQUIY, HANZHEG, YOLANDZ
  • 04/01/2025
    Tuesday
    Vector Index
    Efficient and robust approximate nearest neighbor search using Hierarchical Navigable Small World graphs
    Billion-scale similarity search with GPUs
    EVANGEBO, DQANXY
  • 04/03/2025
    Thursday
    No Class
    Work on Project Final Presentation
  • 04/08/2025
    Tuesday
    No Class
    Work on Project Final Presentation
  • 04/10/2025
    Thursday
    Adapting Velox Query Engine for AI/ML at Meta
    NA
    Pedro Pedreira, Software Engineer, Meta
  • 04/15/2025
    Tuesday
    Towards Building Autonomous Data Services on Azure
    NA
    Yuanyuan Tian, Principal Scientist Manager & Graph Architect, Microsoft Gray Systems Lab
  • 04/17/2025
    Thursday
    Project Final Presentations 1
  • 04/22/2025
    Tuesday
    Project Final Presentations 2