The class calendaris kept online in both [HTML]and
[
ical]format.
This schedule is subject to
change so check it frequently. In
particular, check for changes to duedates and guest
lectures.
Note: in general, the pdf files are larger (in bytes) than the ppt files.
|
WK |
Class/Date |
Topic |
Book Chapter |
Events |
Lecture Notes |
Section Notes | |
|
1 |
T 1/21 |
Introduction |
1 |
[6up PDF] [ppt] | |||
|
Th 1/23 |
The Relational Model |
3 |
[4up PDF] [ppt] | ||||
|
2 |
T 1/28 |
Storing Data: Disks and Files |
9 |
[6up PDF] [ppt] | Exercise Solution | ||
|
Th 1/23 |
File Organizations and Indexing | 8 | [6up PDF] [ppt] | Exercise Solution | |||
|
3 |
T 2/4 |
Tree-Structured Indexes |
10 |
[6up PDF] [ppt] | BTree demo Exercise Solution | ||
|
Th 2/6 |
External Sorting | 11 | [6up PDF] [ppt] | ||||
|
4 |
T 2/18 |
Single-Table Query Processing |
all over! |
[6up PDF] [ppt] | |||
|
Th 2/13 |
Single-Table QP, cont. | ||||||
|
5 |
T 2/18 |
The Entity-Relationship Model |
2 |
[6up PDF] [ppt] | Exercise Solution | ||
|
Th 2/20 |
ER-to-relational mappings; Relational Algebra | 2;4 |
[6up PDF]
[ppt] [6up PDF] [ppt] |
||||
|
6 |
T 2/25 |
Relational Calculus |
4 |
[6up PDF] [ppt] | Exercise Solution Notes | ||
|
Th 2/27 |
SQL | 5 | [6up PDF] [ppt] | ||||
|
7 |
T 3/4 |
SQL II |
5 |
[6up PDF] [ppt] | |||
|
Th 3/6 |
SQL III | 5 | [6up PDF] [ppt] | Exercise Solution | |||
| Midterm review session | Part 1[ppt] [pdf] Part 2[ppt] [pdf] Part 3 [ppt] [pdf] | ||||||
|
8 |
T 3/11 |
Relational Operators |
14 |
[6up PDF] [ppt] | Exercise Solution | ||
|
Th 3/13 |
Query Optimization | 12/15 | [6up PDF] [ppt] | Exercise Solution | |||
|
9 |
T 3/18 |
Query Optimization, cont. |
12/15 |
||||
|
Th 3/20 |
Query Optimization, cont. | 12/15 | |||||
|
10 |
T 3/25 |
Spring Break |
|
||||
|
Th 3/27 |
Spring Break | ||||||
|
11 |
T 4/1 |
Query Optimization, cont. |
|
||||
|
Th 4/3 |
Boolean Search | not in book | [6up PDF] [ppt] | ||||
|
12 |
T 4/8 |
Functional Dependencies & Normalization |
19 |
[6up PDF] [ppt] | |||
|
Th 4/10 |
FDs and Normalization, cont. | 19 | [6up PDF] [ppt] | Notes Textbook 19.8 Sol Textbook 19.10 Sol | |||
|
13 |
T 4/15 |
Physical Design and Tuning | 20 | [6up PDF] [ppt] | |||
|
Th 4/17 |
Introduction to Transactions | 16 | [6up PDF] [ppt] | ||||
|
14 |
T 4/22 |
Concurrency Control | 17 | [6up PDF] [ppt] | Exercise Solution | ||
|
Th 4/24 |
More concurrency control | 17 | [6up PDF] [ppt] | Solution | |||
|
15 |
T 4/29 |
Logging and Recovery | 18 | [6up PDF] [ppt] | Exercise Solution | ||
|
Th 5/1 |
Logging and Recovery, cont. | ||||||
|
16 |
T 5/6 |
XML and XQuery | Guest Lecture | [6up PDF] [ppt] | |||
|
Th 5/8 |
Object Relational Database Systems | 23 | [6up PDF] [ppt] | ||||
|
17 |
T 5/13 |
Ranked Retrieval & Final Notes | not in book |
[search, 6up PDF]
[search, ppt] [wrapup, 6up PDF] [wrapup, ppt] |
|||
| Final Review Session | Part 1[ppt] Part 2[ppt]Part 3 [ppt] |