Design, Implementation and Performance Analysis of Concurrency Control Algorithm with Architecture for Temporal Database
Jaypalsinh A. Gohil, Prashant M. Dolia · International Journal of Database Management Systems · 2016
Concurrency control mechanism is one of the critical factors which affect the overall performance of database system.The conflicting situations are normal phenomena in multiuser distributed transaction environment.Concurrency situation is not desirable for time dependent and time critical large database applications; it must be efficiently controlled and managed to ensure consistency of database system.The time aspect of data can be easily represented by temporal database, it allows you to associate time element with data through temporal validity support.Concurrency control mechanism elevates to a new height when it is implemented on temporal database especially for multiuser distributed transaction environment and it requires a special treatment.For consistency requirement to be true different user sessions of a distributed transaction running simultaneously must produce meaningful and consistent results otherwise it leaves database into inconsistent state.Traditionally timestamp and locking based approaches are used to encounter the concurrency problem.This research study proposes an efficient concurrency algorithm which is a mixture of both timestamp and locking approach suitable for temporal database environment where more than one users of distributed transaction tries to access the common resource.The scope of research involves design, implementation, experimental study and performance analysis of proposed algorithm in comparison with pessimistic and optimistic concurrency control mechanisms.The proposed algorithm is implemented through trigger using Oracle 12c which supports temporal database consistency through temporal validity support and efficient locking mechanism.Concurrency and locking situation is graphically represented in the experiment with the help of Oracle 12c enterprise manager.