Database Management Systems (3RD 03 Edition)

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