Comparative Study and Performance Evaluation of JAG_TDB_CC Concurrency Control Algorithm for Temporal Database

The overall performance of database system can be hinder by uncontrolled concurrency. In multi-user distributed database environment conflicts are normal. Concurrency is undesirable for large time-dependent and time-critical database applications; it must be monitored and managed effectively to ensure consistency of the database system. Uncontrolled concurrency can leave the database in an inconsistent state and can become obstacle in the overall performance of database system. Traditionally time stamps and lock-based approaches are used to address the problem of concurrency. The study showcases the new breed of algorithm known as JAG_TDB_CC concurrency control algorithm, which is a unique blend of a timestamp and lock-based concurrency control mechanisms. This paper shows a comparative study and performance evaluation of the JAG_TDB_CC concurrency control algorithm in comparison to traditional pessimistic and optimistic mechanisms for managing a concurrency for temporary database system using Oracle 12c.