Schedule (subject to change)
| week | date | day | topic | textbook | slides | homework | reproducibility |
research |
|---|---|---|---|---|---|---|---|---|
Week 1 |
Feb 2 | Tue | Overview & Relational Model | Ch 1 |
||||
| Feb 4 | Thu | Relational Algebra 1 | Ch 4 |
|||||
Week 2 |
Feb 9 | Tue | Relational Algebra 2 & Calculus | Ch 4 |
||||
| Feb 11 | Thu | SQL Overview 1 | Ch 5 |
|||||
Week 3 |
Feb 16 | Tue | SQL Overview 2 | Ch 5 |
||||
| Feb 18 | Thu | Language and Normalization Theory | Ch 19 |
project selected |
||||
Week 4 |
Feb 23 | Tue | Normalization Theory 2 | Ch 19 |
||||
| Feb 25 | Thu | Disks, Files | Ch 8,9 |
|||||
Week 5 |
Mar 2 | Tue | Files, Indexes | Ch 8,10 |
||||
| Mar 4 | Thu | Query Processing 1 | Ch 13, 14 |
proposal |
||||
Week 6 |
Mar 9 | Tue | Query Processing 2 | Ch 14 |
||||
| Mar 11 | Thu | Query Optimization 1 | Ch 15 |
|||||
Week 7 |
Mar 16 | Tue | Query Optimization 2 | Ch 15 |
||||
| Mar 18 | Thu | Concurrency Control 1 | Ch 16 |
|||||
Week 8 |
Mar 23 | Tue | Concurrency Control 2 & Recovery 1 | Ch 17,18 |
team formed |
|||
| Mar 25 | Thu | Recovery 2 | Ch 17,18 |
status report 1 |
||||
Week 9 |
Mar 30 | Tue | Project: Advanced Data Analytics |
[video]
|
||||
| Apr 1 | Thu | Midterm Review | ||||||
Week 10 |
Apr 6 | Tue | Midterm Exam | |||||
| Apr 8 | Thu | Data Warehousing & OLAP | Ch 25 |
review + proposal |
||||
Week 11 |
Apr 13 | Tue | Data Warehouses & Data Mining | Ch 25 |
Apr 15 | Thu | Data Mining & Parallel Databases | Ch 25 |
Week 12 |
Apr 20 | Tue | No Class (Wed Schedule) | |||||
| Apr 22 | Thu | MapReduce & Spark | status report 2 |
|||||
Week 13 |
Apr 27 | Tue | Spark & Project Presentations 1 |
presentation |
Apr 29 | Thu | Project Presentations 2 |
presentation |
Week 14 |
May 4 | Tue | Project Presentations 3 |
presentation |
||||
| May 6 | Thu |
final report |
final report |
|||||
Week 15 |
May 11 | Tue | ||||||
| May 13 | Thu |