A performance model of database systems under arbitrary data access distribution

  • Authors:
  • Mukesh Singhal;Yelena Yesha

  • Affiliations:
  • Department of Computer and Information Science, The Ohio State University, Columbus, OH 43210, U.S.A.;Department of Computer and Information Science, The Ohio State University, Columbus, OH 43210, U.S.A.

  • Venue:
  • Mathematical and Computer Modelling: An International Journal
  • Year:
  • 1988

Quantified Score

Hi-index 0.98

Visualization

Abstract

In this paper, we present an analysis of transaction blocking under arbitrary data access distribution to assist the performance analysis of concurrency control algorithms and frequency of deadlocks under arbitrary data access distribution. We present an efficient algorithm for computation of probability of conflicts among transactions for databases where data access distribution is arbitrary. We extend the result to the environments of dynamic lock acquisition policy which permits the performance analysis of dynamic locking algorithms and analysis of the frequency of deadlocks in the environments of arbitrary data access distribution. We illustrate the technique by taking a numerical example and show that the assumption of uniform data access distribution can introduce significant error.