| March 30 |
1. Introduction
|
| April 1 |
2. Review of relational model and SQL
|
| April 3 |
3. DBMS architecture
|
| April 6 |
4. Data storage and buffer management
|
| April 8 |
5. Indexing
|
| April 10 |
Indexing continued
|
| April 13 |
7. Query execution and operator algorithms (part 1)
|
| April 15 |
8. Operator algorithms (part 2)
|
| April 17 |
9. External Memory Algorithms (part 3)
|
| April 20 |
10. Query Optimization: cost estimation
|
| April 22 |
11. Query Optimization: cost estimation (continued)
|
| April 24 |
12. Query Optimization: Search Space
|
| April 27 |
13. Query optimization: Search Algorithms
|
| April 29 |
14. Transactions: Concurrency control
|
| May 1 |
15. Transactions: Concurrency control
|
| May 4 |
16-18. Transactions: Optimistic concurrency Control
|
| May 6 |
16-17. Transactions: Optimistic concurrency Control (continued)
|
| May 8 |
Transactions: Optimistic concurrency control continued
|
| May 11 |
19. Transactions: Recovery
|
| May 13 |
20. Transactions: Recovery
|
| May 15 |
21. Transactions: Recovery
|
| May 18 |
MapReduce
|
| May 20 |
Parallel DBMSs
|
| May 22 |
Two Phase Commit
|
| May 27 |
Advanced Topics: Replication
|
| May 29 |
Advanced Topics
|
| June 1 |
Advanced Topics
|
| June 3 |
Query Optimization Review for Lab5
|
| June 5 |
Review
|