Design considerations for data-flow database machines

  • Authors:
  • Haran Boral;David J. DeWitt

  • Affiliations:
  • University of Wisconsin;University of Wisconsin

  • Venue:
  • SIGMOD '80 Proceedings of the 1980 ACM SIGMOD international conference on Management of data
  • Year:
  • 1980

Quantified Score

Hi-index 0.00

Visualization

Abstract

This paper presents a discussion of the application of data-flow machine concepts to the design and implementation of database machines which execute relational algebra queries. We analyze the performance of multiprocessor nested-loops and sort-merge join algorithms and show that the nested-loops algorithm is generally superior. Three levels of operand granularity for data-flow database machines are introduced and compared using the nested-loops join algorithm. We demonstrate, that relation-level granularity is too coarse and that tuple-level granularity is too fine. The third level of granularity, a page of a relation, is shown to be the best choice from both hardware and software viewpoints. Finally, a preliminary design for a data-flow database machine which utilizes page-level granularity and supports distributed control of instruction execution is presented.