E0 261 Class Schedule (August 2023)

[MW 8.30 - 10.00]

August
05 Organizational Class
14 DBMS Overview
16 Query Optimization (Basics)
21 Query Optimization (System R)
23 Query Optimization (Plan Diagrams)
28 Cardinality Estimation (Histograms)
30 Cardinality Estimation (Sampling)
September  
04 Query Execution (Plan Bouquets)
06 Query Execution (Plan Bouquets)
11 Projects Discussion
13 Projects Discussion
18 Access Structures (Linear Hashing)
20 Access Structures (Bitmap Indexes)
25 Access Structures (Bitmap Indexes)
27 Transaction Concurrency (Locking)
October  
02 Transaction Recovery (Basics)
04 Transaction Recovery (ARIES)
09 Memory Management (LRU-K)
11 Study Holiday
14 (Sat) Mid-term Exam
18 Distributed Databases (Query Processing)
20 Distributed Databases (Transactions)
25 Data Mining (Apriori)
27 Data Mining (Viper)
30 Data Warehousing (Cube)
November  
01 Data Warehousing (Views)
06 Main-Memory Databases (Join)
08 Main-Memory Databases (Index)
13 Columnar Databases (C-Store)
15 Columnar Databases (Index)
20 BUFFER
22 BUFFER
26 Final Exam
December  
09 Project Submission
11 Project Presentations
15 Grade Submission