Schedule (subject to change)
| week | date | day | topic | textbook | slides | homework | project |
|---|---|---|---|---|---|---|---|
Week 1 |
Jan 27 | Tu | Course Overview | Ch 1 |
|||
| Jan 29 | Th | Data Modeling | Ch 2, 3 |
||||
Week 2 |
Feb 3 | Tu | Relational Algebra and Calculus | Ch 4 |
|||
| Feb 5 | Th | SQL Overview | Ch 5 |
||||
Week 3 |
Feb 10 | Tu | Query Language Theory | ||||
| Feb 12 | Th | Normalization Theory | Ch 19 |
--> | groups formed |
||
Week 4 |
Feb 17 | Tu | Project Ideas | ||||
| Feb 19 | Th | Files, Buffers | Ch 9 |
||||
Week 5 |
Feb 24 | Tu | Tree Indexes (1) | Ch 8,10 |
|||
| Feb 26 | Th | Tree Indexes (2) | Ch 10 |
||||
Week 6 |
Mar 3 | Tu | Hashing | Ch 11,13 |
|||
| Mar 5 | Th | Query Processing 1 | Ch 14 |
||||
Week 7 |
Mar 10 | Tu | Query Processing 2 | Ch 14 |
|||
| Mar 12 | Th | Query Optimization 1 | Ch 15 |
proposal due |
|||
Week 8 |
Mar 17 | Tu | spring break | ||||
| Mar 19 | Th | ||||||
Week 9 |
Mar 24 | Tu | Query Optimization 2 | Ch 15 |
|||
| Mar 26 | Th | Concurrency Control (1) | Ch 16 |
||||
Week 10 |
Mar 31 | Tu | Recovery (Dr. Emmanuel Cecchet) | Ch 17 |
|||
| Apr 2 | Th | Concurrency Control (2) (Prof. Prashant Shenoy) |
Ch 18 |
||||
Week 11 |
Apr 7 | Tu | Midterm Review |
[pdf]
|
|||
| Apr 9 | Th | Midterm (7-9 pm), LGRC A301 | |||||
Week 12 |
Apr 14 | Tu | XML Basics | Apr 16 | Th | XML Query Language | |
Week 13 |
Apr 21 | Tu | Monday schedule | project update |
|||
| Apr 23 | Th | XML Query Processing | |||||
Week 14 |
Apr 28 | Tu | Data Streams | Apr 30 | Th | XML Data Streams | |
Week 15 |
May 5 | Tu | Database Security | ||||
| May 7 | Th | Project Presentations 1 |
presentation |
||||
Week 16 |
May 12 | Tu | Project Presentations 2 |
presentation |
|||
| May 14 | Th | ||||||
| Week 17 | May 19 | Tu |
final report due |
||||
| May 21 | Th | ||||||