On Transactional Concurrency Control (Paperback) (ISBN-13: 9783031007453)

This book contains a number of chapters on transactional database concurrency control. This volume's entire sequence of chapters can summarized as follows: 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.

Author: Goetz Graefe
ISBN-10: 303100745X
ISBN-13: 9783031007453
Publisher: Springer
Language: English
Published: 06/11/2019
Pages: 383
Format: Paperback
Weight: 1.54lbs
Size: 9.25h x 7.50w x 0.84d