Database Systems

Written by well-known computer scientists, this introduction to database systems offers a comprehensive approach, focusing on database design, database use, and implementation of database applications and database management systems.

The first half of the book provides in-depth coverage of databases from the point of view of the database designer, user, and application programmer. It covers the latest database standards SQL:1999, SQL/PSM, SQL/CLI, JDBC, ODL, and XML, with broader coverage of SQL than most other texts. The second half of the book provides in-depth coverage of databases from the point of view of the DBMS implementor. It focuses on storage structures, query processing, and transaction management. The book covers the main techniques in these areas with broader coverage of query optimization than most other texts, along with advanced topics including multidimensional and bitmap indexes, distributed transactions, and information integration techniques.

Contents

1. The Worlds of Database Systems.
2. The Entity-Relationship Data Model.
3. The Relational Data Model.
4. Other Data Models.
5. Relational Algebra.
6. The Database Language SQL.
7. Constraints and Triggers in SQL.
8. System Aspects of SQL.
9. Object-Orientation in Query Languages.
10. Logical Query Languages.
11. Data Storage.
12. Representing Data Elements.
13. Index Structures.
14. Multidimensional Indexes.
15. Query Execution.
16. The Query Compiler.
17. Coping with System Failures.
18. Concurrency Control.
19. More about Transaction Management.
20. Information Integration.

Index