Important Dates
- 01/13 Assignment 1 handed out
- 02/03 Assignment 1 due
- 02/03 Assignment 2 handed out
- 02/24 Assignment 2 due
- 02/24 Assignment 3 handed out
- 03/27 Assignment 3 due
- 03/27 Assignment 4 handed out
- 04/29 Assignment 4 due
- 05/10 Optional Assignment due
- 05/05 Contest is due
- 02/19 Quiz 1 handout
- 02/26 Quiz 1 due
- 04/14 Quiz 2 handout
- 04/22 Quiz 2 due
- 03/12 Mid Term Exam, 3:15pm-4:30pm, Stuart Building 104
- 05/09 Final Exam, 10:30am-12:30pm, Stuart Building 104
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/13 | 1. Introduction | slides or handout (6 slides per page) |
| 2. Hardware | slides or handout (6 slides per page) | |
| 01/15 | 3. Disk Organization | slides or handout (6 slides per page) |
| 01/22 | 4. Index Structures - Conventional Indexes and B-Trees | slides or handout (6 slides per page) |
| 01/27 | 4. Index Structures - Hashing | slides or handout (6 slides per page) |
| 01/29 | 4. Index Structures - Advanced Index Techniques | slides or handout (6 slides per page) |
| 02/03 | 5. Query Processing - Overview | slides or handout (6 slides per page) |
| 02/05 | 5. Query Processing - Parsing and Analysis | slides or handout (6 slides per page) |
| 02/10 | 5. Query Processing - Logical Optimization | slides or handout (6 slides per page) |
| 02/12 | 5. Query Processing - Query Execution | slides or handout (6 slides per page) |
| 02/19 | Quiz 1 | Info |
| 02/19 | 5. Query Processing - Physical Optimization | slides or handout (6 slides per page) |
| 02/24 | ||
| 02/26 | ||
| 03/03 | ||
| 03/05 | ||
| 03/10 | 6. Recovery and Concurrency Control - Transaction Management | slides or handout (6 slides per page) |
| 03/12 | Mid Term Exam | Info |
| 03/24 | ||
| 03/26 | ||
| 03/31 | ||
| 04/02 | ||
| 04/07 | 6. Recovery and Concurrency Control - Failure and Recovery | slides or handout (6 slides per page) |
| 04/09 | ||
| 04/14 | Quiz 2 | Info |
| 04/16 | 6. Recovery and Concurrency Control - Concurrency Control | slides or handout (6 slides per page) |
| 04/21 | ||
| 04/23 | ||
| 04/28 | ||
| 04/30 | Contest and QA Session | |
| 05/09 | Final Exam | Info |