Database and Transaction Processing

Author: Lewis
Publisher:
Publish Date: 2005-05-01
Features: The book systematically introduces the basic concepts and implementation methods of database and transaction processing applications, with a focus on how to build database applications. It consistently incorporates the fundamental theories of relational databases and relational query languages, laying a solid foundation for readers to master these principles. To illustrate the concepts of databases and transaction processing, the author provides a comprehensive case study that runs throughout the book. The entire book revolves around how to implement this case study, introducing relevant technologies and corresponding software engineering concepts. In addition to covering relational databases, SQL, and the ACID properties of transactions, this book also delves into the following cutting-edge topics related to databases and transaction processing:
● Embedded SQL, SQL/PSM, ODBC, JDBC, and SQLJ
● Object and object-oriented databases, including SQL:1999, ODMG, and CORBA
● XML and document processing on the Web
● Triggers and dynamic databases
● OLAP and data mining
● Distributed databases
● TP monitors and how they implement the ACID properties of transactions
● Concurrency control at different isolation levels
● Security and e-commerce
This book provides a comprehensive and detailed introduction to the design and implementation processes of database and transaction processing applications, covering main topics such as fundamental knowledge of databases and transaction processing, database management, and cutting-edge themes in databases and transaction processing. The focus of the book lies in how to design and implement database and transaction processing applications, rather than implementing database systems themselves. It emphasizes the role of transaction processing in database systems while retaining the classic framework of relational database theory. The book is extensive and thorough, making it suitable as a textbook or reference for database and transaction processing courses in computer science and related disciplines at universities and colleges. Technical personnel involved in database management and development can also benefit from the knowledge presented in this book.