Abstract:Lock managers are among the most studied components in concurrency control and transactional systems. However, one question seems to have been generally overlooked: "When there are multiple lock requests on the same object, which one(s) should be granted first?" Nearly all existing systems rely on a FIFO (first in, first out) strategy to decide which transaction(s) to grant the lock to. In this paper, however, we show that the lock scheduling choices have significant ramifications on the overall performance of a transactional system. Despite the large body of research on job scheduling outside the database context, lock scheduling presents subtle but challenging requirements that render existing results on scheduling inapt for a transactional database. By carefully studying this problem, we present the concept of contention-aware scheduling, show the hardness of the problem, and propose novel lock scheduling algorithms (LDSF and bLDSF), which guarantee a constant factor approximation of the best scheduling. We conduct extensive experiments using a popular database on both TPC-C and a microbenchmark. Compared to FIFO the default scheduler in most database systems our bLDSF algorithm yields up to 300x speedup in overall transaction latency. Alternatively, our LDSF algorithm, which is simpler and achieves comparable performance to bLDSF, has already been adopted by open-source community, and was chosen as the default scheduling strategy in MySQL 8.0.3+.

Design and Implementation of a Concurrency Control Mechanism in an Object-Oriented Database System.

Design and Implementation of Lock Management System in Engineering Database

Transparent Access to Persistent Objects in Object-Oriented Databases

EXTENDED JAVA COLLECTION FRAMEWORK BASED ON OBJECT-ORIENTED DATABASE

Adaptive call-back lock algorithm in ONet

Concurrency control in database systems

Transparent Access to Persistent Objects in Object-Oriented Databases.

Implementation of Object Component for Improving ONet-object Database Management System

Contention-aware Lock Scheduling for Transactional Databases

An Adaptive Strategy Integrating Locking with Optimistic Concurrency Control

A Concurrency Control Method Based on Attribute-Operation Object Model in Real-time Cooperative System

Oodopt: A Semantics-Based Concurrency Control Framework for Fully-Replicated Architecture

On The Design Of Adaptive And Speculative Concurrency Control In Distributed Databases

DGCC: A New Dependency Graph based Concurrency Control Protocol for Multicore Database Systems.

Transaction management in multi-user CAD environment

OBJ-D:An Object-centric Concurrency Bug Detection Framework for Java

High-Performance Transaction Processing for Web Applications Using Column-Level Locking

Research on Data Consistency and Concurrency Optimization of Distributed System

A Fine Granular Concurrency Control Mechanism for a Peer-to-Peer Cooperative Design Environment

Transactional Memory Execution for Parallel Multithread Programming Without Lock

A Survey on Exposing,Detecting and Avoiding Concurrency Bugs