On optimistic concurrency control for RTDBS
F. Baothman, Anil K. Sarje, Ramesh Chander Joshi · 2002
Real-time database systems (RTDBSs) associate the concept of deadlines with transaction executions. To preserve data integrity, a RTDBS requires concurrency control protocols to synchronise transactions to access shared data. Thus, the goal of scheduling in RTDBSs is twofold: to meet timing constraints (deadlines) of the transactions and to enforce data consistency. In this paper, we investigate the performance of optimistic concurrency control (OCC) and some of its variants in a firm RTDBS under different system resource-related assumptions and we compare its performance with a locking-based scheme and a hybrid scheme (optimistic locking).