On Transactional Concurrency Control

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.

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.