Incomplete information and the join operation in database machines

  • Authors:
  • A. R. Hurson;L. L. Miller;S. H. Pakzad

  • Affiliations:
  • Penn State University, University Park, PA;Iowa State University, Ames, Iowa;Penn State University, University Park, PA

  • Venue:
  • ACM '87 Proceedings of the 1987 Fall Joint Computer Conference on Exploring technology: today and tomorrow
  • Year:
  • 1987

Quantified Score

Hi-index 0.00

Visualization

Abstract

The proliferation of data combined with higher performance requirements have forced designers of database systems to look beyond software solutions. Hardware approaches, namely database machines, have been introduced to overcome this problem. Most of the database machine designs have been based on the relational database model. The performance of these machines has been closely identified with the performance of the join operation.The recent discussion of null values and maybe algebra allows the user to examine potentially interesting data relationships based on part on unknown (incomplete) data.The work presented here examines the performance of a join module at the presence of incomplete data in the database. Four classes of join operations namely: True join, maybe join, attribute maybe join and outer join have been considered in this study. In addition, we will show that the enhanced join module does not sacrifice the performance of the true join operation.