CSE 544 Winter 2015
Lecture Topics

Subscribe to this calendar (google, iCal, etc.)

DateDescription
January 5 CANCELLED
January 7 Lecture 1: Introduction and Review of Relational Model
Readings and Slides
January 12 Lecture 2: SQL and Schema Normalization
Readings and Slides
January 14 Lecture 3: Data Models Old and New
Readings and Slides
January 21 Lecture 4: DBMS Architecture and Data Storage
Readings and Slides
January 26 Lecture 5: Indexing
Readings and Slides
January 28 Lecture 6: Query Execution and Operator Algorithms
Readings and Slides
February 2 Lecture 7: Query Optimization
Readings and Slides
February 4 Lecture 8: Transactions Concurrency Control
Readings and Slides
February 9 Lecture 9: Transactions Recovery
Readings and Slides
February 11 Lecture 10: Data Warehousing with Column Stores
Readings and Slides
February 18 Lecture 11: Data analytics at scale: Parallel DBMSs and MapReduce
Readings and Slides
February 23 Lecture 12: In-memory data analytics at scale: Spark
Readings and Slides
February 25 Lecture 13: Distributed transactions and replication
Readings and Slides
March 2 Lecture 14: NoSQL
Readings and Slides
March 4 Lecture 15: In-memory Transactions (H-Store)
Readings and Slides
March 9 Lecture 16: Spanner
Guest lecture by Campbell Fraser (Google)

Readings and Slides
March 11 Lecture 17: Databases as a cloud service
Readings and Slides