| Week |
Day |
Topic(s) |
Readings |
Quizzes |
| Week 1 |
08/27/2015 |
Intro + Logistics |
Chapter 1 |
|
| 08/28/2015 |
Disks- Part 1 |
Chapter 13.1 & 13.2 |
||
Week 2 |
08/31/2015 |
Disks- Part 2 |
Chapter 13.3 & 13.4.1-3 | |
| 09/01/2015 |
Cancelled (Instructor attending conference) |
|||
| 09/03/2015 | Record Storage | Chapter 13.5 & 13.6.1-2 & 13.7.1-3 | ||
| 09/04/2015 | Buffer Management | Chapter 15.7 | Quiz 1 |
|
Week 3 |
09/07/2015 | Off (Labor Day) |
||
| 09/08/2015 | External Sorting | Chapter 14.4.1 | ||
| 09/10/2015 | Types of Indexing- Part 1 |
Chapter 14.1 | ||
| 09/11/2015 | Types of Indexing- Part 2 |
|||
Week 4 |
09/14/2015 | B-Tree Index - Part 1 |
Chapter 14.2 |
|
| 09/15/2015 | B-Tree Index - Part 2 | Quiz 2 |
||
| 09/17/2015 | B-Tree Index - Part 3 | |||
| 09/18/2015 | Revision for Midterm exam |
|||
Week 5 |
09/21/2015 | Midterm Exam | ||
| 09/22/2015 | Hash Indexing | Chapter 14.3 (until end of 14.3.6) |
||
| 09/24/2015 | Query Processing- Part 1 |
Chapter 15.1 |
||
| 09/25/2015 | Query Processing- Part 2 | Chapter 15.2 | ||
Week 6 |
09/28/2015 | Query Optimization- Part 1 | Chapter 15.3 & 15.5 |
|
| 09/29/2015 | Query Optimization- Part 2 | Chapter 15.6 & 16.4 |
||
| 10/01/2015 | Query Estimation |
Chapter 15.6 & 16.4 | ||
| 10/02/2015 | Transactions |
Chapter 18.1 |
Quiz 3 |
|
Week 7 |
10/05/2015 | Concurrency Control - Part 1 | Chapter 18.2 |
|
| 10/06/2015 | Concurrency Control - Part 2 | Chapter 18.2 |
||
| 10/08/2015 | Recovery Control - Part 1 |
Chapter 17.1, 17.2 |
||
| 10/09/2015 | Recovery Control - Part 2 |
Chapter 17.4 | Quiz 4 |
|
Week 8 |
10/12/2015 | Revision for Final Exam |
||
| 10/13/2015 | Intro to Advanced Topics: Hadoop & NoSQL DBs (outside Exam's scope) |
|||
| 10/15/2015 | Final Exam |
|||