TY - GEN
T1 - Using separate algorithms to process read-only transactions in real-time systems
AU - Lam, Kwok Wa
AU - Son, Sang H.
AU - Lee, Victor C S
AU - Hung, Sheung-Lun
PY - 1998/12
Y1 - 1998/12
N2 - In this paper, we investigate the approach of using separate algorithms to process read-only transactions in real-time systems. A read-only transaction (ROT) is a transaction that only reads, but does not update any data item. Since there is a significant proportion of ROTs in several real-time systems, it is important to investigate how to process ROTs effectively. Using an algorithm to process ROTs separately from update transactions may reduce the interference between ROTs and update transactions. This reduced interference alleviates the impact of concurrency control on real-time priority-driven scheduling and improves the timeliness of the system. Moreover, we explore the different consistency requirements of ROTs. Particularly, we define a weaker form of consistency, view consistency, which allows ROTs to perceive different serialization order of update transactions. While view consistency permits non-serializability, ROTs are still ensured to see consistent data. We propose two robust algorithms for different consistency requirements of ROTs. The two algorithms are robust in the sense that they can be used in a compatible way so that a real-time system can provide different consistent data for different applications. The performance of two algorithms was examined through a series of simulation studies. The simulation results show that the two algorithms outperform the high-priority two-phase locking protocol.
AB - In this paper, we investigate the approach of using separate algorithms to process read-only transactions in real-time systems. A read-only transaction (ROT) is a transaction that only reads, but does not update any data item. Since there is a significant proportion of ROTs in several real-time systems, it is important to investigate how to process ROTs effectively. Using an algorithm to process ROTs separately from update transactions may reduce the interference between ROTs and update transactions. This reduced interference alleviates the impact of concurrency control on real-time priority-driven scheduling and improves the timeliness of the system. Moreover, we explore the different consistency requirements of ROTs. Particularly, we define a weaker form of consistency, view consistency, which allows ROTs to perceive different serialization order of update transactions. While view consistency permits non-serializability, ROTs are still ensured to see consistent data. We propose two robust algorithms for different consistency requirements of ROTs. The two algorithms are robust in the sense that they can be used in a compatible way so that a real-time system can provide different consistent data for different applications. The performance of two algorithms was examined through a series of simulation studies. The simulation results show that the two algorithms outperform the high-priority two-phase locking protocol.
KW - Concurrency control
KW - serializability
KW - transaction scheduling
KW - database systems
KW - realtime systems
UR - https://www.scopus.com/pages/publications/0032302939
UR - https://www.scopus.com/record/pubmetrics.uri?eid=2-s2.0-0032302939&origin=recordpage
U2 - 10.1109/REAL.1998.739730
DO - 10.1109/REAL.1998.739730
M3 - RGC 32 - Refereed conference paper (with host publication)
SN - 0-8186-9212-X
SP - 50
EP - 59
BT - Proceedings 19th IEEE Real-Time Systems Symposium
PB - IEEE
T2 - Proceedings of the 1998 19th IEEE Real-Time Systems Symposium
Y2 - 2 December 1998 through 4 December 1998
ER -