On Transactional Concurrency Control

von Goetz Graefe

383 Seiten, Taschenbuch

Kurzbeschreibung des Verlags

This book contains a number of chapters on transactional database concurrency control. It includes insightful discussion of how 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). The book takes the position that 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. This book will be of interest to graduate students, academics, and practitioners looking to improve their understanding and application of transactional concurrency control.

• Reihe: Synthesis Lectures on Data Management
• Themen: Informatik und Informationstechnologie Computerhardware Netzwerk-Hardware
• ISBN: 9783031007453
• Sprache: Englisch
• Erscheinungsdatum: 11.06.2019
• Größe: 23.5 x 19.1 cm
• Verlag: Springer International Publishing