基于全局目录的集中型数据库分布式加锁仿真

Distributed Locking Simulation of Centralized Database Based on Global Directory

现有使用较为广泛的三种集中型数据库分布式加锁方法均存在着通信量大、分布事务并发复杂度高的缺陷。为了解决上述问题,引入全局目录对集中型数据库分布式加锁方法进行设计研究。根据集中型数据库分布式加锁的需求对锁进行相应的管理,并对数据库全局目录进行创建,主要对其功能与数据项内容进行设置,将全局目录存储于集中型数据库的主站点,通过确定数据加锁粒度、加锁类型与事务锁表对数据库进行分布式加锁,利用分布式加锁算法对加锁过程进行管理与控制,实现了基于全局目录的集中型数据库的分布式加锁。通过仿真得到,与现有的集中型数据库分布式加锁方法相比较,提出的集中型数据库分布式加锁方法极大的降低了通信量与分布事务并发复杂度,充分说明提出的集中型数据库分布式加锁方法具备更好的加锁性能。

In this article, the global directory is introduced to design and research the distributed locking method of centralized database. According to the requirement of distributed locking method in centralized database, the lock was managed and the global directory of database was established. Primarily, its functions and data items were set up. The global directory was stored in the main site of centralized database. By determining the data locking granularity, the locking type and the transaction locking table, the distributed locking strategy was used to lock the database. The distributed locking algorithm was used to manage and control the locking process. Finally, the distributed locking of centralized database based on global directory was achieved. Simulation results show that, compared with the existing method, the proposed distributed locking method of centralized database reduces the communication traffic and concurrent complexity of distributed transactions. This has been fully proved the proposed method has better locking ability.