Database Management Systems, Third Edition (Slides)

Note: These slides are available for students and instructors in PDF and some slides also in postscript format. Slides in Microsoft Powerpoint format are available only for instructors. All slides except the slides for Chapter 24 are available now. You can download all the available slides in one large zip-file.

I Foundations

• Chapter 1: Introduction (postscript)
• Chapter 2: ER Model and Conceptual Design (postscript)
• Chapter 3: The Relational Model and SQL DDL (postscript)
• Chapter 4: Relational Algebra (postscript) and Relational Calculus (postscript)
• Chapter 5: SQL (postscript)

II Applications

• Chapter 6: Database Application Development
• Chapter 7: Database-backed Internet Applications

III Systems

• Chapter 8: Overview of Storage and Indexing (postscript)
• Chapter 9: Data Storage(postscript)
• Chapter 10: Tree Indexes (postscript)
• Chapter 11: Hash Indexes (postscript)

IV Systems

• Chapter 12: Overview of Query Evaluation (postscript)
• Chapter 13: External Sorting (postscript)
• Chapter 14: Evaluation of Relational Operators: First part (joins) (postscript) and second part (other operators) (postscript)
• Chapter 15: A Typical Relational Optimizer (postscript)

V Systems

• Chapter 16: Overview of Transaction Management
• Chapter 17: Concurrency Control
• Chapter 18: Recovery

VI Applications

• Chapter 19: Schema Refinement, Functional Dependencies, Normalization
• Chapter 20: Physical Database Design, Database Tuning
• Chapter 21: Security and Authorization

VII Advanced Topics

• Chapter 22: Parallel Database Systems. Distributed Database Systems.
• Chapter 23: Data Warehousing and Decision Support. Views.
• Chapter 24: Object Database Systems
• Chapter 25: Deductive Databases
• Chapter 26: Data Mining
• Chapter 27: Information Retrieval and XML Data Management. Slides come in five parts:
  • Introduction to IR Systems: Supporting Boolean Text Search
  • Computing Relevance, Similarity: The Vector Space Model
  • Web Search Engines
  • Introduction to Semistructured Data and XML
  • XQuery
• Chapter 28: Spatial Databases