|
|
Last Year's Syllabus (Hellerstein/Garofalakis)
Tentative syllabus, subject to change. Last updated 10/11/06
| Date |
Topic |
Chapter in R&G |
|
| 8/30 |
intro |
1 |
|
| 9/1 |
Relational Model |
3 |
|
| 9/5 |
Disks + Files |
9, skip 9.2 |
|
| 9/7 |
Indexes 1/2 |
10 |
|
| 9/12 |
Indexes 2/2 |
10 |
|
| 9/15 |
Sorting |
13 |
|
| 9/19 |
Relational algebra |
4.1, 4.2 |
Pass out HW 1 |
| 9/21 |
Relational calculus |
4.3, 4.4 |
|
| 9/26 |
SQL 1 |
5 |
|
| 9/28 |
Relational Ops 1 (unary) |
12.1-12.3, 14.1-14.3 |
|
| 10/3 |
Relational Ops 2 (joins) |
14.4-14.6 |
HW 1 due |
| 10/5 |
Boolean text search |
27.1-27.3.1 |
|
| 10/10 |
Q-Optimization 1 |
15 |
HW 2 passed out 10/8 |
| 10/12 |
Q-Optimization 2 |
15 |
|
| 10/17 |
Physical design |
20 |
|
| 10/19 |
ER Model |
2 (can skip 2.7) |
|
| 10/24 |
Normalization I |
19 |
|
| 10/26 |
Midterm |
|
Solutions |
| 10/31 |
Normalization II |
19 |
HW 2 due |
| 11/2 |
SQL 2 + Query Rewrite |
5 |
Normalization Lab, 11/1.
HW3 (SQL) passed out |
| 11/7 |
Intro to transactions |
16 |
|
| 11/9 |
CC 1 |
17 |
HW3 due. |
| 11/14 |
CC 2 |
17 |
|
| 11/16 |
CC 3 |
17 |
Pass out HW 5 |
| 11/21 |
Recovery 1 |
18 |
HW 5 due; Pass out HW 6 |
| 11/28 |
Recovery 2 |
18 |
|
| 11/30 |
Data parallelism: relational and websearch |
22 |
|
| 12/5 |
Ranked text search |
27.4 |
HW 6 due |
| 12/7 |
Advanced topic/summary |
|
|
|
|
Home