E0261 Database Management Systems (January 2021)

Course Notes (in PPS format)

  Introductory Class 

  Background Review 

  Query Optimization (System R) 

  Query Optimization (Plan Reduction) 

  Query Statistics (Histograms) 

  Query Statistics (Sampling) 

  Query Processing (Plan Bouquets) 

  Access Structures (Linear Hashing) 

  Access Structures (Bitmap Indices) 

  Transaction Management (Locking) 

  Transaction Management (Recovery) 

  Distributed Databases 

  Data Mining (Apriori) 

  Data Mining (Viper) 

  Data Warehousing (Cube) 

  Data Warehousing (Views) 

  Main Memory Databases (Join Processing) 

  Main Memory Databases (Indexing) 

  Columnar Databases (CStore) 

  Columnar Databases (Reconstruction) 

  DB and ML (Database Tuning) 

  Big Data (Giraph)