| Date |
Day |
Lecture (and what to read) |
Instructor |
Due-date (FIRM) |
| 8/28 |
Tu |
Introduction (R&G Chapter 1) |
Faloutsos |
|
| 8/30 |
Th |
The Entity-Relationship Model (R&G Chapter 2) |
Faloutsos |
Asn. 1 released |
| 9/4 |
Tu |
Relational Model (R&G Chapter 3) |
Faloutsos |
|
| 9/6 |
Th |
The Relational Algebra (R&G Chapter 4) |
Faloutsos |
|
| 9/11 |
Tu |
The Relational Calculus (R&G Chapter 4) |
Faloutsos |
Asn. 1 due, Asn. 2 released |
| 9/13 |
Th |
SQL: The Query Language Part 1 (R&G Chapter 5) |
Faloutsos |
|
| 9/18 |
Tu |
SQL: The Query Language Part 2 (R&G Chapter 5) |
Gibson |
Asn. 2 due, Asn. 3 released |
| 9/20 |
Th |
Storing Data - Disks, Buffers, and Files (R&G Chapter 9) |
Gibson |
|
| 9/25 |
Tu |
SQL Application Development (R&G Chapter 6) |
Faloutsos |
Asn. 3 due, Asn. 4 released |
| 9/27 |
Th |
File Organizations & Indexing (R&G Chapter 8) |
Gibson |
|
| 10/2 |
Tu |
Tree-Structured Indexes (R&G Chapter 10) |
Gibson |
Asn. 4 due, Asn. 5 released |
| 10/4 |
Th |
Sorting |
Gibson |
|
| 10/9 |
Tu |
Relational Operators (R&G Chapter 12/14) |
Faloutsos |
|
| 10/11 |
Th |
Relational Operators continued (R&G Chapter 12/14) |
Faloutsos |
Asn. 5 due, Asn. 6 released |
| 10/16 |
Tu |
Midterm Review |
Faloutsos |
|
| 10/18 |
Th |
** MIDTERM EXAM ** |
|
** MIDTERM EXAM ** |
| 10/23 |
Tu |
Query Optimization (R&G Chapter 15) |
Gibson |
Asn. 6 due, Asn. 7 released |
| 10/25 |
Th |
Query Optimization (R&G Chapter 15 PLUS System R Optimizer) |
Gibson |
|
| 10/30 |
Tu |
Schema Refinement and Normalization (part 1) |
Faloutsos |
Asn. 7 due, Asn. 8 released |
| 11/1 |
Th |
Schema Refinement and Normalization (part2) (R&G Chapter 19) ; Physical Database Design and Tuning (R&G Chapter 20) |
Faloutsos |
|
| 11/6 |
Tu |
Transaction Management Overview (R&G Chapter 16) |
Gibson |
Asn. 8 due, Asn. 9 released |
| 11/8 |
Th |
Concurrency Control (R&G Chapter 17) |
Gibson |
|
| 11/13 |
Tu |
Spatial Data Management (R&G Chapter 28) |
Faloutsos |
|
| 11/15 |
Th |
Semistructured Data Management |
Faloutsos |
|
| 11/20 |
Tu |
Concurrency Control (R&G Chapter 17) |
Gibson |
Asn. 9 due, Asn. 10 released |
| 11/22 |
Th |
NO CLASS (THANKSGIVING) |
|
|
| 11/27 |
Tu |
Concurrency Control (R&G Chapter 17) |
Gibson |
|
| 11/29 |
Th |
Logging and Recovery (R&G Chapter 18) |
Gibson |
Asn. 10 due |
| 12/4 |
Tu |
Logging and Recovery (R&G Chapter 18) |
Gibson |
|
| 12/6 |
Th |
Review |
Faloutsos |
|
