Database Systems: The Complete Book, 2nd Edition

Database Systems: The Complete Book is ideal for Database Systems and Database Design and Application courses offered at the junior, senior and graduate levels in Computer Science departments. A basic understanding of algebraic expressions and laws, logic, basic data structure, OOP concepts, and programming environments is implied.

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.

Table of Contents

Chapter 1. The Worlds Of Database Systems
Chapter 2. The Relational Model Of Data
Chapter 3. Design Theory For Relational Databases
Chapter 4. High-Level Database Models
Chapter 5. Algebraic And Logical Query Languages
Chapter 6. The Database Language Sql
Chapter 7. Constraints And Triggers
Chapter 8. Views And Indexes
Chapter 9. Sql In A Server Environment
Chapter 10. Advanced Topics In Relational Databases
Chapter 11. The Semistructured-Data Model
Chapter 12. Programming Languages For Xml
Chapter 13. Secondary Storage Management
Chapter 14. Index Structures
Chapter 15. Query Execution
Chapter 16. The Query Compiler
Chapter 17. Coping With System Failures
Chapter 18. Concurrency Control
Chapter 19. More About Transaction Management
Chapter 20. Parallel And Distributed Databases
Chapter 21. Information Integration
Chapter 22. Database Systems And The Internet