skip to main content
research-article

Conjunctive query containment and answering under description logic constraints

Published:12 June 2008Publication History
Skip Abstract Section

Abstract

Query containment and query answering are two important computational tasks in databases. While query answering amounts to computing the result of a query over a database, query containment is the problem of checking whether, for every database, the result of one query is a subset of the result of another query.

In this article, we deal with unions of conjunctive queries, and we address query containment and query answering under description logic constraints. Every such constraint is essentially an inclusion dependency between concepts and relations, and their expressive power is due to the possibility of using complex expressions in the specification of the dependencies, for example, intersection and difference of relations, special forms of quantification, regular expressions over binary relations. These types of constraints capture a great variety of data models, including the relational, the entity-relationship, and the object-oriented model, all extended with various forms of constraints. They also capture the basic features of the ontology languages used in the context of the Semantic Web.

We present the following results on both query containment and query answering. We provide a method for query containment under description logic constraints, thus showing that the problem is decidable, and analyze its computational complexity. We prove that query containment is undecidable in the case where we allow inequalities in the right-hand-side query, even for very simple constraints and queries. We show that query answering under description logic constraints can be reduced to query containment, and illustrate how such a reduction provides upper-bound results with respect to both combined and data complexity.

References

  1. Abiteboul, S. and Duschka, O. 1998. Complexity of answering queries using materialized views. In Proceedings of the 17th ACM SIGACT SIGMOD SIGART Symposium on Principles of Database Systems (PODS'98). 254--265. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. Abiteboul, S., Hull, R., and Vianu, V. 1995. Foundations of Databases. Addison-Wesley, Reading, MA. Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. Aho, A. V., Sagiv, Y., and Ullman, J. D. 1979a. Efficient optimization of a class of relational expressions. ACM Trans. Database Syst. 4, 297--314. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. Aho, A. V., Sagiv, Y., and Ullman, J. D. 1979b. Equivalence among relational expressions. SIAM J. Comput. 8, 218--246.Google ScholarGoogle ScholarCross RefCross Ref
  5. Amir, K., Park, S., Tewari, R., and Padmanabhan, S. 2003. Scalable template-based query containment checking for Web semantic caches. In Proceedings of the 19th IEEE International Conference on Data Engineering (ICDE 2003). 493--504.Google ScholarGoogle Scholar
  6. Baader, F., Calvanese, D., McGuinness, D., Nardi, D., and Patel-Schneider, P. F., Eds. 2003. The Description Logic Handbook: Theory, Implementation and Applications. Cambridge University Press, Cambridge, U.K. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. Berger, R. 1966. The undecidability of the dominoe problem. Mem. Amer. Math. Soc. 66, 1--72.Google ScholarGoogle Scholar
  8. Blackburn, P., de Rijke, M., and Venema, Y. 2001. Modal Logic. Cambridge Tracts in Theoretical Computer Science, vol. 53. Cambridge University Press, Cambridge, U.K. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. Bonatti, P. A. 2004. On the decidability of containment of recursive datalog queries—preliminary report. In Proceedings of the 23rd ACM SIGACT SIGMOD SIGART Symposium on Principles of Database Systems (PODS 2004). 297--306. Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. Borgida, A. and Brachman, R. J. 2003. Conceptual modeling with description logics. See [Baader et al. 2003], Chapter 10, 349--372. Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. Calvanese, D. and De Giacomo, G. 2003. Expressive description logics. See [Baader et al. 2003], Chapter 5, 178--218. Google ScholarGoogle ScholarDigital LibraryDigital Library
  12. Calvanese, D., De Giacomo, G., and Lenzerini, M. 1995. Structured objects: Modeling and reasoning. In Proceedings of the 4th International Conference on Deductive and Object-Oriented Databases (DOOD'95). Lecture Notes in Computer Science, vol. 1013. Springer, Berlin, Germany, 229--246. Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. Calvanese, D., De Giacomo, G., and Lenzerini, M. 1998a. On the decidability of query containment under constraints. In Proceedings of the 17th ACM SIGACT SIGMOD SIGART Symposium on Principles of Database Systems (PODS'98). 149--158. Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. Calvanese, D., De Giacomo, G., and Lenzerini, M. 2001a. Identification constraints and functional dependencies in description logics. In Proceedings of the 17th International Joint Conference on Artificial Intelligence (IJCAI 2001). 155--160. Google ScholarGoogle ScholarDigital LibraryDigital Library
  15. Calvanese, D., De Giacomo, G., Lenzerini, M., and Nardi, D. 2001b. Reasoning in expressive description logics. In Handbook of Automated Reasoning, A. Robinson and A. Voronkov, Eds. Vol. II. Elsevier Science Publishers, Amsterdam, The Netherlands, Chapter 23, 1581--1634. Google ScholarGoogle ScholarDigital LibraryDigital Library
  16. Calvanese, D., De Giacomo, G., Lenzerini, M., Nardi, D., and Rosati, R. 1998b. Description logic framework for information integration. In Proceedings of the 6th International Conference on the Principles of Knowledge Representation and Reasoning (KR'98). 2--13.Google ScholarGoogle Scholar
  17. Calvanese, D., De Giacomo, G., Lenzerini, M., and Vardi, M. Y. 2000. Containment of conjunctive regular path queries with inverse. In Proceedings of the 7th International Conference on the Principles of Knowledge Representation and Reasoning (KR 2000). 176--185.Google ScholarGoogle Scholar
  18. Calvanese, D., De Giacomo, G., Lenzerini, M., and Vardi, M. Y. 2002. View-based query answering and query containment over semistructured data. In Revised Papers of the 8th International Workshop on Database Programming Languages (DBPL 2001), G. Ghelli and G. Grahne, Eds. Lecture Notes in Computer Science, vol. 2397. Springer, Berlin, Germany, 40--61. Google ScholarGoogle ScholarDigital LibraryDigital Library
  19. Calvanese, D., De Giacomo, G., and Vardi, M. Y. 2003. Decidable containment of recursive queries. In Proceedings of the 9th International Conference on Database Theory (ICDT 2003). Lecture Notes in Computer Science, vol. 2572. Springer, Berlin, Germany, 330--345. Google ScholarGoogle ScholarDigital LibraryDigital Library
  20. Calvanese, D., Lenzerini, M., and Nardi, D. 1999. Unifying class-based representation formalisms. J. Artific. Intell. Res. 11, 199--240.Google ScholarGoogle ScholarDigital LibraryDigital Library
  21. Calvanese, D. and Rosati, R. 2003. Answering recursive queries under keys and foreign keys is undecidable. In Proceedings of the 10th International Workshop on Knowledge Representation meets Databases (KRDB 2003). CEUR Electronic Workshop Proceedings. Available online at http://ceur-ws.org/Vol-79/.Google ScholarGoogle Scholar
  22. Catarci, T. and Lenzerini, M. 1993. Representing and using interschema knowledge in cooperative information systems. J. Intell. Coop. Informat. Syst. 2, 4, 375--398.Google ScholarGoogle ScholarCross RefCross Ref
  23. Chan, E. P. F. 1992. Containment and minimization of positive conjunctive queries in OODB's. In Proceedings of the 11th ACM SIGACT SIGMOD SIGART Symposium on Principles of Database Systems (PODS'92). 202--211. Google ScholarGoogle ScholarDigital LibraryDigital Library
  24. Chandra, A. K. and Merlin, P. M. 1977. Optimal implementation of conjunctive queries in relational data bases. In Proceedings of the 9th ACM Symposium on Theory of Computing (STOC'77). 77--90. Google ScholarGoogle ScholarDigital LibraryDigital Library
  25. Chandra, A. K. and Vardi, M. Y. 1985. The implication problem for functional and inclusion dependencies is undecidable. SIAM J. Comput. 14, 3, 671--677.Google ScholarGoogle ScholarDigital LibraryDigital Library
  26. Chaudhuri, S. and Vardi, M. Y. 1992. On the equivalence of recursive and nonrecursive Datalog programs. In Proceedings of the 11th ACM SIGACT SIGMOD SIGART Symposium on Principles of Database Systems (PODS'92). 55--66. Google ScholarGoogle ScholarDigital LibraryDigital Library
  27. Chekuri, C. and Rajaraman, A. 1997. Conjunctive query containment revisited. In Proceedings of the 6th International Conference on Database Theory (ICDT'97). 56--70. Google ScholarGoogle ScholarDigital LibraryDigital Library
  28. De Giacomo, G. and Lenzerini, M. 1994. Boosting the correspondence between description logics and propositional dynamic logics. In Proceedings of the 12th National Conference on Artificial Intelligence (AAAI'94). 205--212. Google ScholarGoogle ScholarDigital LibraryDigital Library
  29. De Giacomo, G. and Lenzerini, M. 1995. What's in an aggregate: Foundations for description logics with tuples and sets. In Proceedings of the 14th International Joint Conference on Artificial Intelligence (IJCAI'95). 801--807. Google ScholarGoogle ScholarDigital LibraryDigital Library
  30. De Giacomo, G. and Lenzerini, M. 1996. TBox and ABox reasoning in expressive description logics. In Proceedings of the 5th International Conference on the Principles of Knowledge Representation and Reasoning (KR'96). 316--327.Google ScholarGoogle Scholar
  31. Dong, G. and Su, J. 1996. Conjunctive query containment with respect to views and constraints. Informat. Process. Lett. 57, 2, 95--102. Google ScholarGoogle ScholarDigital LibraryDigital Library
  32. Donini, F. M., Lenzerini, M., Nardi, D., and Schaerf, A. 1998. AL-log: Integrating Datalog and description logics. J. Intell. Informat. Syst. 10, 3, 227--252. Google ScholarGoogle ScholarDigital LibraryDigital Library
  33. Enderton, H. B. 1972. A Mathematical Introduction to Logic. Academic Press, New York, NY.Google ScholarGoogle Scholar
  34. Fattorosi-Barnaba, M. and De Caro, F. 1985. Graded modalities I. Studia Logica 44, 197--221.Google ScholarGoogle ScholarCross RefCross Ref
  35. Fischer, M. J. and Ladner, R. E. 1979. Propositional dynamic logic of regular programs. J. Comput. Syst. Sci. 18, 194--211.Google ScholarGoogle ScholarCross RefCross Ref
  36. Gruber, T. R. 1993. Towards principles for the design of ontologies used for knowledge sharing. In Formal Ontology in Conceptual Analysis and Knowledge Representation, N. Guarino and R. Poli, Eds. Kluwer Academic Publishers, Dordrecht, The Netherlands.Google ScholarGoogle Scholar
  37. Gupta, A. and Mumick, I. S. 1995. Maintenance of materialized views: Problems, techniques, and applications. Bull. IEEE Comput. Soc. Tech. Comm. Data Eng. 18, 2, 3--18.Google ScholarGoogle Scholar
  38. Gupta, A., Sagiv, Y., Ullman, J. D., and Widom, J. 1994. Constraint checking with partial information. In Proceedings of the 13th ACM SIGACT SIGMOD SIGART Symposium on Principles of Database Systems (PODS'94). Google ScholarGoogle ScholarDigital LibraryDigital Library
  39. Halevy, A. Y. 2001. Answering queries using views: A survey. Very Large Database J. 10, 4, 270--294. Google ScholarGoogle ScholarDigital LibraryDigital Library
  40. Harel, D. 1985. Recurring dominoes: Making the highly undecidable highly understandable. Ann. Discr. Math. 24, 51--72. Google ScholarGoogle ScholarDigital LibraryDigital Library
  41. Horrocks, I., Sattler, U., Tessaris, S., and Tobies, S. 2000. How to decide query containment under constraints using a description logic. In Proceedings of the 7th International Conference on Logic for Programming and Automated Reasoning (LPAR 2000). Lecture Notes in Computer Science, vol. 1955. Springer, Berlin, Germany, 326--343.Google ScholarGoogle ScholarCross RefCross Ref
  42. Hull, R. 1997. Managing semantic heterogeneity in databases: A theoretical perspective. In Proceedings of the 16th ACM SIGACT SIGMOD SIGART Symposium on Principles of Database Systems (PODS'97). 51--61. Google ScholarGoogle ScholarDigital LibraryDigital Library
  43. Ioannidis, Y. E. and Ramakrishnan, R. 1995. Containment of conjunctive queries: Beyond relations as sets. ACM Trans. Database Syst. 20, 3, 288--324. Google ScholarGoogle ScholarDigital LibraryDigital Library
  44. Johnson, D. S. and Klug, A. C. 1984. Testing containment of conjunctive queries under functional and inclusion dependencies. J. Comput. Syst. Sci. 28, 1, 167--189.Google ScholarGoogle ScholarCross RefCross Ref
  45. Klug, A. C. 1988. On conjunctive queries containing inequalities. J. ACM 35, 1, 146--160. Google ScholarGoogle ScholarDigital LibraryDigital Library
  46. Kozen, D. and Tiuryn, J. 1990. Logics of programs. In Handbook of Theoretical Computer Science—Formal Models and Semantics, J. van Leeuwen, Ed. Elsevier Science Publishers, Amsterdam, The Netherlands, 789--840. Google ScholarGoogle ScholarDigital LibraryDigital Library
  47. Lenzerini, M. 2002. Data integration: A theoretical perspective. In Proceedings of the 21st ACM SIGACT SIGMOD SIGART Symposium on Principles of Database Systems (PODS 2002). 233--246. Google ScholarGoogle ScholarDigital LibraryDigital Library
  48. Levy, A. Y. and Rousset, M.-C. 1996. CARIN: A representation language combining Horn rules and description logics. In Proceedings of the 12th Eurpoean Conference on Artificial Intelligence (ECAI'96). 323--327.Google ScholarGoogle Scholar
  49. Levy, A. Y., Srivastava, D., and Kirk, T. 1995. Data model and query evaluation in global information systems. J. Intell. Informat. Syst. 5, 121--143. Google ScholarGoogle ScholarDigital LibraryDigital Library
  50. Levy, A. Y. and Suciu, D. 1997. Deciding containment for queries with complex objects. In Proceedings of the 16th ACM SIGACT SIGMOD SIGART Symposium on Principles of Database Systems (PODS'97). 20--31. Google ScholarGoogle ScholarDigital LibraryDigital Library
  51. Mitchell, J. C. 1983. The implication problem for functional and inclusion dependencies. Informat. Contr. 56, 154--173. Google ScholarGoogle ScholarDigital LibraryDigital Library
  52. Neven, F. and Schwentick, T. 2003. XPath containment in the presence of disjunction, DTDs, and variables. In Proceedings of the 9th International Conference on Database Theory (ICDT 2003). 315--329. Google ScholarGoogle ScholarDigital LibraryDigital Library
  53. Patel-Schneider, P., Hayes, P., and Horrocks, I. 2004. OWL Web Ontology Language semantics and abstract syntax. W3C Recommendation. Available online at http://www.w3.org/TR/owl-semantics/.Google ScholarGoogle Scholar
  54. Sagiv, Y. and Yannakakis, M. 1980. Equivalences among relational expressions with the union and difference operators. J. ACM 27, 4, 633--655. Google ScholarGoogle ScholarDigital LibraryDigital Library
  55. Schild, K. 1991. A correspondence theory for terminological logics: Preliminary report. In Proceedings of the 12th International Joint Conference on Artificial Intelligence (IJCAI'91). 466--471.Google ScholarGoogle ScholarDigital LibraryDigital Library
  56. Ullman, J. D. 1997. Information integration using logical views. In Proceedings of the 6th International Conference on Database Theory (ICDT'97). Lecture Notes in Computer Science, vol. 1186. Springer, Berlin, Germany, 19--40. Google ScholarGoogle ScholarDigital LibraryDigital Library
  57. van der Meyden, R. 1998. Logical approaches to incomplete information. In Logics for Databases and Information Systems, J. Chomicki and G. Saake, Eds. Kluwer Academic Publishers, Dordrecht, The Netherlands, 307--356. Google ScholarGoogle ScholarDigital LibraryDigital Library
  58. van Emde Boas, P. 1997. The convenience of tilings. In Complexity, Logic, and Recursion Theory, A. Sorbi, Ed. Lecture Notes in Pure and Applied Mathematics, vol. 187. Marcel Dekker Inc., New York, NY, 331--363.Google ScholarGoogle Scholar
  59. Widom, J. Ed. 1995. Special issue on materialized views and data warehousing. Bull. IEEE Comput. Soc. Tech. Comm. Data Eng. 18, 2.Google ScholarGoogle Scholar
  60. Wood, P. T. 2003. Containment for XPath fragments under DTD constraints. In Proceedings of the 9th International Conference on Database Theory (ICDT 2003). 300--314. Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Conjunctive query containment and answering under description logic constraints

        Recommendations

        Comments

        Login options

        Check if you have access through your login credentials or your institution to get full access on this article.

        Sign in

        Full Access

        • Published in

          cover image ACM Transactions on Computational Logic
          ACM Transactions on Computational Logic  Volume 9, Issue 3
          June 2008
          289 pages
          ISSN:1529-3785
          EISSN:1557-945X
          DOI:10.1145/1352582
          Issue’s Table of Contents

          Copyright © 2008 ACM

          Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

          Publisher

          Association for Computing Machinery

          New York, NY, United States

          Publication History

          • Published: 12 June 2008
          • Accepted: 1 December 2006
          • Revised: 1 April 2006
          • Received: 1 July 2005
          Published in tocl Volume 9, Issue 3

          Permissions

          Request permissions about this article.

          Request Permissions

          Check for updates

          Qualifiers

          • research-article
          • Research
          • Refereed

        PDF Format

        View or Download as a PDF file.

        PDF

        eReader

        View online with eReader.

        eReader