Lectures
All slides are only available within the department. If you are off-campus, you can setup VPN access to view these slides.
| # | Date | Lecture | Book Chapter(s) |
|---|---|---|---|
| 1 | 09-14 | Introduction (.ppt), Relations (.pdf,.ppt) | 1, 2 |
| 2 | 09-21 | DB Design, ER-Model (.pdf,.ppt) | 6 |
| 3 | 09-28 | Tuple Relational Calculus, SQL 1 (.pdf,.ppt),2 (.pdf,.ppt). | 3, 4, 5.4 |
| 4 | 10-5 | Functional Dependencies(.ppt,.pdf), Normalization(.ppt,.pdf) | 7 |
| 10-12 | Columbus Day, no class! | ||
| 5 | 10-19 | B+ Tree, Indices: Bitmap, Hash, Temporal File Organization -- [ppt][pdf] B Tree --[ppt][pdf] Hashing -- [ppt][pdf] |
9, 10, 18.1-18.3 |
| 6 | 10-26 | File Structure Loop and Join Algorithms [ppt][pdf] | 11, 12 |
| 7 | 11-2 | Midterm | |
| 8 | 11-9 | Query Processing 2 [ppt][pdf] Transactions[ppt][pdf] Concurrency, Serializability and Locking[ppt][pdf] |
15, 16.1-16.6 |
| 9 | 11-16 | Transactions (.pdf.ppt), Concurrency Control (.pdf,.ppt). | 17, 13 |
| 10 | 11-23 | Data Mining, Data Warehousing, Column Stores, Distributed Databases. | 14 |
| 11 | 11-30 | Miscellaneous Topics, Presentation of Graduate Projects | 22 |
| N/A | 12-07 | Final Exam |