Open AccessConcurrency Control in Database Management System
Author(s) -
Thi Ngoc Thanh Nguyen
Publication year - 2021
Publication title -
european journal of electrical engineering and computer science
Language(s) - English
Resource type - Journals
ISSN - 2736-5751
DOI - 10.24018/ejece.2021.5.4.352
Subject(s) - computer science , multiversion concurrency control , non lock concurrency control , concurrency control , optimistic concurrency control , distributed concurrency control , database , concurrency , timestamp based concurrency control , isolation (microbiology) , sql , database tuning , distributed computing , database transaction , database design , view , microbiology and biotechnology , biology
Nowadays, most application software systems are aimed at multi-user environments and simultaneous access to the same database. Therefore, concurrency controllers are an integral part of any database management system. The concurrency controller plays an important role in controlling transactions which perform simultaneous access to the database without conflict. This paper presents an overview and illustration how to use concurrency control in database management system of Microsoft SQL Server.