A Locking Mechanism for Distributed Database Systems
Zhangbing Li, Zilan Zhu, Shaobo Zhang · Journal of Networks · 2014
Abstract—To overcome the disadvantages of the traditional locking mechanism for Distributed Database Systems (DDBS), such as the low transaction concurrency and the high communication costs, this paper studies the traditional mechanism with Two-phase Locking (2PL) protocol, and redefines the lock types and their compatibility matrix in DDBS, designs the structure of the Lock Table, improves the lock policy and the lock algorithm. Those make up of a new locking mechanism for DDBS. The experimental results show that this mechanism can intensively control and flexibly manage the requirements for locks with improved 2PL protocol and multi-granularity locking, and effectively ensure serializing scheduling of transactions and decrease the costs of communications while locking. It obtains the better transaction concurrency than the traditional mechanism.