嵌入式数据库SQLite中锁机制研究及改进

Research and Improvement in Locking Mechanism of Embedded Database SQLite

并发控制机制是数据库系统中的一项关键技术,文章介绍了嵌入式数据库SQLite中的并发控制机制--两段封锁协议的内容及SQLite中的锁类型。在原有基础上对锁机制进行改进,增加了锁粒度,提出一种动态多粒度封锁机制。详细介绍了动态多粒度封锁机制的算法流程。改进后的并发方法既提高SQLite的并发度,又保证嵌入式数据库的内存开销。

Concurrency control mechanism is an important technique in database and it is introduced here related to embedded database SQLite.Based on the Two-Phase Locking protocol and SQLite＇s lock types,a new locking mechanism is put forward which has increased the lock granularity.Then the Dynamic multi-granularity locking mechanism is presented in detail.This mechanism not only improves the concurrency degree of SQLite,but also guarantees the memory cost of embedded databases.