Date | Lecture Topic | Homework |
1/21 | Intro Lecture (Chap1) | Pass out HW0. |
1/23 | Relational Model (Chap3) | |
1/28 | Disks,Buffers,Files (Chap9). | HW0 due. Pass out HW1. |
1/30 | File Organizations and Indexing (Chap8). | |
2/04 | Tree-Structured Indexes (Chap10). | |
2/06 | Sorting (Chap13). | |
2/11 | Unary Hashing. | HW 1 due. Pass out HW2. |
2/13 | ER Models (Chap2) | |
2/18 | Relational Algebra (Chap4) | |
2/20 | Relational Calculus (Chap4) | |
2/25 | SQL: The Query Language (Chap5) | |
2/27 | SQL: The Query Language, cont (Chap 5). | |
3/04 | SQL: Constraints and APIs (Chap5) | HW 2 due. Pass out HW 3. |
3/06 | Relational Operators (Chap14) | |
3/11 | Relational Operators, cont. | HW 3 due. |
3/13 | Query Optimization (Chap15) | |
3/18 | Query Optimization, cont. | Pass out HW4. |
3/20 | Boolean Search | |
3/21 | | HW 4 due. |
4/01 | Physical Design & Tuning (Chap20). | Pass out HW 5. |
4/03 | Physical Design & Tuning, cont. | |
4/08 | Schema Refinement & Normalization, (Chap19) | |
4/10 | Schema Refinement & Normalization, cont. | |
4/17 | Concurrency Control (Chap17). | HW 5 due. |
4/15 | Transaction Management Overview (Chap16) | |
4/22 | Concurrency Control, cont. | |
4/24 | Logging and Recovery (Chap18) | |
4/29 | Logging and Recovery, cont. | |
5/01 | Ranked information retrieval (tentative) | |
5/13 | Wrapup | |