Dynamic adjustment of execution order in real-time databases

Summary form only given. Many researches have been devoted to designing appropriate concurrency control algorithms for real-time database systems, which not only satisfy consistency requirements but also meet transaction timing constraints as much as possible. Optimistic concurrency control protocols have the nice properties of being nonblocking and deadlock-free, but they have the problems of late conflict detection and transaction restarts. Although the number of transaction restarts is reduced by dynamic adjustment of serialization order (DASO) in real-time database systems, it still has some unnecessary transaction restarts. We first propose a new method called dynamic adjustment of execution order (DAEO) and a new optimistic concurrency control algorithm based on DAEO, which can reduce the number of unnecessary restarts near to zero and outperforms the previous algorithms, and then discuss the experiments and the results.

[1]  Kimmo E. E. Raatikainen,et al.  Using importance of transactions and optimistic concurrency control in firm real-time databases , 2000, Proceedings Seventh International Conference on Real-Time Computing Systems and Applications.

[2]  Hector Garcia-Molina,et al.  An Overview of Real-Time Database Systems , 1995, NATO ASI RTC.

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

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

[5]  Saud A. Aldarmi Real-Time Database Systems: Concepts and Design , 1998 .

[6]  Juhnyoung Lee Concurrency control algorithms for real-time database systems , 1994 .

[7]  Jan Lindström,et al.  Optimistic Concurrency Control Methods for Real-Time Database Systems , 2003 .

[8]  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.

[9]  Jan Lindstr Optimistic Concurrency Control Methods for Real-Time Database Sys- tems , 2001 .

[10]  Miron Livny,et al.  Data access scheduling in firm real-time database systems , 1992, Real-Time Systems.

[11]  Donald F. Towsley,et al.  On using priority inheritance in real-time databases , 1991, [1991] Proceedings Twelfth Real-Time Systems Symposium.

[12]  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).