Database Management Systems provides comprehensive and up-to-date coverage of the fundamentals of database systems. This text has rapidly become one of the leading texts in the field due to its coherent explanations and practical flavor.
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 that emphasizes database application development or a course that emphasizes database systems issues.
More applications and examples have been added throughout the book. These include more SQL examples and more Oracle examples. There will also be two new chapters on internet applications. Database Management Systems is accompanied by an extensive website. Among other things, it includes PowerPoints, Solutions, additional Oracle exercises, and minibase software.
Foundations 1 Introduction to Database Systems
2 The Entity-Relationship Model
3 The Relational Model
4 Relational Algebra and Calculus
5 SQL: Queries, Triggers
II Data Storage and Indexing
6 Overview of Storage and Indexing
7 Storing Data: Disks and Files
8 Tree-Structured Indexing
9 Hash-Based Indexing
III Query Evaluation
10 Overview of Query Evaluation
11 External Sorting
12 Evaluating Relational Operators
13 A Typical Relational Query Optimizer
IV Transaction Management
14 Overview of Transaction Management
15 Concurrency Control
16 Crash Recovery
V Database Design and Tuning
17 Schema Refinement and Normal Forms
18 Physical Database Design and Tuning
VI Developing Database Applications
19 Application Development Using a DBMS
20 Building Internet Applications
21 Security
VII Advanced Topics
22 Parallel and Distributed Databases
23 Object-Database Systems
24 Managing Text and XML Data in a DBMS
25 Decision Support and Data Warehousing
26 Data Mining
27 Deductive Databases and Recursive Queries
28 Spatial Data Management
29 Additional Topics