| powerpoint foils - old | new | Topic |
| intro.PPT | Introduction | |
| e-r-diagrams.PPT | Entity relationship model | |
| methodology.PPT | Roussopoulos and Yeh methodology | |
| rel-model.PPT | Relational model - rel. algebra (New: 9/12/2002 - fixed formula for division) | |
| rel-tuple-calc.PPT | Relational model - rel. tuple calculus | |
| rel-dom-calc.PPT | Relational model - rel. domain calculus | |
| sql-part1.PPT | SQL - select, from, where, aggregation | |
| sql-part2.PPT | SQL - subqueries | |
| sql-part3.PPT | SQL - DDL, embedded SQL | |
| ic.PPT | Integrity constraints, Functional Dependencies (fixed typo on p. 26, 10/16/2001) | |
| db-design.PPT | Database design, Normalization (fixed typo on p.30, 10/16/2001) | |
| storage.PPT | storage and file structures | |
| indexing-I | ISAM and B-trees | |
| indexing-II | hashing | |
| q-opt1.PPT | query optimization - part 1 (fixed typos, 10/15/2001) | |
| q-opt2.PPT | q-opt - part 2 (selectivities, joins) (fixed typos, 10/15/2001) | |
| transactions.PPT | transactions (ACID, serializability) | |
| conc-control.ppt | concurrency control and locking | |
| cc-deadlocks.ppt | concurrency control - deadlocks | |
| HowTo-project.ppt | java+SQL samples (NEW: 11/1/2001) | |
| recovery.ppt | recovery | |
| distr.PPT | distributed DBMSs | |
| ordbms.ppt | Object-Relational DBMSs | |
| Servlets.ppt | Servlets, JSP info (11/13/2001) | |
| advanced1.PPT | RAID and statistical databases | |
| SAM-1zorder.ppt | Spatial Access Methods - zordering (11/07/2001) | |
| SAM-2rtrees.ppt | Spatial Access Methods - R-trees(11/07/2001) | |
| mm.ppt | Multimedia Indexing (11/07/2001) | |
| pax.pdf | PAX: novel, cache aware page storage scheme (11/27/2001) | |
| dm.ppt | Data Mining (11/07/2001) |
Last updated: 11/27/2001, by christos@cs.cmu.edu