1 option
Transaction Processing : Management of the Logical Database and its Underlying Physical Structure / by Seppo Sippu, Eljas Soisalon-Soininen.
- Format:
- Book
- Author/Creator:
- Sippu, Seppo, 1950- author.
- Soisalon-Soininen, Eljas, 1949- author.
- Series:
- Computer Science (Springer-11645)
- Data-centric systems and applications 2197-9723
- Data-Centric Systems and Applications, 2197-9723
- Language:
- English
- Subjects (All):
- Database management.
- Computer science--Mathematics.
- Computer science.
- Information storage and retrieval.
- Database Management.
- Discrete Mathematics in Computer Science.
- Information Storage and Retrieval.
- Local Subjects:
- Database Management.
- Discrete Mathematics in Computer Science.
- Information Storage and Retrieval.
- Physical Description:
- 1 online resource (XV, 392 pages) : 64 illustrations.
- Edition:
- First edition 2014.
- Contained In:
- Springer eBooks
- Place of Publication:
- Cham : Springer International Publishing : Imprint: Springer, 2014.
- System Details:
- text file PDF
- Summary:
- Transactions are a concept related to the logical database as seen from the perspective of database application programmers: a transaction is a sequence of database actions that is to be executed as an atomic unit of work. The processing of transactions on databases is a well- established area with many of its foundations having already been laid in the late 1970s and early 1980s. The unique feature of this textbook is that it bridges the gap between the theory of transactions on the logical database and the implementation of the related actions on the underlying physical database. The authors relate the logical database, which is composed of a dynamically changing set of data items with unique keys, and the underlying physical database with a set of fixed-size data and index pages on disk. Their treatment of transaction processing builds on the "do-redo-undo" recovery paradigm, and all methods and algorithms presented are carefully designed to be compatible with this paradigm as well as with write-ahead logging, steal-and-no-force buffering, and fine-grained concurrency control. Chapters 1 to 6 address the basics needed to fully appreciate transaction processing on a centralized database system within the context of our transaction model, covering topics like ACID properties, database integrity, buffering, rollbacks, isolation, and the interplay of logical locks and physical latches. Chapters 7 and 8 present advanced features including deadlock-free algorithms for reading, inserting and deleting tuples, while the remaining chapters cover additional advanced topics extending on the preceding foundational chapters, including multi-granular locking, bulk actions, versioning, distributed updates, and write-intensive transactions. This book is primarily intended as a text for advanced undergraduate or graduate courses on database management in general or transaction processing in particular.
- Contents:
- 1 Transactions on the Logical Database
- 2 Operations on the Physical Database
- 3 Logging and Buffering
- 4 Transaction Rollback and Restart Recovery
- 5 Transactional Isolation
- 6 Lock-Based Concurrency Control
- 7 B-Tree Traversals
- 8 B-Tree Structure Modifications
- 9 Advanced Locking Protocols
- 10 Bulk Operations on B-Trees
- 11 Online Index Construction and Maintenance
- 12 Concurrency Control by Versioning
- 13 Distributed Transactions
- 14 Transactions in Page-Server Systems
- 15 Processing of Write-Intensive Transactions.
- Other Format:
- Printed edition:
- ISBN:
- 978-3-319-12292-2
- 9783319122922
- Access Restriction:
- Restricted for use by site license.
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.