Skip to main content
Log in

Query answering via cooperative data inference

  • Published:
Journal of Intelligent Information Systems Aims and scope Submit manuscript

Abstract

This paper proposes the use of accessible information (data/knowledge) to infer inaccessible data in a distributed database system. Inference rules are extracted from databases by means of knowledge discovery techniques. These rules can derive inaccessible data due to a site failure or network partition in a distributed system. Such query answering requires combining incomplete and partial information from multiple sources. The derived answer may be exact or approximate. Our inference process involves two phases to reason with reconstructed information. One phase involves using local rules to infer inaccessible data. A second phase involves merging information from different sites. We shall call such reasoning processes cooperative data inference. Since the derived answer may be incomplete, new algebraic tools are developed for supporting operations on incomplete information. A weak criterion called toleration is introduced for evaluating the inferred results. The conditions that assure the correctness of combining partial results, known as sound inference paths, are developed. A solution is presented for terminating an iterative reasoning process on derived data from multiple knowledge sources. The proposed approach has been implemented on a cooperative distributed database testbed, CoBase, at UCLA. The experimental results validate the feasibility of this proposed concept and can significantly improve the availability of distributed knowledge base/database systems.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Similar content being viewed by others

Abbreviations

→:

Mapping

--<:

Logical implication

=:

Symbolic equality

==<:

Inference path

⊨:

Satisfaction

⊢:

Toleration

φ:

Undefined (does not exist)

δ:

Variable-null (may or may not exist)

* :

Subtuple relationship

* :

s-membership

\( \subseteq ^ *\) :

s-containment

:

Open subtuple

:

Open s-membership

\( \subseteq \wedge\) :

Open s-containment

φP :

Open base

P:

Program

I:

Interpretation

DIP:

Data inference program

t :

Tuples

R:

Relations

Ø:

Empty interpretation

:

Open s-union

:

Open s-interpretation

Ω:

Set of mapping from the set of objects to the set of closed objects

W:

Set of attributes

ΠW :

Set of sound inference paths on the set of attributes W

Δ:

Set of relational schemas in a DB that satisfy MVD

Δ+ :

Range closure of W wrt Δ

References

  • Aho, A.V. Beeri, C., and Ullman, J. (1979). The Theory of Joins in Relational Databases.ACM Trans. Database Systems, 4–3.

  • Biskup, J. (1981). A Formal Approach to Null Values in Database Relations. InAdvances in Database Theory Vol. 1. New York: Plenum.

    Google Scholar 

  • Bancilhon, F. and Ramakrishnan, R. (1986). An Amateur's Introduction to Recursive Query Processing Strategies.ACM SIGMOD'86.

  • Chen, Q., and Gardarin, G. (1988). An Implementation Model for Reasoning with Complex Objects.S1GMOD Rec., 17-3.

  • Chen, Q., and Chu, W.W. (1990). HILOG: A High Order Logic Programming Language for NON1NF Deductive Databases. In W. Kim, J. Nicolas, and S. Nishio (Eds.),Deductive and Object-Oriented Databases. Amsterdam: North-Holland.

    Google Scholar 

  • Chu, W.W., Hwang, A., Lee, R., Chen, Q., Merzbacher, M., and Hecht, H. (1990). Fault Tolerant Distributed Database via Data Inference. InProc. 9th Symp. Reliable Distributed System, Huntsville, AL.

  • Chu, W.W., Lee, R., and Chen, Q. (1991). Using Type Inference and Induced Rules to Provide Intensional Query Answering. InProc. 7th Int. Conf. Data Engineering, Japan.

  • Chu, W.W., and Chen, Q. (1992). Neighborhood and Associative Query Answering.J. Intell. Inform. Systems, 1, 355–382.

    Google Scholar 

  • Codd, E. F. (1986). Missing Information (Applicable and Inapplicable) in Relational Databases.SIGMOD Rec., 15–4.

  • Date, C.J. (1983). The Outer Join. InProc. 2nd Int. Conf., Databases, UK.

  • Gallaire, H., Minker, J., and Nicolas, J. (1984). Logic and Databases: A Deductive Approach.ACM Comput. Surveys, 16-2.

  • Garcia-Molina, H., and Abbott, R.K. (1987). Reliable Distributed Database Management. InProc. IEEE, 15–5, 601–620.

    Google Scholar 

  • Gottlob, G., and Zicari, R. (1988). Closed World Databases Opened through Null Values. InProc. 14th VLDB Conf. pp. 50–61.

  • Grant, J., and Minker, J. (1986). Answering Queries in Indefinite Databases and the Null Value Problem. In P. Kanellakis (Ed.),Advances in Computing Research, Vol. 3. London: JAI Press.

    Google Scholar 

  • Imielinski, T., and Lipski, W. (1984). Incomplete Information in Relational Databases.JACM, 31–4 761–791.

    Google Scholar 

  • Lipski, W. (1979). On Semantic Issues Connected with Incomplete Information Database,ACM Trans. Database Systems, 4–3, 262–296.

    Google Scholar 

  • Liu, Y. (1990). Null values in Definite Programs. InProc. 1990 North American Conf. Logic Programming, pp. 273–288.

  • Lloyd, J. (1983).Foundation of Logic Programming. Springer-Verlag, 1983.

  • Merzbacher, M., and Chu, W.W. (1993) Pattern-Based Clustering for Database Attribute Values. InProc. AAAI Workshop Knowledge Discovery in Databases, Washington, DC.

  • Ola, A., and Ozsoyoglu, G. (1989). A Family of Incomplete Relational Database Models. InProc. 15th VLDB, pp. 23–31.

  • Pirotte, A., and Zimanyi, E. (1993). Imperfect Knowledge in Databases. In P. Smets and A. Motro (Eds.),Proc. Workshop Uncertainty Management in Information Systems: From Needs to Solutions, Santa Catalina, CA.

  • Reiter, R. (1978).On Closed World Databases Logic and Databases. New York: Plenum.

    Google Scholar 

  • Reiter, R. (1984). Towards a Logical Reconstruction of Relational Database Theory. InOn Conceptual Modeling, Springer-Verlag, pp. 191–234.

  • Reiter, R. (1986). A Sound and Sometimes Complete Query Evaluation Algorithm for Relational Databases with Null Values.JACM, 33-2.

  • Vassiliou, Y. (1979). Null Values in Database Management: A Denotational Semantics Approach. InACM-SIGMOD 1979, pp. 162–169.

  • Winslett, M. (1990).Updating Logical Databases. New York: Cambridge University Press.

    Google Scholar 

  • Williams, M., and Kong, Q. (1988). Incomplete Information in a Deductive Database.Data Knowledge Eng., 3.

  • Zaniolo, C. (1984). Database Relations with Null Values.J. Comp. System Sci., 28–1, 142–166.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

About this article

Cite this article

Chu, W.W., Chen, Q. & Hwang, A. Query answering via cooperative data inference. J Intell Inf Syst 3, 57–87 (1994). https://doi.org/10.1007/BF01014020

Download citation

  • Issue Date:

  • DOI: https://doi.org/10.1007/BF01014020

Keywords

Navigation