Home
 Basic Info
 Blog
 Newsgroup
 Meetings
 Homeworks
 Lecture Notes
 Syllabus
 Resources
This syllabus is subject to change.

Date Lecture TopicHomework
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/01Boolean SearchHW 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