Important Dates
- 01/19 Problem Set 1 handed out
- 01/26 Problem Set 1 due (via Blackboard)
- 01/24 Coding Assignment 1 handed out
- 02/12 Coding Assignment 1 due
- 02/14 Coding Assignment 2 handed out
- 02/19 Problem Set 2 handed out
- 02/22 Problem Set 2 due (via Blackboard)
- 02/22 Quiz 1 handed out
- 02/27 Quiz 1 due (via Blackboard)
- 03/23 Coding Assignment 2 due
- 03/23 Coding Assignment 3 handed out
- 03/30 Problem Set 3 handed out
- 04/11 Problem Set 3 due (via Blackboard)
- 04/27 Coding Assignment 3 due
Schedule
The course schedule and linked slides will be updated over time. The slides mainely are a modified version of the slides used by Hector Garcia-Molina for the CS 245 course at Stanford.
| 01/08 | 0. Course Organization | slides |
| 1. Introduction | slides | |
| 01/10 | 2. Hardware | slides |
| 01/15 | No Class | Martin Luther King Jr. Day |
| 01/17 | 3. File and System Structure | slides |
| 01/24 | 4. Index Structures - Conventional Indexes | slides |
| 01/31 | 4. Index Structures - B-Trees | slides |
| 02/05 | 5. Index Structures - Hashing | slides |
| 02/12 | 6. Index Structures - Multi-dimensional indexes | slides |
| 02/26 | 7. Query Processing - Overview | slides |
| 02/28 | 8. Query Processing - Parsing and Pre-Processing | slides |
| 03/07 | 8. Query Processing - initial LQP | slides |
| 03/12 -17 | No Class | Spring Break Week |
| 03/19 | 9. Query Processing - Logical Optimization | slides |
| 03/28 | 10. Query Processing - Execution | slides |
| 04/09 | 11. Recovery and Concurrency Control - Failure and RecoverY | slides |
| 04/18 | 12. Recovery and Concurrency Control - Concurrency Control | slides |