Comparison and an Improved Validation Optimistic Approach for Concurrency Control

Authors

  • 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

DOI:

https://doi.org/10.32628/CSEIT19517

Keywords:

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

Abstract

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.

References

  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

IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology

Downloads

Published

2019-01-30

Issue

Volume 5, Issue 1, January-February-2019

Section

Research Articles

License

Copyright (c) IJSRCSEIT

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

How to Cite

[1]
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