Null Values in Definite Programs

Abstract : Null values are a special kind of incomplete information that appear in relational database applications. There are several kinds of null values. The one modeled in this paper are those that represent entitles that are known to exist but whose exact values are only known to be in a finite subset of constants in a given domain. For example, if we know that Paul is the fraternal grandfather of John, then we know that there is someone who is the father of John and a child of Paul. If we futher assume that there are only finitely many individuals, then this someone can be represented by the kind of null value mentioned here. In this paper we incorporate these null values into definite programs by using a new kind of symbols called S-constants. We present model theoretic, proof theoretic and fixpoint semantics for such programs. In the above example, given the additional knowledge that Mike is the father of Joe, these semantics allow us to answer the question are John and Joe brothers? by yes, if the (unknown) father of John is Mike. The proposed semantics reduce to the usual semantics for definite programs when there are no null values present.

[1]  Tomasz Imielinski,et al.  Incomplete Information in Relational Databases , 1984, JACM.

[2]  Laurent Siklóssy,et al.  Efficient Query Evaluation in Relational Data Bases with Missing Values , 1981, Inf. Process. Lett..

[3]  E. F. Codd,et al.  Understanding Relations (Installment #7) , 1974, FDT Bull. ACM SIGFIDET SIGMOD.

[4]  Witold Lipski,et al.  On semantic issues connected with incomplete information databases , 1979, ACM Trans. Database Syst..

[5]  Li-Yan Yuan,et al.  A sound and complete query evaluation algorithm for relational databases with null values , 1988, SIGMOD '88.

[6]  John Grant,et al.  Null Values in a Relational Data Base , 1977, Inf. Process. Lett..

[7]  Joachim Biskup,et al.  A Formal Approach to Null Values in Database Relations , 1979, Advances in Data Base Theory.

[8]  Raymond Reiter,et al.  A sound and sometimes complete query evaluation algorithm for relational databases with null values , 1986, JACM.

[9]  Jack Minker Foundations of deductive databases and logic programming , 1988 .

[10]  Moshe Y. Vardi Querying logical databases , 1985, J. Comput. Syst. Sci..

[11]  John Grant,et al.  Answering Queries in Indefinite Databases and the Null Value Problem , 1986, Adv. Comput. Res..

[12]  Joachim Biskup,et al.  A foundation of CODD's relational maybe-operations , 1983, TODS.

[13]  E. F. Codd,et al.  Extending the database relational model to capture more meaning , 1979, ACM Trans. Database Syst..

[14]  Richard C. T. Lee,et al.  Symbolic logic and mechanical theorem proving , 1973, Computer science classics.

[15]  J. Lloyd Foundations of Logic Programming , 1984, Symbolic Computation.