一种改进的内存数据库封锁机制  

Improved Locking Protocol in Main Memory Database

作　　者：周游弋[1] 

机构地区：[1]复旦大学计算机科学技术学院,上海200433

出　　处：《计算机系统应用》2010年第12期204-207,共4页Computer Systems & Applications

基　　金：上海市科委科研计划项目(08511500902;08511501903)

摘　　要：事务之间的封锁协议一直是数据库领域中的研究重点。在典型的内存数据库系统中,由于事务通常都比较短小,执行速度快,因此事务之间通常采用类似单写多读这样较为简单的封锁控制协议,将不同事务近似串行地分别执行。在事务并发量较高但是相互之间数据交集不大的情况下,可以通过引入粗粒度意向锁和锁粒度变换的方式来进一步提高事务之间的并行程度,加速事务的整体执行,提高事务吞吐量和系统响应速度。Locking protocols between transactions have long been an important field in database research. In a classic main memory database system, transactions tend to be short and small so that the system usually adopts some simple locking protocols like single-write-multiple-read. Transactions are executed in an almost serialized sequence. In a system of heavy transaction concurrencies but relatively small overlapping data sets between transactions, locking protocol could be improved by introducing coarse-grained intent share lock and lock granularity transformation in order to boost concurrencies between transactions, raise transaction throughput and improve overall system performance.

关 键 词：内存数据库 并发控制 封锁机制 粗粒度锁 锁粒度变换 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]