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

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...

Full description

Saved in:
Bibliographic Details
Published in:International journal of computer applications 2016-01, Vol.148 (7), p.29-36
Main Authors: Gohil, Jaypalsinh A, Dolia, Prashant M
Format: Article
Language:English
Subjects:
Concurrency
Graphical representations
Locking
Locks
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary: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.
ISSN:0975-8887
0975-8887
DOI:10.5120/ijca2016911214