| SQL Server 2000锁定分析及死锁预防策略 |
| |
| 引用本文： | 冯世斌. SQL Server 2000锁定分析及死锁预防策略[J]. 内蒙古师范大学学报(自然科学版), 2006, 35(3): 317-320 |
| |
| 作者姓名： | 冯世斌 |
| |
| 作者单位： | 内蒙古师范大学,数学科学学院,内蒙古,呼和浩特,010022 |
| |
| 摘 要： | 在事务并发访问数据库的过程中，锁是数据完整性和一致性的重要保证．通过对SQL Server 2000数据库锁机制的研究，介绍了SQL Server 2000数据库锁的概念、粒度和保持以及锁的模式和相容性．对死锁问题进行了具体分析，并提出相应的预防策略；分析了实际应用中用户自定义锁定问题，给出一些相关的解决实例．
|
| 关 键 词： | SQL Server 事务 并发控制 锁 死锁 封锁粒度 |
| 文章编号： | 1001-8735(2006)03-0317-04 |
| 修稿时间： | 2005-11-08 |
The Lock Analyses and the Deadlock Prevention Strategies in SQL Server 2000 |
| |
| FENG Shi-bin. The Lock Analyses and the Deadlock Prevention Strategies in SQL Server 2000[J]. Journal of Inner Mongolia Normal University(Natural Science Edition), 2006, 35(3): 317-320 |
| |
| Authors: | FENG Shi-bin |
| |
| Abstract: | The lock is a very important concept to ensure the integrality and the coherence of the data during concurrent transactions visit the database.Understanding the lock mechanisms and grasping the(database) lock methods is the basis for cooperating in the concurrent operation between users,so that could(reduce) the deadlock probabilities.Through studying the lock mechanisms of SQL Server 2000,this text has introduced the concept,holding,schema and the consistence of the lock,also bring up some strategies and analyses to prevent the deadlock on concurrent transaction.Self-definition lock problems were analyzed with some examples. |
| |
| Keywords: | SQL Server |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
