Database Management Systems(2)

Database Management Systems

by Raghu Ramakrishnan and Johannes Gehrke

Database Management Systems has quickly become one of the leading texts for database courses, known for its practical emphasis and comprehensive coverage. The third edition features new material on database application development, with a focus on Internet applications. The hands-on approach introduces students to current standards, including JDBC, XML, and 3-tier application architectures. A new, flexible organization allows instructors to teach either an applications-oriented course or an introductory systems-oriented course. The revised “part” organization with (new) Overview chapters makes it easy to select the chapters you need; in-depth chapters within each part can be optional.

This very current new edition also features pedagogical improvements (e.g., chapter objectives, review questions), and updated and extended  discussions of data mining, database tuning wizards, decision support, information retrieval, Internet security, object-oriented databases, transaction processing, and XML data management. Throughout, the coverage has been revised and expanded to reflect the new SQL:1999 standard, including extensions that support multimedia data, object-relational databases, OLAP,  recursive queries, spatial data, and SQL-J. The flexible organization and up-to-date discussion of advanced topics also makes the book ideal for use in a two-course sequence

Slides for Database Management Systems, Third Edition

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