| ORACLE数据库的并发控制与效率分析 |
| |
| 引用本文： | 陈珉,王铁军.ORACLE数据库的并发控制与效率分析[J].武汉大学学报(信息科学版),1994(2). |
| |
| 作者姓名： | 陈珉 王铁军 |
| |
| 作者单位： | 武汉测绘科技大学 |
| |
| 摘 要： | 介绍了ＯＲＡＣＬＥ数据库环境下的各种并发控制锁及遵守的子树式协议，分析了ＯＲＡＣＬＥ数据库并发控制中隐含的问题，提出了避免“死机”的方法，并在太极机多用户ＯＲＡＣＬＥ数据库上实现了并发控制下ＯＲＡＣＬＥ数据库效率检测分析，得出了ＯＲＡＣＬＥ数据库在此环境下效率峰值是５个用户的结论。同时指出，在８～１４个用户时，随用户数的增加效率将呈阶梯性下降。
|
| 关 键 词： | ORACLE 数据库 并发控制 锁 效率测试分析 |
ORACLE Database Parallel Control and Efficiency Analysis |
| |
| Chen Min,Wang Tiejun.ORACLE Database Parallel Control and Efficiency Analysis[J].Geomatics and Information Science of Wuhan University,1994(2). |
| |
| Authors: | Chen Min Wang Tiejun |
| |
| Abstract: | Tnis paper describes the basic parallel control scheme of an oracle relation database SyStem,both in various locks and in sub-tree agreements. By analysing the probferns occured in parallel control sharing data,we have provided an approach to avoid deadlock.In a final Part,we have present6d an efficiency test methods,and POinted out the resultS of our research. Efficiency increased when number of user increased from one to five,and decreased when 'number of user increased from five to fourteen. Especially, we have proved the efficiency decreased very fast when the number in'Creased from eight to fourteen. |
| |
| Keywords: | ORACLE database parallel control lock efficiency test and analysis |
| 本文献已被 CNKI 等数据库收录！ |
|
