| March 29 |
1. Introduction
|
| March 31 |
2. Review of relational model and SQL
|
| April 2 |
3. DBMS architecture
|
| April 5 |
4. Data storage and buffer management
|
| April 7 |
5. Indexing
|
| April 9 |
Indexing continued
|
| April 12 |
7. Query execution and operator algorithms (part 1)
|
| April 14 |
8. Operator algorithms (part 2)
|
| April 16 |
9. External Memory Algorithms (part 3)
|
| April 19 |
10. Query plan costs
|
| April 21 |
11. Query Optimization: cost estimation
|
| April 23 |
12. Query Optimization: Search Space
|
| April 26 |
12. Query Optimization: Selinger Algorithm vs SimpleDB
|
| April 28 |
Transactions: Concurrency control
|
| April 30 |
14. Transactions: Concurrency control (part 2)
|
| May 3 |
15. Transactions: Locking
|
| May 5 |
16-17. Transactions: Optimistic concurrency Control
|
| May 7 |
16-17. Transactions: Optimistic concurrency Control (continued)
|
| May 10 |
18. Transactions: Recovery
|
| May 12 |
19. Transactions: Recovery (cont.)
|
| May 14 |
20. Transactions: Recovery (cont.)
|
| May 17 |
21. Transactions: Recovery (extra example)
|
| May 19 |
Parallel DBMSs
|
| May 21 |
Parallel DBMSs (continued)
|
| May 24 |
MapReduce
|
| May 26 |
Spark
|
| May 28 |
Two Phase Commit
|
| June 2 |
Replication
|
| June 4 |
NewSQL and Advanced Topics
|