Database Systems: The Complete Book, 2nd edition

Published by Pearson (June 5, 2008) © 2009

  • Hector Garcia-Molina
  • Jeffrey D. Ullman Stanford University
  • Jennifer Widom
Products list

For Database Systems and Database Design and Application courses

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 optimisation than most other texts, along with advanced topics including multidimensional and bitmap indexes, distributed transactions, and information integration techniques.

  • 1 The Worlds of Database Systems
  • 2 The Relational Model of Data
  • 3 Design Theory for Relational Databases
  • 4 High-Level Database Models
  • 5 Algebraic and Logical Query Languages
  • 6 The Database Language SQL
  • 7 Constraints and Triggers
  • 8 Views and Indexes
  • 9 SQL in a Server Environment
  • 10 Advanced Topics in Relational Databases
  • 11 The Semistructured-Data Model
  • 12 Programming Languages for XML
  • 13 Secondary Storage Management
  • 14 Index Structures
  • 15 Query Execution
  • 16 The Query Compiler
  • 17 Coping With System Failures
  • 18 Concurrency Control
  • 19 More About Transaction Management
  • 20 Parallel and Distributed Databases
  • 21 Information Integration
  • 22 Data Mining
  • 23 Database Systems and the Internet

Need help? Get in touch