Performance study of using a new approach to transaction processing in real-time systems

Authors:
Kwok-Wa Lam;William Leung;Richard J. Millar;J. R. Paul Hanna
Affiliations:
Department of Computer Science, City University of Hong Kong;Centre of Applied Technologies, Hong Kong College of Technology;School of Computing and Mathematics, University of Ulster;School of Computing and Mathematics, University of Ulster
Venue:
MS'06 Proceedings of the 17th IASTED international conference on Modelling and simulation
Year:
2006

Citing 8
Cited 0

Observations on optimistic concurrency control schemes

Information Systems - Special issue: Databases:8Mtheir creation, management and utilization
Concurrency control and recovery in database systems

Concurrency control and recovery in database systems
Scheduling real-time transactions: a performance evaluation

ACM Transactions on Database Systems (TODS)
On being optimistic about real-time constraints

PODS '90 Proceedings of the ninth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
On optimistic methods for concurrency control

ACM Transactions on Database Systems (TODS)
Read-only transactions in a distributed database

ACM Transactions on Database Systems (TODS)
Scheduling Real-time Transactions: a Performance Evaluation

VLDB '88 Proceedings of the 14th International Conference on Very Large Data Bases
Experimental Evaluation of Real-Time Optimistic Concurrency Control Schemes

VLDB '91 Proceedings of the 17th International Conference on Very Large Data Bases

Quantified Score

Hi-index	0.00

Visualization

Abstract

In this study, we investigate an approach of using a separate algorithm to process read-only transactions (ROTs) in real-time database systems. The study is motivated by the dominance of read only transactions (ROTs) in many real-time applications. It will reduce the interference between ROTs and update transactions (UTs) due to their data conflicts by separate processing of ROTs, thus, enhancing the system concurrency. Particularly, we devise an efficient separate algorithm to process ROTs while a conventional concurrency control protocol can be employed to process UTs. The undesirable overhead caused by transaction restarts and blockings due to concurrency control can be alleviated. Consequently, the efficiency and timeliness of the system can be improved. The simulation results show that the performance of ROTs in terms of miss rate and restart rate is improved significantly whilst that of UTs is also improved slightly.