CSE 444 Winter 2024
Lecture Topics

Subscribe to this calendar (Google, iCal, etc.)

DateDescription
January 3 Introduction
January 5 Review of relational model and SQL
January 8 DBMS architecture
January 10 Data storage and buffer management
January 12 Indexing
January 17 Indexing continued
January 19 Query execution and operator algorithms (part 1)
January 22 Operator algorithms (part 2)
January 24 Operator Algorithms (cont)
January 26 External Memory Algorithms (cont)
January 29 Query plan costs
January 31 Query Optimization: Search Space
February 2 Query Optimization: Algorithms
February 5 Query Optimization: Selinger Algorithm vs SimpleDB
February 7 Transactions: Concurrency control
February 9 Transactions: Locking
February 12 Transactions: Optimistic concurrency Control
February 14 Transactions: Optimistic concurrency Control (cont.)
February 16 Transactions: Optimistic concurrency Control (cont.)
February 21 Transactions: Recovery
February 23 Transactions: Recovery cont.
February 26 Transactions: Recovery with ARIES
February 28 Transactions: Recovery wrap-up
March 1 Parallel DBMSs
March 4 MapReduce MapReduce
March 6 Two Phase Commit
March 8 Replication