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