E0261 Database Management Systems (January 2021)

Course Videos (in MP4 format)

  Introductory Class 

  Background Review 


  Query Optimization (Basics) 

  Query Optimization (System R) 

  Query Optimization (Plan Diagrams) 

  Query Statistics (Histograms) 

  Query Statistics (Sampling) 

  Query Processing (Plan Bouquets) 

  Access Structures (Linear Hashing) 

  Access Structures (Bitmap Indices) 

  Access Structures (Optimal Bitmap Indices) 

  Transaction Management (Locking) 

  Transaction Management (Recovery) 

  Transaction Management (ARIES) 

  Distributed Databases (Query Processing) 

  Distributed Databases (Transaction Processing) 

  Data Mining (Apriori) 

  Data Mining (Viper) 

  Data Warehousing (Cube) 

  Data Warehousing (Views)  Part 1
  Data Warehousing (Views)  Part 2

  Main Memory Databases (Join Processing) 

  Main Memory Databases (Indexing) 

  Columnar Databases (CStore) 

  Columnar Databases (Reconstruction) 

  DB and ML (Database Tuning)  [Anupam Sanghi]

  Big Data (Giraph)  [Shivani Tripathi]