© 2000 by British Computer Society
| ||||||||||||||||||||||||||||||||||||||||||||||||||||
The Reduced Ceiling Protocol for Concurrency Control in Real-time Databases with Mixed Transactions
1 Department of Computer Science, City University of Hong Kong, 83 Tat Chee Avenue, Kowloon, Hong Kong Email: cskylam@cityu.edu.hk 2 Department of Computer Science and Information Engineering, National Chung Cheng University, Chiayi, 621 Taiwan, Republic of China
This paper proposes a real-time concurrency control protocol called the reduced ceiling protocol (RCP) for real-time database systems consisting of hard and soft real-time transactions. The schedulability of hard real-time transactions can be improved by bounding the blocking time from soft real-time transactions. Different concurrency control strategies are proposed to resolve data conflicts between different combinations of hard and soft real-time transactions, and the properties of the RCP schedules are shown. In the RCP, methodologies are proposed to reduce the number of aborts for soft real-time transactions due to data conflicts with hard real-time transactions. Simulation experiments have been performed to study the performance of the RCP as compared with the optimistic concurrency control with wait 50 (OCC wait-50) under different workloads of soft real-time transactions, various ratios of read/write operations and deadline constraints. It has been found that the RCP can not only guarantee the performance of hard real-time transactions but also reduce the number of deadlines missed by the soft real-time transactions under all situations.
Received 28 April, 1998. Revised 3 November, 1999.