Proceedings of the 2016 2nd International Conference on Materials Engineering and Information Technology Applications (MEITA 2016)

Concurrency Control and Self-optimization based on SQL Server Database System

Authors
Rongchuan Guo
Corresponding Author
Rongchuan Guo
Available Online February 2017.
DOI
10.2991/meita-16.2017.14How to use a DOI?
Keywords
Transaction; SQL Server; concurrent; lock mechanism
Abstract

With the great development of computer science technology and electronic information, all enterprises have established their own information systems. The database as the core and foundation of information system, it has also been more and more widely used. So the performance of the database has been widespread concern in the industry. Traditional performance testing work by hand, it is impossible to simulate high-volume users concurrent access to the real situation of the system, the effect is not very satisfactory. With the continuous improvement of technical means there have been many related software testing tools to simulate a large number of concurrent users of the scene, so the system performance inspection. The concurrency control mechanism of SQL Server is analyzed, and the principle of concurrency service design is summarized on the basis of practice. The typical concurrency problem, custom lock application and so on are discussed. Finally, an application example of concurrency control is given.

Copyright
© 2017, the Authors. Published by Atlantis Press.
Open Access
This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

Volume Title
Proceedings of the 2016 2nd International Conference on Materials Engineering and Information Technology Applications (MEITA 2016)
Series
Advances in Engineering Research
Publication Date
February 2017
ISBN
978-94-6252-304-3
ISSN
2352-5401
DOI
10.2991/meita-16.2017.14How to use a DOI?
Copyright
© 2017, the Authors. Published by Atlantis Press.
Open Access
This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Cite this article

TY  - CONF
AU  - Rongchuan Guo
PY  - 2017/02
DA  - 2017/02
TI  - Concurrency Control and Self-optimization based on SQL Server Database System
BT  - Proceedings of the 2016 2nd International Conference on Materials Engineering and Information Technology Applications (MEITA 2016)
PB  - Atlantis Press
SP  - 59
EP  - 63
SN  - 2352-5401
UR  - https://doi.org/10.2991/meita-16.2017.14
DO  - 10.2991/meita-16.2017.14
ID  - Guo2017/02
ER  -