The distribution of granule accesses made by database transactions

  • Authors:
  • Annie W. Shum;Andrew M. Langer

  • Affiliations:
  • Harvard Univ., Cambridge, MA;Harvard Univ., Cambridge, MA

  • Venue:
  • Communications of the ACM
  • Year:
  • 1982

Quantified Score

Hi-index 48.22

Visualization

Abstract

The problem of characterizing the number of granules (or blocks) accessed by a transaction is important in modeling the performance of database management systems and other applications. Different expressions for this quantity have appeared in the literature under different probabilistic assumptions. These expressions along with one new result are presented with a uniform notation and a clear statement of the assumptions underlying each. The partial order relating the predictions of the expected number of granules accessed is presented.