Important Dates
- 01/20 Coding Assignment 1 handed out
- 02/10 Coding Assignment 1 due
- 02/11 Coding Assignment 2 handed out
- 03/02 Coding Assignment 2 due
- 03/03 Coding Assignment 3 handed out
- 04/01 Coding Assignment 3 due
- 04/02 Coding Assignment 4 handed out
- 04/29 Coding Assignment 4 due
- 05/04 Optional Assignment due
- 02/23 Quiz 1 handed out
- 02/27 Quiz 1 due (via Blackboard)
- 04/12 Quiz 2 handed out
- 04/18 Quiz 2 due (via Blackboard)
- 03/28 MidTerm EXAM, 1:50-3.05PM, room TBD
- 05/08 Final EXAM, 10:30 am - 12:30 pm, Robert A. Pritzker Science Ctr 121
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/15 | 0. Course Organization | slides |
| 1. Introduction | slides | |
| 01/17 | 2. Hardware | slides |
| 01/22 | 3. File and System Structure | slides |
| 01/29 | 4. Index Structures - Conventional Indexes and B+-Trees | slides |
| 02/12 | 4. Index Structures - Hashing | slides |
| 02/19 | 5. Index Structures - Multi-dimensional indexes | slides |
| 03/05 | 6. Query Processing - Overview | slides |
| 03/05 | 6. Query Processing - Parsing and Pre-Processing | slides |
| 03/07 | 6. Query Processing - initial LQP | slides |
| 03/12 | 6. Query Processing - Logical Optimization | slides |
| 03/18 -23 | No Class | Spring Break Week |
| 04/02 | 6. Query Processing - Execution | slides |
| 04/11 | 6. Query Processing - Physical Optimization | slides |
| 04/18 | 7. Recovery and Concurrency Control - Failure and Recovery | slides |
| 04/30 | 8. Recovery and Concurrency Control - Concurrency Control | slides |