Databases and Transaction Processing provides a motivational overview of database management theory by focusing on the applications of databases that most readers will use in the real world. Since most readers will eventually use this material to implement (rather than design) databases, the traditional database theory is introduced with a focus on using this theory to build database and transaction processing applications. The material is presented in the context of transaction processing to provide a motivational context for readers.
The first part of Databases and Transaction Processing presents core database theory in the context of small-scale, single-user applications. The second part of the book concentrates on transaction processing and advanced topics in databases. To illustrate both the database and transaction processing concepts, a case study is carried throughout the book, with the technical aspects of the chapters applied to the examples. This application is used as a basis for illustrating most of the issues of database design and query processing. The authors provide a detailed presentation of the software engineering aspects of implementing database applications. Since the implementation of many information systems fail because of poor project management and inadequate software engineering, this software engineering theme is carried throughout the material.
This book is appropriate for programmers who want to understand database system concepts and how they apply to real-world databases. It also provides coverage of transaction processing concepts, which will be of interest as a reference to database practitioners.
Features and Benefits
Presents traditional material with an emphasis on how to build database applications.
Covers completely the traditional DBMS theory of the relational model and associated languages.
Provides extensive material on the "real-world" uses of SQL in host language programs, including embedded SQL, SQL/PSM, ODBC, JDBC, and SQLJ.
Includes extensive coverage of the transaction model and its use in implementing transaction processing applications.
Motivates application of the material via a running case study,"The Student Registration System," which takes readers through the design, implementation, and testing of a DBMS application.
Discusses the important software engineering issues that arise when implementing transaction processing applications.
Presents in-depth coverage of object and object-relational databases Covers current topics in databases, including CORBA, OLAP, data mining, distributed databases, and triggers.
Contains extensive material on XML and document processing on the Web.
Contains in-depth coverage of the transactional and security issues that arise in Internet commerce.