Simulating concurrency control with deadlock avoidance in real-time transaction processing

  • Authors:
  • W. Haque

  • Affiliations:
  • University of Northern British Columbia, Prince George, BC, Canada

  • Venue:
  • International Journal of Modelling and Simulation
  • Year:
  • 2007

Quantified Score

Hi-index 0.01

Visualization

Abstract

The correctness of real-time database systems depends on both the data consistency and the timeliness of the results. We present a very comprehensive study which demonstrates the effect of using various priority assignment and concurrency control protocols with a variety of underlying system configurations, including use of multiple disks, CPUs, and buffer sizes. The study identifies various bottlenecks and solutions under varying system loads and transaction parameters. Both preemptive and non-preemptive protocols are studied under realistic assumptions. Finally, a performance comparison of such a system operating under deadlock and no-deadlock conditions provides insight into the potential waste of resources when concurrency is restricted.