Database Systems : The Complete Book

Table of Content
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 Database Systems and the Internet

Salient Features
• Many real-world examples.
• Extensive treatment of database modeling-Includes detailed and separate explanations of how to use E/R and ODL to design databases.
• Excellent, up-to-date and detailed coverage of SQL-Includes coverage of object-relational systems and many aspects of the new SQL:1999 standard.
• Discussion of the technologies used to connect database programming with C or Java code-Includes discussions of SQL/PSM, SQL/CLI, and JDBC.
• Coverage of advanced issues important to database designers and users.
• Discussions of how to successfully plan a database application before building it.
• Coverage of topics such as designing storage structures and implementing a variety of indexing schemes.
• Extensive coverage of query processing and optimization.
• Comprehensive coverage of transaction processing mechanisms for concurrency control and recovery, including distributed and long-duration transactions