skip to main content
research-article

Logic-based Perspectives on Query Reformulationover Restricted Interfaces

Published:11 December 2018Publication History
Skip Abstract Section

Abstract

We overview recent developments on query reformulation over a restricted interface, in the presence of integrity constraints. We overview an approach to the problem via reduction to query containment with constraints, where the reduction makes use of interpolation algorithms from logic. We first present the approach in the context of reformulating one query as another query using a fixed set of tables. We then generalize to reformulation of a query as a plan over a set of access methods.

References

  1. Antoine Amarilli and Michael Benedikt. When can we answer queries using result-bounded services. In PODS, 2018. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. Vince B´ar´any, Michael Benedikt, and Pierre Bourhis. Access restrictions and integrity constraints revisited. In ICDT, 2013.Google ScholarGoogle ScholarDigital LibraryDigital Library
  3. Michael Benedikt, Egor Kostylev, Fabio Mogavero, and Efthymia Tsamoura. Reformulating queries: theory and practice. In IJCAI, 2017. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. Michael Benedikt, Julien Leblay, Balder ten Cate, and Efthymia Tsamours. Generating Proof from Plans: the interpolation-based approach to Query Reformulation. Morgan Claypool, 2016.Google ScholarGoogle ScholarCross RefCross Ref
  5. Michael Benedikt, Julien Leblay, and Efi Tsamoura. PDQ: Proof-driven query answering over web-based data. In VLDB, 2014. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. Michael Benedikt, Julien Leblay, and Efthymia Tsamoura. Querying with access patterns and integrity constraints. PVLDB, 8(6):690--701, 2015. Google ScholarGoogle ScholarDigital LibraryDigital Library
  7. Michael Benedikt, Rodrigo Lopez-Serrano, and Efthymia Tsamoura. Biological web services: Integration, optimization, and reasoning. In Advances in Bioinformatics and Artificial Intelligence: Bridging the Gap, 2016.Google ScholarGoogle Scholar
  8. Michael Benedikt, Balder ten Cate, and Efi Tsamoura. Generating low-cost plans from proofs. In PODS, 2014. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. Michael Benedikt, Balder ten Cate, and Efi Tsamoura. Generating plans from proofs. In TODS, 2016. Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. E. W. Beth. On Padoa's method in the theory of definitions. Indagationes Mathematicae, 15:330 -- 339, 1953.Google ScholarGoogle Scholar
  11. William Craig. Three uses of the Herbrand-Gentzen theorem in relating model theory and proof theory. Journal of Symbolic Logic, 22(3):269--285, 1957.Google ScholarGoogle ScholarCross RefCross Ref
  12. Alin Deutsch, Bertram Lud¨ascher, and Alan Nash. Rewriting queries using views with access patterns under integrity constraints. TCS, 371(3):200--226, 2007. Google ScholarGoogle ScholarDigital LibraryDigital Library
  13. Alin Deutsch, Alan Nash, and Jeff Remmel. The chase revisited. In PODS, 2008. Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. Alin Deutsch, Lucian Popa, and Val Tannen. Query reformulation with constraints. SIGMOD Record, 35(1):65--73, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  15. Tomasz Gogacz and Jerzy Marcinkowski. The hunt for a red spider: Conjunctive query determinacy is undecidable. In LICS, 2015. Google ScholarGoogle ScholarDigital LibraryDigital Library
  16. Ioana Ileana, Bogdan Cautis, Alin Deutsch, and Yannis Katsis. Complete yet practical search for minimal query reformulations under constraints. In SIGMOD, 2014. Google ScholarGoogle ScholarDigital LibraryDigital Library
  17. Alon Y. Levy, Alberto O. Mendelzon, Yehoshua Sagiv, and Divesh Srivastava. Answering queries using views. In PODS, 1995. Google ScholarGoogle ScholarDigital LibraryDigital Library
  18. Alon Y. Levy, Anand Rajaraman, and Joann J. Ordille. Query-answering algorithms for information agents. In AAAI, 1996. Google ScholarGoogle ScholarDigital LibraryDigital Library
  19. Chen Li. Computing complete answers to queries in the presence of limited access patterns. VLDB Journal, 12(3):211--227, 2003. Google ScholarGoogle ScholarDigital LibraryDigital Library
  20. Chen Li and Edward Chang. Answering queries with useful bindings. TODS, 26(3):313--343, 2001. Google ScholarGoogle ScholarDigital LibraryDigital Library
  21. Roger C. Lyndon. An interpolation theorem in the predicate calculus. Pacific Journal of Mathemantics, 9:129--142, 1959.Google ScholarGoogle ScholarCross RefCross Ref
  22. David Maier, Alberto O. Mendelzon, and Yehoshua Sagiv. Testing implications of data dependencies. TODS, 4(4):455--469, 1979. Google ScholarGoogle ScholarDigital LibraryDigital Library
  23. Alan Nash and Bertram Lud¨ascher. Processing first-order queries under limited access patterns. In PODS, 2004. Google ScholarGoogle ScholarDigital LibraryDigital Library
  24. Alan Nash and Bertram Lud¨ascher. Processing union of conjunctive queries with negation under limited access patterns. In EDBT, 2004.Google ScholarGoogle ScholarCross RefCross Ref
  25. Alan Nash, Luc Segoufin, and Victor Vianu. Views and queries: Determinacy and rewriting. TODS, 35(3), 2010. Google ScholarGoogle ScholarDigital LibraryDigital Library
  26. Lucian Popa. Object/Relational Query Optimization with Chase and Backchase. PhD thesis, U. Penn., 2000. Google ScholarGoogle ScholarDigital LibraryDigital Library
  27. Rachel Pottinger and Alon Y. Halevy. Minicon: A scalable algorithm for answering queries using views. VLDB Journal, 10(2--3):182--198, 2001. Google ScholarGoogle ScholarDigital LibraryDigital Library
  28. Benjamin Rossman. Homomorphism preservation theorems. J. ACM, 55(3), 2008. Google ScholarGoogle ScholarDigital LibraryDigital Library
  29. Luc Segoufin and Victor Vianu. Views and queries: determinacy and rewriting. In PODS, 2005. Google ScholarGoogle ScholarDigital LibraryDigital Library
  30. David Toman and Grant Weddell. Fundamentals of Physical Design and Query Compilation. Morgan Claypool, 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library
  31. Jeffrey D. Ullman. Principles of Database and Knowledge-Base Systems, V2. Comp. Sci. Press, 1989. Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Logic-based Perspectives on Query Reformulationover Restricted Interfaces
            Index terms have been assigned to the content through auto-classification.

            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

            • Article Metrics

              • Downloads (Last 12 months)4
              • Downloads (Last 6 weeks)1

              Other Metrics

            PDF Format

            View or Download as a PDF file.

            PDF

            eReader

            View online with eReader.

            eReader