| SQL数据库中并发控制的研究 |
| |
| 引用本文： | 赵慧玲,刘美荣. SQL数据库中并发控制的研究[J]. 长春工程学院学报(自然科学版), 2009, 10(2): 78-81 |
| |
| 作者姓名： | 赵慧玲 刘美荣 |
| |
| 作者单位： | 1. 长春工程学院,软件学院,长春,130012
2. 空军93253部队,大连,116023 |
| |
| 摘 要： | 通过对数据库中并发控制的研究,介绍了SQL数据库中锁机制的种类和事务间的隔离级别,并结合实际阐述了怎样利用锁和事务隔离级别解决多用户并发问题。
|
| 关 键 词： | 并发 锁 隔离级别 |
The research of concurrent control in SQL database |
| |
| ZHAO Hui-ling,LIU Mei-rong. The research of concurrent control in SQL database[J]. Journal of Changchun Institute of Technology(Natural Science Edition), 2009, 10(2): 78-81 |
| |
| Authors: | ZHAO Hui-ling LIU Mei-rong |
| |
| Affiliation: | ZHAO Hui-ling,et al.(Software Institute,Changchun Instituteof Technology,changchun 130012,China) |
| |
| Abstract: | In database,when many users operate the identical set of data in the identical database simultaneously,possibly will have the loss to renew,dirty reads,reading can not be repeated,hallucinations reading and so on.Through the research of concurrent control in database,this article introduced the types of lock mechanism and the levels of isolation between affairs in SQL database,and elaborated actually how to use locks and levels of isolation between affairs to solve the multiuser concurrent problems. |
| |
| Keywords: | concurrent lock levels of isolation between affairs |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
