Comparison and an Improved Validation Optimistic Approach for Concurrency Control

Authors(2) :-Monika Patel, Dr. Dhiren B Patel

Concurrency Control entails the synchronization of accesses to the distributed database, such that the integrity of the database is maintained. Devising an efficient concurrency control technique is challenging. There is a need for improvised concurrency control technique to coordinate the simultaneous execution of transactions in a multi-processing database system. Traditionally, concurrency control techniques are locking, timestamp ordering and optimistic. These techniques have been evaluated by analytical modeling. In this undertaken work, the analytical modeling has been investigated and evaluated. The concurrency control in order to improve optimistic validation method with the traditional techniques, a new technique has been proposed.

Authors and Affiliations

Monika Patel
MCA Department, S. K. Patel Institute Computer Studies, Gandhinagar, Gujarat, India
Dr. Dhiren B Patel
Department of Computer Science, Gujarat Vidhyapith, Ahmedabad, Gujarat, India

DBMS, DDBMS, Concurrency, Lock Maintenance, Restart Overhead, Abort Ratio, Deadlock Possibility

  1. B. Bhargava, Concurrency Control in Database Systems, IEEE Transaction on Knowledge and Data Engineering, JANUARY/FEBRUARY 1999.
  2. A. Thomasian, Concurrency Control: Methods, Performance, and Analysis, ACM Computing Surveys, March 1998.
  3. H. T. Kung, J. T. Robinson, On Optimistic Methods for Concurrency Control, ACM Transactions on Database Systems, Vol 6, No. 2, June 1981.
  4. P. L. Lehman, AND S. B. Yao, Efficient locking for concurrent operations on B-trees. Submitted for publication.
  5. R. Shrinivasan, Network-Aided Concurrency Control in Distributed Databases, January 2002.
  6. S. Ceri, G. Pelagatti, Distributed Databases Principals and Systems, McGraw-Hill International Edition, 1985.
  7. A. Thomasian, Distributed Optimistic Concurrency Control Methods for High Performance Transaction Processing, IEEE Transaction on Knowledge and Data Engineering, VOL. 10, NO. 1, January/February 1998.
  8. G. Coulouris, J. Dollimore and T. Kindberg T. Distributed Systems Concepts and Design, published by Pearson Education Limited 2005.
  9. Morris R., Wong W., Performance analysis of locking and optimistic concurrency control algorithms, May 1985.
  10. M. Mohamed, M. Badawy, A. El-Sayed., Survey on Concurrency Control Techniques, Communications on Applied Electronics (CAE) – ISSN : 2394-4714 Foundation of Computer Science FCS, New York, USA,2016

Publication Details

Published in : Volume 5 | Issue 1 | January-February 2019
Date of Publication : 2019-01-30
License:  This work is licensed under a Creative Commons Attribution 4.0 International License.
Page(s) : 16-21
Manuscript Number : CSEIT19517
Publisher : Technoscience Academy

ISSN : 2456-3307

Cite This Article :

Monika Patel, Dr. Dhiren B Patel, "Comparison and an Improved Validation Optimistic Approach for Concurrency Control", International Journal of Scientific Research in Computer Science, Engineering and Information Technology (IJSRCSEIT), ISSN : 2456-3307, Volume 5, Issue 1, pp.16-21, January-February-2019. Available at doi : https://doi.org/10.32628/CSEIT19517
Journal URL : http://ijsrcseit.com/CSEIT19517

Article Preview