A sound and sometimes complete query evaluation algorithm for relational databases with null values

  • Authors:
  • Raymond Reiter

  • Affiliations:
  • Univ. of British Columbia, Vancouver, B.C., Canada

  • Venue:
  • Journal of the ACM (JACM)
  • Year:
  • 1986

Quantified Score

Hi-index 0.01

Visualization

Abstract

A sound and, in certain cases, complete method is described for evaluating queries in relational databases with null values where these nulls represent existing but unknown individuals. The soundness and completeness results are proved relative to a formalization of such databases as suitable theories of first-order logic. Because the algorithm conforms to the relational algebra, it may easily be incorporated into existing relational systems.