| 1 (Sep 10) |
1 |
Course introduction; Structured Data Management: Introduction to Database Systems |
Yuhan Liu & Mahdi Esmailoghli |
|
| 2 (Sep 15) |
1 |
Introduction to Database Systems |
Yuhan Liu |
|
| |
2 |
Relational model of data, relational calculus & algebra |
Yuhan Liu |
|
| 3 (Sep 22) |
1 |
Relational algebra, SQL |
Yuhan Liu |
|
| |
2 |
Database Workloads (OLTP, OLAP & HTAP systems) |
Yuhan Liu |
|
| 4 (Sep 29) |
1 |
Big data: Dealing with volume |
Yuhan Liu |
|
| |
2 |
Big data: Dealing with volume |
Yuhan Liu |
|
| 5 (Oct 6) |
1 |
Big data: Dealing with variety |
Yuhan Liu |
|
| |
2 |
Big data: Dealing with variety + velocity |
Yuhan Liu |
|
| 6 (Oct 10–18) |
|
Reading week - no classes |
|
|
| 7 (Oct 20) |
1 |
Big data: Dealing with velocity |
Yuhan Liu |
|
| |
2 |
Cloud computing & cloud-native data management |
Yuhan Liu |
|
| 8 (Oct 27) |
1 |
Data integration: Data warehouses |
Mahdi Esmailoghli |
|
| |
2 |
Data integration: Data lakes (virtual lecture; DC 1302) |
Mahdi Esmailoghli |
|
| 9 (Nov 3) |
1 |
Data preparation pipeline (virtual lecture; DC 1302) |
Mahdi Esmailoghli |
|
| |
2 |
Data integration: Data lakehouses (virtual lecture; DC 1302) |
Mahdi Esmailoghli |
|
| 10 (Nov 10) |
1 |
Data acquisition |
Mahdi Esmailoghli |
|
| |
2 |
Data profiling (virtual lecture over zoom) |
Mahdi Esmailoghli |
|
| 11 (Nov 17) |
1 |
Data quality & data cleaning |
Mahdi Esmailoghli |
|
| |
2 |
Data provenance |
Mahdi Esmailoghli |
|
| 12 (Nov 24) |
1 |
Data quality & data cleaning |
Mahdi Esmailoghli |
|
| |
2 |
LLMs and data management (virtual lecture; DC 1304) |
Mahdi Esmailoghli |
|
| 13 (Dec 1) |
1 |
Vector databases (virtual lecture; DC 1302) |
Mahdi Esmailoghli |
|
| |
2 |
Review and general discussion |
Yuhan Liu & Mahdi Esmailoghli |
|
| 14 (Dec 8) |
|
Reserved (buffer day in case a class needs to be rescheduled) |
|
|
| TBD |
|
Final Exam (Time TBD) Location TBD |
|
|