Extensions to optimistic concurrency control with time intervals

Although an optimistic approach has been shown to be better suited than locking protocols for real time database systems (RTDBS), it has the problems of unnecessary restarts and heavy restart overhead. The article identifies the unnecessary restart problem in OCC-TI (Optimistic Concurrency Control with Time Intervals), proposes a solution to this problem and demonstrates that the solution will produce a correct result. Additionally, two extensions to the basic dynamic adjustment of the serialization order conflict resolution method used in OCC-TI are proposed. Experiments with a prototype implementation of a real time database system show that the proposed method clearly outperforms the original OCC-TI.

[1]  Kimmo E. E. Raatikainen,et al.  Transaction Processing in the RODAIN Real-Time Database System , 1997, RTDB.

[2]  Donald F. Towsley,et al.  Experimental Evaluation of Real-Time Optimistic Concurrency Control Schemes , 1991, VLDB.

[3]  Theo Härder,et al.  Observations on optimistic concurrency control schemes , 1984, Inf. Syst..

[4]  Kwok-Wa Lam,et al.  An Efficient Real-time Optimistic Concurrency Control Protocol , 1995, ARTDB.

[5]  Sang Hyuk Son,et al.  A Study of Concurrency Control in Real-Time, Active Database Systems , 2002, IEEE Trans. Knowl. Data Eng..

[6]  Sang Hyuk Son,et al.  Using dynamic adjustment of serialization order for real-time database systems , 1993, 1993 Proceedings Real-Time Systems Symposium.

[7]  Kimmo E. E. Raatikainen,et al.  A Distributed Real-Time Main-Memory Database for Telecommunication , 1999, Databases in Telecommunications.

[8]  Vijay Kumar,et al.  A Study of Priority Cognizance in Conflict Resolution for Firm Real-Time Database Systems , 1997, RTDB.

[9]  Kwok-Wa Lam,et al.  Real-time optimistic concurrency control protocol with dynamic adjustment of serialization order , 1995, Proceedings Real-Time Technology and Applications Symposium.

[10]  H. T. Kung,et al.  On optimistic concurrency control , 1981 .

[11]  Kimmo E. E. Raatikainen,et al.  Dynamic adjustment of serialization order using time-stamp intervals in real-time databases , 1999, Proceedings Sixth International Conference on Real-Time Computing Systems and Applications. RTCSA'99 (Cat. No.PR00306).

[12]  Irving L. Traiger,et al.  The notions of consistency and predicate locks in a database system , 1976, CACM.

[13]  Miron Livny,et al.  Dynamic real-time optimistic concurrency control , 1990, [1990] Proceedings 11th Real-Time Systems Symposium.

[14]  Sang Hyuk Son,et al.  Performance of Concurrency Control Algorithms for Real-Time Database Systems , 1996, Performance of Concurrency Control Mechanisms in Centralized Database Systems.

[15]  Philip S. Yu,et al.  On real-time databases: concurrency control and scheduling , 1994 .

[16]  J. T. Robinson,et al.  On optimistic methods for concurrency control , 1979, TODS.

[17]  K. Raatikainen,et al.  A real-time database for future telecommunication services , 1997 .

[18]  Daniel A. Menascé,et al.  Optimistic versus pessimistic concurrency control mechanisms in database management systems , 1982, Inf. Syst..

[19]  L. DiPippo,et al.  Real-Time Databases , 1995 .