© 2003 by British Computer Society
| ||||||||||||||||||||||||||||||||||||||||||||||||||||
The Impacts of Write-Through Procedures and Checkpointing on Real-Time Concurrency Control
1 Department of Computer Science and Information Engineering, National Taiwan University, Taipei, Taiwan 106, Republic of China Email: ktw@csie.ntu.edu.tw 2 Department of Computer Science and Information Engineering, National Chung Cheng University, Chiayi, Taiwan 621, Republic of China 3 Department of Computer Science, City University of Hong Kong, Kowloon, Hong Kong
In this paper, we study the impacts of checkpointing and write-through procedures, which are critical in maintaining database recoverability and transaction durability, on the performance of a well-known real-time concurrency control protocol, the Read/Write Priority Ceiling Protocol (RWPCP). Although RWPCP can guarantee the schedulability of real-time transactions, it could be unrecoverable, and the priority inversion problems could be unbounded, when transaction commitment is considered. In this paper, we first propose to extend RWPCP with deferred-commitment and extended-locking-period methods to resolve the problems. Then, we study the impacts of different checkpointing granularities and checkpointing methods on the proposed recoverable RWPCP. A detailed simulation study was conducted to evaluate the performance of the recoverable RWPCP with different checkpointing methods under various workloads.