Journal of Computer Applications ›› 2011, Vol. 31 ›› Issue (05): 1404-1408.DOI: 10.3724/SP.J.1087.2011.01404

• Database technology • Previous Articles     Next Articles

Concurrency control in distributed database system with score-based method

LIU Yi, LIN Zi-yu   

  1. Laboratory of Intelligent Information Processing and Application, Leshan Normal University, Leshan Sichuan 614004, China
  • Received:2010-08-11 Revised:2010-10-18 Online:2011-05-01 Published:2011-05-01

用积分法处理分布式数据库中的多副本并发控制问题

刘毅,林子雨   

  1. 乐山师范学院 智能信息处理及应用实验室, 四川 乐山 614004
  • 通讯作者: 刘毅
  • 作者简介:刘毅(1965-),男,副教授,主要研究方向:数据库、软件工程。
  • 基金资助:

    四川省教育厅资助重点资助项目(07ZA035)。

Abstract: The Concurrency Control (CC) scheme employed in distributed database system can profoundly affect the performance of transaction-processing system. There are many different kinds of solutions to the problem of CC in distributed database system, and they have both advantages and disadvantages. The major methods of CC, basic knowledge of lock-based model and the project of 2-Phase Locking (2PL) were introduced. A score-based method was proposed based on lock-mechanism and in accordance with 2PL protocol, which could reduce the amount of data transmission and had desirable performance of concurrency. It could be used to deal with the problem of CC. The experimental results show that the proposed method can achieve much better performance than other available ones.

Key words: score, Distributed Database Management System (DDBMS), Concurrency Control (CC)

摘要: 在分布式系统中,采用的并发控制(CC)方法对事务处理系统的性能有着重要影响。介绍了主要的并发控制方法、加锁模型和两阶段锁(2PL)协议,提出了基于锁机制且遵守2PL协议的悲观控制方法——积分法。该方法既能减少网络中数据的传送量,又具有很好的并发性,可以很好地处理多副本并发控制问题。实验结果证明,该积分法可以比其他方法取得更好的性能。

关键词: 积分, 分布式数据库系统, 并发控制