Skip to main content

A Top-Down Approach to Rewriting Conjunctive Queries Using Views

  • Conference paper
  • 276 Accesses

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 4925))

Abstract

The problem of answering queries using views is concerned with finding answers to a query using only answers to views. In data integration context with the Local-As-Views approach, this problem translates to finding maximally contained rewriting for a given query. Existing solutions follow a bottom-up approach and, for efficiency reason, often require a post-processing phase, which comes at an additional cost.

We propose a solution which follows a top-down approach. For this, we first present a graph-based model for conjunctive queries and views, and identify conditions that if satisfied ensures maximality of a rewriting. Using this model as a basis, we then introduce a novel top-down algorithm, TreeWise, which efficiently generates maximally contained rewritings which are in general less expensive to evaluate, compared to the bottom-up algorithms, without requiring post-processing. The preliminary results of our experiments indicate that while TreeWise has comparable performance, it generally produces better quality rewritings.

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

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Abiteboul, S., Duschka, O.: Complexity of answering queries using materialized views. In: Proc. of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS), Seattle, WA (1998)

    Google Scholar 

  2. Afrati, F., Li, C., Prasenjit, M.: Answering queries using views with arithmetic comparisons. In: Proceedings of the 21st ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, pp. 209–220. ACM Press, New York (2002)

    Google Scholar 

  3. Chandra, A.K., Merlin, P.M.: Optimal implementation of conjunctive queries in relational databases. In: Proceedings of the Ninth Annual ACM Symposium on Theory of Computing, pp. 77–90 (1977)

    Google Scholar 

  4. Chaudhuri, S., Krishnamurthy, R., Potamianos, S., Shim, K.: Optimizing queries with materialized views. In: Proc. IEEE Int. Conf. on Data Eng., pp. 190–200 (1995)

    Google Scholar 

  5. Duschka, O.M.: Query planning and optimization in information integration. PhD thesis, Stanford University, Stanford, CA (1997)

    Google Scholar 

  6. Klug, A.: On conjunctive queries containing inequalities. Journal of the ACM 35(1), 146–160 (1988)

    Article  MathSciNet  MATH  Google Scholar 

  7. Lenzerini, M.: Data integration: a theoretical perspective. In: PODS 2002: Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, New York, NY, USA, pp. 233–246 (2002)

    Google Scholar 

  8. Levy, A.Y.: Answering queries using views: A survey. The VLDB Journal 10(4), 270–294 (2001)

    Article  MATH  Google Scholar 

  9. Levy, A.Y., Mendelzon, A.O., Sagiv, Y., Srivastava, D.: Answering queries using views. In: Proc. of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS), San Jose, CA (1995)

    Google Scholar 

  10. Levene, M., Poulovassilis, A.: The hypernode model and its associated query language. In: JCIT: Proceedings of the fifth Jerusalem conference on Information technology, pp. 520–530. IEEE Computer Society Press, Los Alamitos (1990)

    Google Scholar 

  11. Levy, A.Y., Rajaraman, A., Ordille, J.J.: Query answering algorithms for information agents. In: Proceedings of AAAI (1996)

    Google Scholar 

  12. Levy, A.Y., Rajaraman, A., Ordille, J.J.: Querying heterogeneous information sources using source descriptions. In: Proc. Int’l Conf. on Very Large Data Bases (VLDB), Bombay, India (1996)

    Google Scholar 

  13. Pottinger, R., Levy, A.Y.: A scalable algorithm for answering queries using views. The VLDB Journal, 484–495 (2000)

    Google Scholar 

  14. Qian, X.: Query folding. In: Proc. IEEE Int’l Conf. on Data Eng. New Orleans, LA (February 1996)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2008 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Mohajerin, N., Shiri, N. (2008). A Top-Down Approach to Rewriting Conjunctive Queries Using Views. In: Schewe, KD., Thalheim, B. (eds) Semantics in Data and Knowledge Bases. SDKB 2008. Lecture Notes in Computer Science, vol 4925. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-88594-8_10

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-88594-8_10

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-88593-1

  • Online ISBN: 978-3-540-88594-8

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics