Two-version based concurrency control and recovery in real-time client/server databases

Research output: Journal Publications and Reviews (RGC: 21, 22, 62)21_Publication in refereed journalpeer-review

11 Scopus Citations
View graph of relations



Original languageEnglish
Pages (from-to)506-524
Journal / PublicationIEEE Transactions on Computers
Issue number4
Online published2 Apr 2003
Publication statusPublished - Apr 2003
Externally publishedYes


While there has been a significant amount of research in real-time concurrency control, little work has been done in logging and recovery for real-time databases. This paper proposes a two-version approach which considers both real-time concurrency control and recovery. We propose a network-server-based architecture and algorithms which can not only reduce the blocking time of higher-priority transactions and improve the response time of client-side read-only transactions, but also provide a diskless runtime logging mechanism and an efficient and predictable recovery procedure. The performance of the algorithms was verified by a series of simulation experiments by comparing the algorithms with the well-known Priority Ceiling Protocol (PCP), the Read/Write PCP, the New PCP, and the 2-version two-phase locking protocol, for which we have very encouraging results. The schedulability of higher-priority transactions and the response time of client-side read-only transactions were all greatly improved.

Research Area(s)

  • Client/server databases, Concurrency control, Logging, Read-only transactions, Real-time database, Recovery, Write through procedure