关系数据库的共享、冲突及自适应锁定算法

Share, Conflict and Adaptive Locking Method in Relational Database

为提高关系数据库的性能，本文以 ＳＱＬ ＳＥＲＶＥＲ６． Ｘ为例，建立了一个网络环境下分析研究数据库共享与竞争的测试系统，分析了数据库的存储结构、多用户共享特性及锁管理器对冲突的处理机制，提出了一种自适应锁定算法，并给出了用Ｃ程序实现该算法的主要部分的程序框图。

To improve the performance of database, this paper uses SoL SERVER to set up a testing system to analysis and research the share and competition for database in the network environment. Then the author analyses the store structure of SoL SERVER, multiuser's sharing characteristics and the mechanism of lock manager dealing with conflict. Last, this paper puts forward a method, called adaptive locking method, and gives out the program flow chart of a C program to realize main function of this method.