Slides behorende bij het boek van A. Silberschatz e.a., 'Database system concepts', 4th ed, McGraw-Hill, 2002. Tijdens de colleges zullen we alleen de hoofdstukken 11 t/m 17 behandelen. Voor de volledigheid staan hier de slides van alle hoofdstukken. De slides hier zijn identiek met de originele versie.
Formaten: Powerpoint (ppt), PDF slides (1 slide per pagina), en PDF handouts (2, 4, of 8 slides per pagina).
| Hoofdstuk | Formaat | |
|---|---|---|
| 1. Introduction | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| Part 1: Data Models | ||
| 2. Entity-Relationship Model | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 3. Relational Model | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| Part 2: Relational Databases | ||
| 4. SQL | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 5. Other Relational Languages | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 6. Integrity and Security | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 7. Relational-Database Design | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| Part 3: Object-based Databases and XML | ||
| 8. Object-Oriented Databases | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 9. Object-Relational Databases | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 10. XML | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| Part 4: Data Storage and Querying | ||
| 11. Storage and File Structure | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 12. Indexing and Hashing | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 13. Query Processing | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 14. Query Optimization | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| Part 5: Transaction Management | ||
| 15. Transactions | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 16. Concurrency Control | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 17. Recovery System | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| Part 6: Database System Architecture | ||
| 18. Database System Architectures | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 19. Distributed Databases | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 20. Parallel Databases | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| Part 7: Other Topics | ||
| 21. Application Development and Administration | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 22. Advanced Querying and Information Retrieval | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 23. Advanced Data Types and New Applications | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| 24. Advanced Transaction Processing | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| Part 8: Case Studies : No slides for this part | ||
| Part 9: Appendices | ||
| A. Network Model | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| B. Hierarchical Model | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| C. Advanced Relational Database Design | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
| Part 10: Extra | ||
| ARIES Recovery Algorithm | ppt, pdf-1, pdf-2, pdf-4, pdf-8 | |
The slides below are copyright Silberschatz, Korth and Sudarshan, 2001. The slides are authorized for personal use, and for use in conjunction with a course for which Database System Concepts is the prescribed text. Instructors are free to modify the slides to their taste, as long as the modified slides acknowledge the source and the fact that they have been modified. Paper copies of the slides may be sold strictly at the price of reproduction, to students of courses where the book is the prescribed text. Any use that differs from the above, and any for profit sale of the slides (in any form) requires the consent of the copyright owners; contact Avi Silberschatz (avi@cs.yale.edu) to obtain the copyright owners consent.