CS738

Syllabus & Schedule (Unless otherwise indicated, courses are in-person)

Week Lecture Topic Speaker Materials
1 (Sep 10) 1 Course introduction; Structured Data Management: Introduction to Database Systems Yuhan Liu & Mahdi Esmailoghli 01 Lecture Notes
02 Course Info
03 Introduction
2 (Sep 15) 1 Introduction to Database Systems Yuhan Liu  
  2 Relational model of data, relational calculus & algebra Yuhan Liu Relational Model
3 (Sep 22) 1 Relational algebra, SQL Yuhan Liu SQL
  2 Database Workloads (OLTP, OLAP & HTAP systems) Anil Goel Workloads
4 (Sep 29) 1 Big data: Dealing with volume Yuhan Liu BigData-Volume
  2 Big data: Dealing with volume Yuhan Liu  
5 (Oct 6) 1 Cloud computing & cloud-native data management Ronen Grosman Cloud Native Database
  2 Big data: Dealing with variety Yuhan Liu BigData-Variety
6 (Oct 10–18)   Reading week - no classes -  
7 (Oct 20) 1 Big data: Dealing with variety + velocity Yuhan Liu  
  2 Big data: Dealing with velocity Yuhan Liu BigData-Volecity
8 (Oct 27) 1 Data integration: Data warehouses Prof. Tamer Özsu Data warehouses
  2 Data integration: Data lakes Mahdi Esmailoghli Data lakes
9 (Nov 3) 1 Data integration: Data preparation (virtual lecture; DC 1302) Prof. Felix Naumann Data preparation
  2 Data integration: Model lakes Prof. Renée J. Miller Model lakes
10 (Nov 10) 1 Data integration: Data version management Prof. Roee Shraga Data Versioning
  2 Data provenance Prof. Boris Glavic Data provenance
11 (Nov 17) 1 Spatial data management (virtual lecture; MC 4059) + Quiz #3 Prof. Eleni Tzirita Zacharatou Spatial data
  2 LLMs and data management (virtual lecture; DC 1302) Prof. Immanuel Trummer LLMs
12 (Nov 24) 1 Data quality & data cleaning (starts at 8:45 in MC 4059) Prof. Lukasz Golab  
  2 Data profiling (virtual lecture; MC 4059) Prof. Hazar Harmouch  
13 (Dec 1) 1 Vector databases (virtual lecture; DC 1302) (Paper Review #2 Deadline) Prof. Karima Echihabi  
  2 Review and general discussion + Quiz #4 Yuhan Liu & Mahdi Esmailoghli  
14 (Dec 8)   Reserved (buffer day in case a class needs to be rescheduled)    
Dec 11   Final Exam Time 4:00 PM - 6:00 PM Location STC 0010