摘要
分析了SQL Server 2000的并发控制机制,在实践的基础上总结出了并发事务设计原则,并对典型并发问题、自定义锁应用等进行探讨,最后还给出了并发控制的应用实例。对各类数据库应用系统中并发控制技术的正确使用有所启示。
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.
出处
《江南大学学报（自然科学版）》
CAS
2003年第3期240-244,共5页
Joural of Jiangnan University (Natural Science Edition)
关键词
事务
并发
锁机制
一致性
transaction
concurrency
lock mechanism
consistency
