On the effect of join operations on relation sizes

  • Authors:
  • Danièle Grady;Claude Puech

  • Affiliations:
  • Univ. de Paris-Sud, Orsay, France;Ecole Normale Supe´rieure, Paris, France

  • Venue:
  • ACM Transactions on Database Systems (TODS)
  • Year:
  • 1989

Quantified Score

Hi-index 0.00

Visualization

Abstract

We propose a generating function approach to the problem of evaluating the sizes of derived relations in a relational database framework. We present a model of relations and show how to use it to deduce probabilistic estimations of derived relation sizes. These are found to asymptotically follow normal distributions under a variety of assumptions.