Search:
Home
Basic Info
Blog
Newsgroup
Meetings
Homeworks
Lecture Notes
Syllabus
Resources
This syllabus is subject to change.
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
