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.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
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)
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)
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)
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)
Duschka, O.M.: Query planning and optimization in information integration. PhD thesis, Stanford University, Stanford, CA (1997)
Klug, A.: On conjunctive queries containing inequalities. Journal of the ACM 35(1), 146–160 (1988)
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)
Levy, A.Y.: Answering queries using views: A survey. The VLDB Journal 10(4), 270–294 (2001)
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)
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)
Levy, A.Y., Rajaraman, A., Ordille, J.J.: Query answering algorithms for information agents. In: Proceedings of AAAI (1996)
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)
Pottinger, R., Levy, A.Y.: A scalable algorithm for answering queries using views. The VLDB Journal, 484–495 (2000)
Qian, X.: Query folding. In: Proc. IEEE Int’l Conf. on Data Eng. New Orleans, LA (February 1996)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights 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)