Database Management Systems provides comprehensive and up-to-date coverage of the fundamentals of database systems. Coherent explanations and practical examples have made this one of the leading texts in the field. The third edition continues in this tradition, enhancing it with more practical material. The new edition has been reorganized to allow more flexibility in the way the course is taught. Now, instructors can easily choose whether they would like to teach a course which emphasizes database application development or a course that emphasizes database systems issues. New overview chapters at the beginning of parts make it possible to skip other chapters in the part if you don't want the detail. More applications and examples have been added throughout the book, including SQL and Oracle examples. The applied flavor is further enhanced by the two new database applications chapters.
1 Foundations 1 Overview of Database Systems 2 Introduction to Database Design 3 The Relational Model 4 Relational Algebra and Calculus 5 SQL: Queries, Constraints, Triggers 2 Application Development 6 Database Application Development 7 Internet Applications 3 Storage and Indexing 8 Overview of Storage and Indexing 9 Storing Data: Disks and Files 10 Tree-Structured Indexing 11 Hash-Based Indexing 4 Query Evaluation 12 Overview of Query Evaluation 13 External Sorting 14 Evaluating Relational Operators 15 A Typical Relational Query Optimizer 5 Transaction Management 16 Overview of Transaction Management 17 Concurrency Control 18 Crash Recovery 6 Database Design and Tuning 19 Schema Refinement and Normal Forms 20 Physical Database Design and Tuning 21 Security and Authorization 7 Additional Topics 22 Parallel and Distributed Databases 23 Object-Database Systems 24 Deductive Databases 25 Data Warehousing and Decision Support 26 Data Mining 27 Information Retrieval and XML Data 28 Spatial Data Management 29 Further Reading 30 The Minibase Software