Please note: this course schedule may change over time.
|
Date |
|
Topic |
Suggested |
Remarks |
|
Fri August 29 |
|
Data Streams – The Cayuga System (talk given by Al Demers) |
|
Please print and sign academic integrity form for next class |
|
Mon Sept. 1 |
|
Course overview and introduction to data management (slides) |
1.1-1.6 |
Bring signed academic integrity form to class |
|
Wed Sept. 3 |
|
Course overview and introduction to data management (ctd.) |
|
|
|
Fri Sept. 5 |
|
ER model (slides) |
2.1 to 2.8 |
|
|
Mon Sept. 8 |
|
Relational model (slides) |
3.1-3.7, 3.10-3.17 |
|
|
Wed Sept. 10 |
|
Disks and files (slides) |
9.1-9.4, 9.7-9.14 9.16-9.20, 9.22 |
|
|
Fri Sept. 12 |
|
Disks and files (ctd.) |
|
|
|
Mon Sept. 15 |
|
Relational algebra (slides) |
4.1-4.7 (ignore tuple relational calculus) |
|
|
Wed Sept. 17 |
|
Relational algebra (ctd.) – in-class practice |
|
|
|
Fri Sept. 19 |
|
Relational algebra (ctd.) |
|
|
|
Mon Sept. 22 |
|
SQL (slides) |
5.1-5.5, 5.7-5.8, 5.10 |
|
|
Wed Sept. 24 |
|
SQL |
|
|
|
Fri Sept. 26 |
|
SQL |
|
CS4321 Assignment 1 due 11:59pm in CMS |
|
Mon Sept. 29 |
|
SQL |
|
|
|
Wed Oct. 1 |
|
File organization and indexing (slides) |
8.1-8.11 |
CS4320 Assignment 1 due 11:59pm in CMS |
|
Fri Oct. 3 |
|
Tree structured indexing (slides) |
10.1-10.5, 10.7-10.11 |
|
|
Mon Oct. 6 |
|
Hash-based indexing (slides) |
11.1-11.10 |
|
|
Wed Oct. 8 |
|
External sorting (slides) |
13.1-13.5 |
|
|
Fri Oct. 10 |
|
Overview of Query Evaluation and Optimization (slides) |
|
|
|
Mon Oct. 13 |
|
No class (fall break) |
|
|
|
Wed Oct. 15 |
|
Evaluation of relational operators (slides) |
14.1-14.7 |
CK traveling, lecture given by J. Gehrke; CS4321 Assignment 2 due 11:59pm in CMS |
|
Fri Oct. 17 |
|
Evaluation of relational operators (ctd.) (slides) |
|
CK traveling, lecture given by J. Gehrke; CS4320 Assignment 2 due 11:59pm in CMS |
|
Mon Oct. 20 |
|
Pre-midterm discussion; questions&answers |
|
|
|
Wed Oct. 22 |
|
Evaluation of relational operators (ctd.) |
|
|
|
Thu Oct. 23 |
|
--- |
|
Midterm Exam, 7:30pm |
|
Fri Oct. 24 |
|
Query optimization (slides) |
15.1-15.5, 15.7-15.9 |
|
|
Mon Oct. 27 |
|
Query optimization (ctd.) |
|
|
|
Wed Oct. 29 |
|
Query optimization (ctd.) |
|
|
|
Fri Oct. 31 |
|
Concurrency control
(slides1) |
16.1-16.3 |
|
|
Mon Nov. 3 |
|
Concurrency control
(slides 2) |
17.1, 17.2, 17.4-17.8, 17.10-17.12 |
CS4320 Assignment 3 due 11:59pm in CMS |
|
Wed Nov. 5 |
|
Concurrency control (ctd.) |
|
|
|
Fri Nov. 7 |
|
Concurrency control
(ctd.) |
|
CS4321 Assignment 3 due 11:59pm in CMS |
|
Mon Nov. 10 |
|
Recovery (slides) |
18.1-18.5, 18.7, 18.8 |
|
|
Wed Nov. 12 |
|
Recovery (ctd), Concurrency control exercises. |
|
|
|
Fri Nov. 14 |
|
Schema design and
normal forms (slides) |
19.1-19.8, 19.10-19.12, 19.24, 19.25 |
|
|
Mon Nov. 17 |
|
Schema design and
normal forms |
|
|
|
Wed Nov. 19 |
|
Database tuning
(slides) |
20.1-20.9 |
CS4320 Assignment 4 due 11:59pm in CMS |
|
Fri Nov. 21 |
|
Database tuning (ctd) |
|
|
|
Mon Nov. 24 |
|
Data warehousing and OLAP (slides) |
25.1 |
|
|
Wed Nov. 26 |
|
No class (Thanksgiving break) |
|
|
|
Fri Nov. 28 |
|
No class (Thanksgiving break) |
|
|
|
Mon Dec. 1 |
|
Managing uncertain
data |
(not for the final exam) |
|
|
Wed Dec. 3 |
|
Managing uncertain
data |
(not for the final exam) |
|
|
Fri Dec. 5 |
|
Conclusions |
|
|