Consistency enforcement in databases

  • Authors:
  • Sebastian Link

  • Affiliations:
  • Information Science Research Centre, Massey University, Information Systems, Palmerston North, New Zealand

  • Venue:
  • Proceedings of the 2nd international conference on Semantics in databases
  • Year:
  • 2001

Quantified Score

Hi-index 0.00

Visualization

Abstract

Null values are ubiquitous in database applications. There is, however, no common agreement upon how to deal with null values, neither in practice nor in theory. In this paper, the null value problem is revisited with special emphasis on answers representing sure information with respect to possible world semantics. The focus is on the unknown and the no information interpretation of null values. A new semantics for the no information interpretation of nulls is proposed taking into account a problem arising in connection with the closed world assumption. Results are applied to the query language SQL.