A performance study of concurrency control in a real-time main memory database system

  • Authors:
  • Le Gruenwald;Sichen Liu

  • Affiliations:
  • -;-

  • Venue:
  • ACM SIGMOD Record
  • Year:
  • 1993

Quantified Score

Hi-index 0.00

Visualization

Abstract

Earlier performance studies of concurrency control algorithms show that in a disk-resident real-time database system, optimistic algorithms perform better than two phase locking with higher priority (2PL-HP). In a main memory real-time database system, disk I/Os are eliminated and thus more transactions are enabled to meet their real-time constraints. Lack of disk I/Os in this environment requires concurrency control be re-examined. This paper conducts a simulation study to compare 2PL-HP with a real time optimistic concurrency control algorithm (OPT-WAIT-50) for a real time main memory database system, MARS. The results show that OPT-WAIT-50 outperforms 2PL-HP with finite resources.