On transactional concurrency control
Author(s)
Bibliographic Information
On transactional concurrency control
(Synthesis lectures on data management, #59)
Morgan & Claypool, c2019
- : pbk
Available at 1 libraries
  Aomori
  Iwate
  Miyagi
  Akita
  Yamagata
  Fukushima
  Ibaraki
  Tochigi
  Gunma
  Saitama
  Chiba
  Tokyo
  Kanagawa
  Niigata
  Toyama
  Ishikawa
  Fukui
  Yamanashi
  Nagano
  Gifu
  Shizuoka
  Aichi
  Mie
  Shiga
  Kyoto
  Osaka
  Hyogo
  Nara
  Wakayama
  Tottori
  Shimane
  Okayama
  Hiroshima
  Yamaguchi
  Tokushima
  Kagawa
  Ehime
  Kochi
  Fukuoka
  Saga
  Nagasaki
  Kumamoto
  Oita
  Miyazaki
  Kagoshima
  Okinawa
  Korea
  China
  Thailand
  United Kingdom
  Germany
  Switzerland
  France
  Belgium
  Netherlands
  Sweden
  Norway
  United States of America
Note
Includes bibliographical references
Description and Table of Contents
Description
This book contains a number of chapters on transactional database concurrency control.
A two-sentence summary of the volume's entire sequence of chapters is this: traditional locking techniques can be improved in multiple dimensions, notably in lock scopes (sizes), lock modes (increment, decrement, and more), lock durations (late acquisition, early release), and lock acquisition sequence (to avoid deadlocks). Even if some of these improvements can be transferred to optimistic concurrency control, notably a fine granularity of concurrency control with serializable transaction isolation including phantom protection, pessimistic concurrency control is categorically superior to optimistic concurrency control, i.e., independent of application, workload, deployment, hardware, and software implementation.
Table of Contents
On Transactional Concurrency Control
A Survey of B-Tree Locking Techniques
Hierarchical Locking in B-Tree Indexes
Concurrent Queries and Updates in Summary Views and Their Indexes
Controlled Lock Violation
Orthogonal Key-Value Locking
Orthogonal Key-Value Validation
Serializable Timestamp Validation
Repairing Optimistic Concurrency Control
Avoiding Index-Navigation Deadlocks
A Problem in Two-Phase Commit
Deferred Lock Enforcement
The End of Optimistic Concurrency Control
Author's Biography
by "Nielsen BookData"