Zum Hauptinhalt springen
Dekorationsartikel gehören nicht zum Leistungsumfang.
On Transactional Concurrency Control
Taschenbuch von Goetz Graefe
Sprache: Englisch

68,95 €*

inkl. MwSt.

Versandkostenfrei per Post / DHL

Lieferzeit 4-7 Werktage

Kategorien:
Beschreibung
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.
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.
Über den Autor
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.
Inhaltsverzeichnis
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.
Details
Erscheinungsjahr: 2019
Fachbereich: Datenkommunikation, Netze & Mailboxen
Genre: Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Taschenbuch
Reihe: Synthesis Lectures on Data Management
Inhalt: xxi
383 S.
ISBN-13: 9783031007453
ISBN-10: 303100745X
Sprache: Englisch
Ausstattung / Beilage: Paperback
Einband: Kartoniert / Broschiert
Autor: Graefe, Goetz
Hersteller: Springer International Publishing
Springer International Publishing AG
Synthesis Lectures on Data Management
Maße: 235 x 191 x 23 mm
Von/Mit: Goetz Graefe
Erscheinungsdatum: 11.06.2019
Gewicht: 0,759 kg
Artikel-ID: 121975191
Über den Autor
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.
Inhaltsverzeichnis
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.
Details
Erscheinungsjahr: 2019
Fachbereich: Datenkommunikation, Netze & Mailboxen
Genre: Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Taschenbuch
Reihe: Synthesis Lectures on Data Management
Inhalt: xxi
383 S.
ISBN-13: 9783031007453
ISBN-10: 303100745X
Sprache: Englisch
Ausstattung / Beilage: Paperback
Einband: Kartoniert / Broschiert
Autor: Graefe, Goetz
Hersteller: Springer International Publishing
Springer International Publishing AG
Synthesis Lectures on Data Management
Maße: 235 x 191 x 23 mm
Von/Mit: Goetz Graefe
Erscheinungsdatum: 11.06.2019
Gewicht: 0,759 kg
Artikel-ID: 121975191
Warnhinweis

Ähnliche Produkte

Ähnliche Produkte