| 基于SQL Server 2000的实用并发控制技术 |
| |
| 引用本文： | 钱雪忠,黄向前.基于SQL Server 2000的实用并发控制技术[J].江南大学学报(自然科学版),2003,2(3):240-244. |
| |
| 作者姓名： | 钱雪忠 黄向前 |
| |
| 作者单位： | 江南大学,信息工程学院,江苏,无锡,214036 |
| |
| 摘 要： | 分析了SQL Server 2000的并发控制机制，在实践的基础上总结出了并发事务设计原则，并对典型并发问题、自定义锁应用等进行探讨，最后还给出了并发控制的应用实例，对各类数据库应用系统中并发控制技术的正确使用有所启示。
|
| 关 键 词： | 事务 并发 锁机制 一致性 |
| 文章编号： | 1671-7147(2003)03-0240-05 |
| 修稿时间： | 2002年11月6日 |
Practical Techniques of Concurrency Control Based on SQL Server 2000 |
| |
| QIAN Xue-zhong,HUANG Xiang-qian.Practical Techniques of Concurrency Control Based on SQL Server 2000[J].Journal of Southern Yangtze University:Natural Science Edition,2003,2(3):240-244. |
| |
| Authors: | QIAN Xue-zhong HUANG Xiang-qian |
| |
| Abstract: | In this paper, concurrency control mechanism of SQL SERVER 2000 is analyzed and the principle of concurrent transaction designing is summarized on the basis of practice. Besides, typical concurrent problems and applications of locking manually are deeply studied by the way of repeating experiments and tests. Finally, an example of using techniques of concurrency control is given. By applying techniques of concurrency control into different database application system, this paper brings effect as throwing out a brick to attract a jade. |
| |
| Keywords: | transaction concurrency lock mechanism consistency |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
