Call for Paper

CAE solicits original research papers for the October 2021 Edition. Last date of manuscript submission is September 30, 2021.

Read More

Survey on Concurrency Control Techniques

Marwa Mohamed, Mohammed Badawy, Ayman El-Sayed. Published in Control Systems.

Communications on Applied Electronics
Year of Publication: 2016
Publisher: Foundation of Computer Science (FCS), NY, USA
Authors: Marwa Mohamed, Mohammed Badawy, Ayman El-Sayed
10.5120/cae2016652194

Marwa Mohamed, Mohammed Badawy and Ayman El-Sayed. Survey on Concurrency Control Techniques. Communications on Applied Electronics 5(1):28-31, May 2016. BibTeX

@article{10.5120/cae2016652194,
	author = {Marwa Mohamed and Mohammed Badawy and Ayman El-Sayed},
	title = {Survey on Concurrency Control Techniques},
	journal = {Communications on Applied Electronics},
	issue_date = {May 2016},
	volume = {5},
	number = {1},
	month = {May},
	year = {2016},
	issn = {2394-4714},
	pages = {28-31},
	numpages = {4},
	url = {http://www.caeaccess.org/archives/volume5/number1/589-2016652194},
	doi = {10.5120/cae2016652194},
	publisher = {Foundation of Computer Science (FCS), NY, USA},
	address = {New York, USA}
}

Abstract

The coordination of the simultaneous execution of transactions in a multiuser database system may violates with consistency, performance and correctness of whole database. Data must maintain in consistency with correctness concurrency control techniques try to make balance between these characteristics and take in account time and performance of transactions. In this paper we had discussed various concurrency techniques, their advantages and disadvantages and make comparative study between them

References

  1. Carlos Cornol and Steven Morris, “Database Systems, Design, Implementation and Management”, United States of America,12th edition ,2016
  2. Samuel Kaspi and Sitalakshmi Venkatraman, “Performance Analysis of Concurrency Control Mechanisms for OLTP Databases”, International Journal of Information and Education Technology, Vol. 4, No. 4, August 2014.
  3. Md. Anisur Rahman,” An Efficient Concurrency Control Technique for Mobile Database Environment”, Global Journal of Computer Science and Technology, Vol 13,No. 2,2013.
  4. D. Lomet et Al.,” Multi-version Concurrency via Timestamp Range Conflict Management“, IEEE 28th International Conference of Data Engineering (ICDE) ,1-5 April 2012
  5. Avi Silberschartz, Henry F.Korth and S.Sudarshan,” Database System Concepts" ,NewYork McGraw-Hill, 1997, , 4th edition, pp591-638
  6. Quazi Mamuan and hidenor Nakazato, "timestamp based optimistic concurrency control", IEEE conference of TENCON 2005, Crown Promenade HotelMelbourne, Australia ,21 Nov - 24 Nov 2005.
  7. S. Shanwal and S. Kumar,” Secure concurrency control algorithm for multilevel secure databases”, The Next Generation Information Technology Summit (4th International Conference) , Noida,26-27 Sept. 2013
  8. S.Sippu and Soisalon-Soininen,"Transaction Processing, Data-Centric Systems and Applications", Springer international publishing Switzerland, Nov. 2014.
  9. Mohammad Sadoghi et Al,” Reducing database locking contention through multi-version concurrency”, Proceedings of the VLDB Endowment, Volume 7 Issue 13, August 2014
  10. Priyanka Kumar, Sathya Peri and K. Vidyasankar," A TimeStamp Based Multi-version STM Algorithm”, Distributed Computing and Networking15th International Conference, Coimbatore, India, January 4-7, 2014
  11. Sonal Kanungo and Morena Rustom. D,"Analysis and Comparison of Concurrency Control Techniques",International Journal of Advanced Research in Computer and Communication Engineering Vol. 4, Issue 3, March 2015.
  12. Wolf Stephan et al. " In Memory Data Management and Analysis" , Springer International Publishing Switzerland 2015 , August 26, 2013, pp.82-93.‏
  13. Dahlia Malkhi and Jean-Philippe Martin,” Spanner's concurrency control“,Newsletter ACM SIGACT News, Volume 44, Issue 3, September 2013 ,Pages 73-77.
  14. Ramez Elmasri and Shamkant B. Navathep,” Fundamentals of Database Systems”, Pearson,sixth edition,2011,pp 776-800.
  15. Rashmi Srinivasa, Craig Williams and Paul F. Reynolds Jr,” A New Look at Timestamp Ordering Concurrency Control”, database and expert Systems Applications, 12international conference, Munich, Germany, 3-5 sep. 2001.
  16. Jaypalsinh A. Gohil and Prashant M. Dolia, ”Study and Comparative Analysis of Basic Pessimistic and Optimistic Concurrency Control Methods for Database Management System”, International Journal of Advanced Research in Computer and Communication Engineering, Vol. 5, Issue 1, January 2016.
  17. Ashish Srivastava, Udai Shankar and Sanjay Kumar Tiwari,” A Protocol for Concurrency Control in Real-Time Replicated Databases System”, International Journal of Computer Networks and Wireless Communications (IJCNWC), Vol.2, No.3, June 2012.
  18. Jose M. Faleiro and Daniel J. Abadi, “Rethinking serializable multiversion concurrency control”, Proceedings of the VLDB Endowment, Vol. 8, No. 11, 2015.
  19. Per-Åke Larson et Al.,”High-performance concurrency control mechanisms for main-memory databases”,” Proceedings of the VLDB Endowment”, Volume 5, Issue 4, December 2011, PP. 298-309.
  20. NASER S. BARGHOUTI AND GAIL E. KAISER, "Concurrency Control in Advanced Database Applications", ACM Computing Surveys, Vol 23, No 3, September 1991.
  21. Peter Rob and Carlos Coronel,” Database Systems: Design, Implementation, and Management”, Joe Sabatino Publisher, tenth edition, 2013, USA. ISBN-13: 978-1111969608

Keywords

Concurrency, locking, optimistic, multi version, performance