Concurrency Control in Database Management System



Abstract Views
530

Downloads
520

Citations

Share

##plugins.themes.bootstrap3.article.sidebar##

Submitted Jul 31, 2021
Published Aug 21, 2021
10.24018/ejece.2021.5.4.352

Abstract viewed = 530 times

Table of Contents

##plugins.themes.bootstrap3.article.main##

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.

Keywords: Concurrency Control, Database Management System, Transaction, Conflict Database

Downloads

Download data is not yet available.

References

  1. A. Silberschatz, H. F. Korth, S. Sudarshan, Database System Concepts ? 3rd Edition, McGraw - Hill, 1999.
     Google Scholar
  2. C. J. Date, Database System, Pearson Addison Wesley, 2004.
     Google Scholar
  3. H. G. Molina, J. D. Ullman, J. Widom, Database Systems: The Complete Book, Prentice - Hall, 2002.
     Google Scholar
  4. R. Elmasri, S. R. Navathe, Fundamentals of Database Systems ? 7th Edition, Pearson - Addison Wesley, 2016.
     Google Scholar
  5. Concurrency Control, Berkeley University, http://inst.eecs.berkeley.edu/~cs186/fa05/lecs/18cc-6up.pdf, January 10, 2018.
     Google Scholar
  6. Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems ? 3rd, International Edition 2003.
     Google Scholar
  7. SQL Server Recovery Models, http://databases.about.com/od/sqlserver/a/recoverymodels.htm, March 5, 2018.
     Google Scholar