Synopsis
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.
"synopsis" may belong to another edition of this title.
About the Author
Goetz Graefe has been a professor, product architect, and industrial researcher since 1987. Like other database vendors, Microsoft SQL Server adopted his designs for query optimization and query execution. He has published tutorial surveys on query execution, sorting, b-tree indexing, concurrency control, logging and recovery, as well as numerous novel techniques and research results in query processing and transactional data storage. He is the 2017 recipient of the ACM SIGMOD Edgar F. Codd Innovation award.
"About this title" may belong to another edition of this title.
Other Popular Editions of the Same Title
Search results for On Transactional Concurrency Control (Synthesis Lectures...
Seller Image
On Transactional Concurrency Control (Synthesis Lectures on Data Management)
Published by
Morgan & Claypool Publishers, 2019
ISBN 10: 1681735504
ISBN 13: 9781681735504
New
Hardcover
Seller: Leopolis, Kraków, Poland
Seller rating 5 out of 5 stars
Hardcover. Condition: New. 8vo (24.5 cm), XXI, 383 pp. Publisher's laminated boards. Synopsis: 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. Seller Inventory # 008489