Important Dates
- 01/11 Assignment 1 handed out
- 02/01 Assignment 1 due
- 01/25 Assignment 2 handed out
- 02/13 Assignment 2 due
- 02/13 Assignment 3 handed out
- 03/20 Assignment 3 due
- 03/20 Assignment 4 handed out
- 04/24 Assignment 4 due
- 04/26 Optional Assignment due
- 04/26 Contest is due
- 02/13 Quiz 1 handout
- 02/27 Quiz 1 due
- 04/12 Quiz 2 handout
- 04/19 Quiz 2 due
- 03/20 Mid Term Exam, 1:50pm-3:05pm, Stuart Building 111
- 05/03 Final Exam, TBA
Schedule
The course schedule and linked slides will be updated over time. The slides are a modified version of the slides used by Hector Garcia-Molina for the CS 245 course at Stanford.
For convenience, here is a combined versions of all slides and all handouts (6 slides per page).
| 01/17 | 1. Introduction | slides or handout (6 slides per page) |
| 2. Hardware | slides or handout (6 slides per page) | |
| 01/17 | 3. Disk Organization | slides or handout (6 slides per page) |
| 01/18 | 4. Index Structures - Conventional Indexes and B-Trees | slides or handout (6 slides per page) |
| 01/23 | 4. Index Structures - Hashing | slides or handout (6 slides per page) |
| 01/25 | 4. Index Structures - Advanced Index Techniques | slides or handout (6 slides per page) |
| 01/30 | 5. Query Processing - Overview | slides or handout (6 slides per page) |
| 02/06 | 5. Query Processing - Parsing and Analysis | slides or handout (6 slides per page) |
| 02/08 | 5. Query Processing - Logical Optimization | slides or handout (6 slides per page) |
| 02/13 | 5. Query Processing - Query Execution | slides or handout (6 slides per page) |
| 02/15 | ||
| 02/20 | 5. Query Processing - Physical Optimization | slides or handout (6 slides per page) |
| 02/22 | ||
| 02/27 | ||
| 03/01 | ||
| 03/06 | ||
| 03/08 | 6. Recovery and Concurrency Control - Transaction Management | slides or handout (6 slides per page) |
| 03/20 | Mid Term Exam | Info |
| 03/22 | ||
| 03/27 | ||
| 03/29 | ||
| 04/03 | ||
| 04/05 | 6. Recovery and Concurrency Control - Failure and Recovery | slides or handout (6 slides per page) |
| 04/10 | ||
| 04/12 | ||
| 04/17 | 6. Recovery and Concurrency Control - Concurrency Control | slides or handout (6 slides per page) |
| 04/19 | ||
| 04/24 | ||
| 04/26 | Contest and QA Session | |
| 05/ | Final Exam | Info |