CS4432. Database Systems II

Lectures.

Day Topic Notes Last Updated Readings
Jan 12 Logistics&Introduction ppt ppt Jan 12 Chapter 13
Jan 19 Disks + Buffers. ppt ppt Jan 19 Chapter 13
Jan 23 Buffer-Aware Computations. ppt Jan 23 Chapter 13
Jan 27 Data Layout. ppt, ppt, ppt, ppt Jan 23 Chapter 13
Jan 30 Indexing. ppt, ppt, Jan 30 Chapter 14
Feb 6 Indexing. ppt, ppt, ppt, Feb 6 Chapter 14
Feb 9 Query Optimization/Cardinality Estimation. ppt . ppt ppt ppt Feb 6 Chapter 15
Feb 13 Query Rewriting/Query Processing Strategies ppt ppt Feb 12 Chapter 15/16
Feb 16 Academic Advising Day . . .
Feb 20 Review / Exam2 . . .
Feb 23 Query Processing WrapUp / Basics of Transactions ppt, ppt, ppt Feb 22 Chapter (17)/18
Feb 27 Concurrency: Conflict Serializability Theory and Lock-based Protocols ppt, ppt, ppt, Feb 27 Chapter (17)/18
Mar 1 Concurrency and Recovery ppt ppt Feb 27 Chapter (17)/18

The lectures are derived from the course text book and material provided by Garcia-Molina, Ullman and Widom.