| foils | Topic |
| intro.PPT | Introduction |
| miniU.mdb | sample mini-university database in MS-access |
| e-r-diagrams.PPT | Entity relationship model |
| methodology.PPT | Roussopoulos and Yeh methodology |
| rel-model.PPT | Relational model - rel. algebra ( 9/5/2002 : fixed formula for division; (9/12/2002) and example) |
| 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 ( 9/30/2002 -fixed typo on foil 33) |
| sql-part3.PPT | SQL - DDL, embedded SQL |
| ic.PPT | Integrity constraints, Functional Dependencies |
| db-design.PPT | Database design, Normalization |
| storage.PPT | storage and file structures |
| indexing-I | ISAM and B-trees |
| indexing-II | hashing |
| q-opt1.PPT | query optimization - part 1 |
| q-opt2.PPT | q-opt - part 2 (selectivities, joins) |
| transactions.PPT | transactions (ACID, serializability) |
| conc-control.ppt | concurrency control and locking |
| cc-deadlocks.ppt | concurrency control - deadlocks |
| HowTo-project.ppt | java+SQL samples and tar-ball with code (new: 10/30/2002 ) |
| recovery.ppt | recovery |
| distr.PPT | distributed DBMSs |
| ordbms.ppt | Object-Relational DBMSs |
| Servlets.ppt | Servlets, JSP info |
| webdb.pdf | Web databases (guest lecture by Prof. Labrinidis) (11/21/2002) |
| advanced1.PPT | RAID and statistical databases |
| SAM-1zorder.ppt | Spatial Access Methods - zordering |
| SAM-2rtrees.ppt | Spatial Access Methods - R-trees |
| mm.ppt | Multimedia Indexing |
| pax.pdf | PAX: novel, cache aware page storage scheme |
| dm.ppt | Data Mining |
Last updated: 9/30/2002, by christos AT cs DOT cmu DOT edu