Database Management Systems

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

Table of Contents

Part I 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

Part II APPLICATION DEVELOPMENT

6 DATABASE APPLICATION DEVELOPMENT

7 INTERNET APPLICATIONS

Part III STORAGE AND INDEXING

8 OVERVIEW OF STORAGE AND INDEXING

9 STORING DATA: DISKS AND FILES

10 TREE-STRUCTURED INDEXING

11 HASH-BASED INDEXING

Part IV QUERY EVALUATION

12 OVERVIEW OF QUERY EVALUATION

13 EXTERNAL SORTING

14 EVALUATING RELATIONAL OPERATORS

15 A TYPICAL RELATIONAL QUERY OPTIMIZER

Part V TRANSACTION MANAGEMENT

16 OVERVIEW OF TRANSACTION MANAGEMENT

17 CONCURRENCY CONTROL

18 CRASH RECOVERY

Part VI DATABASE DESIGN AND TUNING

19 SCHEMA REFINEMENT AND NORMAL FORMS

20 PHYSICAL DATABASE DESIGN AND TUNING

21 SECURITY AND AUTHORIZATION

Part VII 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