首页 | 本学科首页   官方微博 | 高级检索  
     

SQL SERVER中事务隔离级别的实例分析
引用本文:张战杰,王鸿飞. SQL SERVER中事务隔离级别的实例分析[J]. 软件, 2011, 32(2): 87-89. DOI: 10.3969/j.issn.1003-6970.2011.02.026
作者姓名:张战杰  王鸿飞
作者单位:漯河职业技术学院计算机工程系,河南,漯河,462002
摘    要:通过具体实例分析了SQLSERVER2000在不同的事务隔离级别中,事务并发操作带来的数据读取的不一致性,从而为具体应用程序既要保证数据完整、一致性又要提高事务并发控制策略中事务的并发程度提供了一种依据和参考。

关 键 词:事务  隔离级别  并发

Example Analyzing of Transaction Isolation Level in SQL SERVER
ZHANG Zhan-jie,WANG Hong-fei. Example Analyzing of Transaction Isolation Level in SQL SERVER[J]. Software, 2011, 32(2): 87-89. DOI: 10.3969/j.issn.1003-6970.2011.02.026
Authors:ZHANG Zhan-jie  WANG Hong-fei
Affiliation:(The Computer Engineering Department of Luohe Vocatinal & Technical College,Luohe,462002,China)
Abstract:Through concrete examples,this article analyzes the data acess’s inconsistency that is brought by the concurrent operation of transaction in the sql server 2000’s different transaction isolation levels,so as to provide the application a basis and reference that may ensure data integrity and consistency and raise the transaction’s concurrency degree in the transacton concurrency control strategy.
Keywords:Transaction  Isolation-level  Concurrency
本文献已被 CNKI 维普 万方数据 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号