We apologize for a recent technical issue with our email system, which temporarily affected account activations. Accounts have now been activated. Authors may proceed with paper submissions. PhDFocusTM
CFP last date
20 December 2024
Call for Paper
January Edition
IJCA solicits high quality original research papers for the upcoming January edition of the journal. The last date of research paper submission is 20 December 2024

Submit your paper
Know more
The week's pick
Responsive image
Improved Shuffled Frog Leaping Algorithm with Self-Adaptive Shuffling for Fuzzy Logic PD+G Controller Optimization in Robotic Manipulators

Duc Hoang Nguyen
Random Articles
Reseach Article

Graphical Representation of Optimistic Locking and Concurrency Control for Temporal Database using Oracle 12c Enterprise Manager

by Jaypalsinh A. Gohil, Prashant M. Dolia
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 148 - Number 7
Year of Publication: 2016
Authors: Jaypalsinh A. Gohil, Prashant M. Dolia
10.5120/ijca2016911214

Jaypalsinh A. Gohil, Prashant M. Dolia . Graphical Representation of Optimistic Locking and Concurrency Control for Temporal Database using Oracle 12c Enterprise Manager. International Journal of Computer Applications. 148, 7 ( Aug 2016), 29-36. DOI=10.5120/ijca2016911214

@article{ 10.5120/ijca2016911214,
author = { Jaypalsinh A. Gohil, Prashant M. Dolia },
title = { Graphical Representation of Optimistic Locking and Concurrency Control for Temporal Database using Oracle 12c Enterprise Manager },
journal = { International Journal of Computer Applications },
issue_date = { Aug 2016 },
volume = { 148 },
number = { 7 },
month = { Aug },
year = { 2016 },
issn = { 0975-8887 },
pages = { 29-36 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume148/number7/25771-2016911214/ },
doi = { 10.5120/ijca2016911214 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T23:52:44.001010+05:30
%A Jaypalsinh A. Gohil
%A Prashant M. Dolia
%T Graphical Representation of Optimistic Locking and Concurrency Control for Temporal Database using Oracle 12c Enterprise Manager
%J International Journal of Computer Applications
%@ 0975-8887
%V 148
%N 7
%P 29-36
%D 2016
%I Foundation of Computer Science (FCS), NY, USA
Abstract

In a multiuser database environment, multiple simultaneous transactions may update the same data. Transactions executing simultaneously must produce meaningful and consistent results. In multiuser database environment conflicts are common. If conflicting situations are not dealt properly then it can harm the database. To minimize the concurrency problem the locking approach is used. Our study focus on implementation of optimistic lock through trigger on data objects of temporal database to resolve the conflicts among multiple user sessions. Through step by step graphical representation this study highlights how to acquire and release an optimistic lock on data objects in case of conflict. This experimental study shows each locking, unlocking situations along with conflicting situations graphically through Oracle 12C enterprise manager.

References
  1. P.A. Bernstein and N. Goodman, “Concurrency Control in Distributed Database Systems", ACM Computing Surveys, Vol. 13(2), June 1981, pp. 186 - 221.
  2. K. P. Eswaran, J. N. Gray, R. A. Lorie, and I. L. Traiger “The notions of consistency and predicate locks in a database system", Communications of the ACM, 19(11):624-633, November 1976.
  3. J. N. Gray, R. A. Lorie, G. R. Putzolu, and I. L. Traiger “Granularity of locks and degrees of consistensy in a shared data base", In G. M. Nijssen, editor, Modeling in Data Base Management Systems, pages 365{395. North-Holland, Amsterdam, The Netherlands, 1976.
  4. J.A.Gohil, Dr.P.M.Dolia “Comparative Study and Performance Analysis of Optimistic and Pessimistic Approaches for Concurrency Control Suitable for Temporal Database Environment”, National Conference on Emerging Trends in Information & Communication Technology (NCETICT), 2013
  5. Jaypalsinh A. Gohil, Dr. Prashant M. Dolia, “Graphical Representation of Pessimistic Locking and Concurrency Control for Temporal Database using Oracle 12c Enterprise Manager”, International Journal of Innovations in Engineering and Technology (IJIET), Volume 6, Issue 4, April 2016
  6. Jaypalsinh A. Gohil, Dr. 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
  7. Kung H. T. and Robinson J. T. "On Optimistic Methods for Concurrency Control", ACM Trans. on Database Systems, V. 6. No. 2, 1981.
  8. Richard T. Snodgrass and Ilsoo Ahn, "Temporal Databases", IEEE Computer 19(9), pp. 35–42, September, 1986
  9. Oracle DBA “Tips and Techniques Gavin Soorma Oracle 12c New Feature - Temporal Validity” http://gavinsoorma.com/2013/08/oracle-12c-new-feature-emporal-validity/.
  10. Franaszek, P. and J. Robinson “Limitation of concurrency in transaction processing”, ACM Trans. Database Syst., 10: 1-28, 1985.
  11. Amer Abu Ali “On Optimistic Concurrency Control for Real-Time Database Systems”, American Journal of Applied Sciences 3 (2): 1706-1710, 2006
  12. Franck Pachot “All about locks: DML, DDL, foreign key, online operations, dbi services”, Switzerland
  13. J. A. Gohil, P.M.Dolia, “Testing Temporal Data Validity in Oracle 12c using Valid Time Temporal Dimension and Queries”, Journal of Engineering Computers & Applied Sciences(JECAS), Volume 4, No.4, April 2015.
  14. Jaypalsinh A. Gohil, Dr. Prashant M. Dolia “Checking and Verifying Temporal Data Validity using Valid Time Temporal Dimension and Queries In Oracle 12c”, International Journal of Database Management Systems (IJDMS), Vol.7, No.4, August 2015.
  15. Yongdong Wang, Lawrence A. Rowe “Cache Consistency and Concurrency Control in Client/Server DBMS Architecture”.
Index Terms

Computer Science
Information Sciences

Keywords

CC PCC OCC RCN Oracle 12c.

Powered by PhDFocusTM