Database systems : the complete book
This introduction to database systems offers a readable comprehensive approach with engaging, real-world examples -- users will learn how to successfully plan a database application before building it. 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, while the second half of the book provides in-depth coverage of databases from the point of view of the DBMS implementor. The first half of the book focuses on database design, database use, and implementation of database applications and database management systems -- it covers the latest database standards SQL:1999, SQL/PSM, SQL/CLI, JDBC, ODL, and XML, with broader coverage of SQL than most other books. The second half of the book focuses on storage structures, query processing, and transaction management -- it coversthe main techniques in these areas with broader coverage of queryoptimization than most other books, along with advanced topicsincluding multidimensional and bitmap indexes, distributedtransactions, and information integration techniques.
Lehrbuch
xxvii, 1119 pages : illustrations ; 24 cm
9780130319951, 0130319953
47915796
The worlds of database systems
The entity-realtionship data model
The relational data model
Other data models
Relational algebra
The database language SQL
Constraints and triggers
System aspects of SQL
Object-orientation in query languages
Logical query languages
Data storage
Representing data elements
Index structures
Multidimensional and bitmap indexes
Query execution
The query compiler
Coping with system failures
Concurrency control
More about transaction management
Information integration