E0261 Database Management Systems (January 2021)

Course Notes (in PDF format)

  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)