| Week |
Date |
Topic |
Book Chapter(s) |
Assessment |
| 1 |
Mon 1/7 |
Review - Motivation
(pdf)
|
Chapter 1 |
|
| |
Wed 1/9 |
Review - Relational model
(pdf)
|
Chapters 2, 5.1, and 5.2 |
|
| |
Fri 1/11 |
Review - Relational model (continues)
|
|
HW1 out |
| 2 |
Mon 1/14 |
Network model
(pdf)
|
Appendix A and B
|
|
| |
Wed 1/16 |
XML
(pdf)
|
Chapters 10.1 and 10.2
|
A1 out
|
| |
Fri 1/18 |
Discussion of Codd paper (text of questions) |
|
|
| 3 |
Mon 1/21 |
no class, holiday
|
|
|
| |
Wed 1/23 |
no class, canceled
|
|
|
| |
Fri 1/25 |
no class, canceled
|
|
|
| 4 |
Mon 1/28 |
Logical Design
(pdf)
(pdf with examples)
|
Chapter 7, Appendix C
|
HW2 out |
| |
Wed 1/30 |
Logical Design (continues)
|
|
HW1 due |
| |
Fri 2/1 |
Logical Design (continues)
|
|
|
| 5 |
Mon 2/4 |
Logical Design (continues)
|
|
A1 due
|
| |
Wed 2/6 |
XPath
(pdf)
|
|
|
| |
Fri 2/8 |
OODBMS
(pdf)
|
Chapter 9 |
A2 out
|
| 6 |
Mon 2/11 |
OODBMS (continues)
|
|
|
| |
Wed 2/13 |
Discussion of ObjectStore paper
(text of questions)
|
|
|
| |
Fri 2/15 |
Midterm 1 Review
(pdf)
|
|
|
| 7 |
Mon 2/18 |
Class held Tuesday, holiday
|
|
|
| |
Tue 2/19 |
OODBMS (continues)
|
|
|
| |
Wed 2/20 |
Midterm 1
|
|
|
| |
Fri 2/22 |
Datalog (HTML)
|
Chapter 5.4 |
|
| 8 |
Mon 2/25 |
Datalog (continues)
|
|
|
| |
Wed 2/27 |
Datalog (continues)
|
|
HW2 due
|
| |
Fri 2/29 |
XQuery
(pdf)
|
|
|
| 9 |
Mon 3/3 |
Physical Design
(pdf)
|
Chapters 11 and 12
|
|
| |
Wed 3/5 |
Physical Design (continues)
|
|
HW3 out
|
| |
Thu 3/6 |
|
|
A2 due
|
| |
Fri 3/7 |
Physical Design (continues)
|
|
|
| Spring |
Break |
March 10-14
|
|
|
| 10 |
Mon 3/17 |
Query Processing and Optimization
(pdf)
|
Chapters 13 and 14
|
|
| |
Wed 3/19 |
Query Processing and Optimization (continues)
|
|
|
| |
Fri 3/21 |
Discussion of eXist paper
(txt of questions)
|
|
|
| 11 |
Mon 3/24 |
Review for Midterm 2
(pdf)
|
|
HW3 due
|
| |
Wed 3/26 |
Concurrency Control
(pdf)
|
Chapters 15 and 16
|
|
| |
Fri 3/28 |
Midterm 2
|
|
|
| 12 |
Mon 3/31 |
Concurrency Control (continues)
|
|
|
| |
Wed 4/2 |
Concurrency Control (continues)
|
|
A3 out
|
| |
Fri 4/4 |
Concurrency Control (continues)
|
|
|
| 13 |
Mon 4/7 |
Concurrency Control (continues)
|
|
HW4 out
|
| |
Wed 4/9 |
Recovery
(pdf)
|
Chapter 17 |
|
| |
Fri 4/11 |
No class
|
|
|
| 14 |
Mon 4/14 |
Recovery (continues)
|
|
|
| |
Wed 4/16 |
OLAP
(pdf)
|
|
HW4 due
|
| |
Fri 4/18 |
Security
(pdf)
|
|
|
| 15 |
Mon 4/21 |
No class
|
|
|
| |
Wed 4/23 |
Review for Final Exam
(pdf)
|
|
A3 due
|
| |
Fri 4/25 |
No class
|
|
|
| Final |
|
|
|
|