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