| January 6 |
Introduction
|
| January 8 |
Review of relational model and SQL
|
| January 10 |
DBMS architecture
|
| January 13 |
Data storage and buffer management
|
| January 15 |
Indexing
|
| January 17 |
Indexing continued
|
| January 22 |
Query execution and operator algorithms (part 1)
|
| January 24 |
Operator algorithms (part 2)
|
| January 27 |
Operator Algorithms (cont)
|
| January 29 |
Query plan costs
|
| January 31 |
Query Optimization: Search Space
|
| February 3 |
Query Optimization: Algorithms
|
| February 5 |
Query Optimization: Selinger Algorithm vs SimpleDB
|
| February 7 |
Transactions: Concurrency control
|
| February 10 |
Transactions: Concurrency control (cont.)
|
| February 12 |
Transactions: Locking
|
| February 14 |
Transactions: Optimistic concurrency Control
|
| February 19 |
Optimistic concurrency Control (cont.)
|
| February 21 |
Transactions: Recovery
|
| February 24 |
Transactions: Recovery (cont.)
|
| February 26 |
Transactions: Recovery cont. (extra example)
|
| February 28 |
Transactions: Recovery (Aries)
|
| March 3 |
Parallel DBMSs
|
| March 5 |
Parallel DBMSs (continued)
|
| March 7 |
MapReduce
|
| March 10 |
Spark
|
| March 12 |
Two Phase Commit
|
| March 14 |
Replication
|