Summary

Fundamentals of Database Systems combines clear explanations of theory and design, broad coverage of modeling and real systems, and excellent examples with up-to-date introduction to modern database technologies. Now in its Third Edition, this book has been revised and updated to reflect the latest technological and application development. The authors emphasize the relational model and include recent object-oriented developments such as ODMG and SQL3 as well as the object/relational approach to database management.

Table of Contents

I. BASIC CONCEPTS.

1. Databases and Database Users.

Introduction. An Example. Characteristics of the Database Approach. Actors on the Scene. Workers Behind the Scene. Advantages of Using a DBMS. Implications of the Database Approach. When Not to Use a DBMS.

Relational Database Management Systems: A Historical Perspective. The Basic Structure of the Oracle System. Database Structure and Its Manipulation in Oracle. Storage Organization in Oracle. Programming Oracle Applications. Oracle Tools. An Overview of Microsoft Access. Features and Functionality of Access.

Overview of the Object Model of ODMG. The Object Definition Language. The Object Query Language. Overview of the C Language Binding. Object Database Conceptual Design. Example of ODBMSs. Overview of the CORBA Standard for Distributed Objects. Overview of the O2 System. Overview of the ObjectStore System.

13. Object Relational and Extended Relational Databases.

Evolution and Current Trends of Database Technology. The Informix Universal Server. Object-Relational Features of Oracle 8. An Overview of SQL3. Implementation and Related Issues for Extended Type Systems. The Nested Relational Data Model.

The Role of Information Systems in Organizations. The Database Design Process. Physical Database Design and its Tuning in Relational Databases. An Overview of Database Tuning in Relational Systems. Automated Design Tools.

Introduction to Transaction Processing. Transaction and System Concepts. Desirable Properties of Transactions. Schedules and Recoverability. Serializability of Schedules. Transaction Support in SQL.

20. Concurrency Control Techniques.

Locking Techniques for Concurrency Control. Concurrency Control Based on Timestamp Ordering. Multiversion Concurrency Control Techniques. Validation (Optimistic) Concurrency Control Techniques. Granularity of Data Items and Multiple Granularity Locking. Using Locks for Concurrency Control in Indexes. Some Other Concurrency Control Issues.

Introduction to Database Security Issues. Discretionary Access Control Based on Granting/Revoking of Privileges. Mandatory Access Control for Multilevel Security. Introduction to Statistical Database Security.