Query containment for data integration systems

Journal of Computer and System Sciences

Volumn 66, Issue 1, 2003, Pages 20-39

  Millstein, Todd ^a   Halevy, Alon ^a   Friedman, Marc ^a,b  

^a University of Washington   (United States)

^b Viathan Corporation   (United States)

Author keywords

Binding patterns; Data integration; Datalog; Query containment; Query rewriting; Views

Indexed keywords

DATA REDUCTION; DATABASE SYSTEMS; PROBLEM SOLVING; WORLD WIDE WEB;

QUERY CONTAINMENT;

QUERY LANGUAGES;

EID: 0038266970     PISSN: 00220000     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0022-0000(02)00028-4     Document Type: Article

References (45)

1. S. Abiteboul, O. Duschka, Complexity of answering queries using materialized views, in: Proceedings of PODS. Seattle, WA, 1998, pp. 254-263.
2. S. Abiteboul, R. Hull, V. Vianu, Foundations of Databases, Addison-Wesley. Reading, MA, 1995.
3. S. Adali, K. Candan, Y. Papakonstantinou, V. Subrahmanian, Query caching and optimization in distributed mediator systems, in: Proceedings of SIGMOD. Montreal, Canada, 1996. pp. 137-148.
4. A. Aho, Y. Sagiv, J.D. Ullman. Equivalence of relational expressions. SIAM J. Comput. 2 (8) (1979) 218-246.
5. J.L, Ambite, N. Ashish, G. Barish, C.A. Knoblock, S. Minton, P.J. Modi, I. Muslea, A. Philpot, S. Tejada, ARIADNE: A system for constructing mediators for internet sources (system demonstration), in: Proceedings of SIGMOD, Seattle, WA, 1998.
6. C. Beeri, G. Elber, T. Milo, Y. Sagiv, O.Shmueli, N. Tishby, Y. Kogan, D. Konopnicki, P. Mogilevski, N. Slonim, Websuitem - a tool suite for harnessing web data, in: Proceedings of the International Workshop on the Web and Databases, Valencia, Spain. 1998.
7. C. Beeri, A.Y. Levy, M.-C. Rousset, Rewriting queries using views in description logics, in: Proceedings of PODS, Tucson. AZ, 1997, pp. 99-108.
8. D. Calvanese, G.D. Giacomo, M. Lenzerini, Answering queries using views in description logics, in: Working Notes of the KRDB Workshop, Linköping, Sweden, 1999.
9. T. Catarci, M. Lenzerini, Representing and using interschema knowledge in cooperative information systems, J. Intell. Cooperative Inform. Systems 2 (4) (1993) 375-398.
10. A. Chandra, P. Merlin, Optimal implementation of conjunctive queries in relational databases, in: Proceedings of the Ninth Annual ACM Symposium on Theory of Computing, Boulder, Colorado. 1977, pp. 77-90.
11. S. Chaudhuri, R. Krishnamurthy, S. Potamianos, K. Shim, Optimizing queries with materialized views, in: Proceedings of ICDE, Taipei, Taiwan, 1995, pp. 190-200.
12. S. Chaudhuri, M. Vardi, On the equivalence of recursive and nonrecursive datalog programs, in: Proceedings of PODS, San Diego, CA, 1992, pp. 55-66.
13. C. Chen, N. Roussopoulos, Implementation and performance evaluation of the ADMS query optimizer, in: Proceedings of EDBT, Cambridge, UK, March 1994, pp. 323-336.
14. W. Cohen, Integration of heterogeneous databases without common domains using queries based on textual similarity, in: Proceedings of SIGMOD, Seattle, WA, 1998.
15. S. Dar, M.J. Franklin, B. Jonsson, D. Srivastava, M. Tan, Semantic data caching and replacement, in: Proceedings of VLDB. Bombay, India, 1996, pp. 330-341.
16. D. Draper, A.Y. Halevy, D.S. Weld. The nimble xml data integration system, in: Proceedings of ICDE, Heidelberg, Germany, 2001, pp. 155-160.
17. O. Duschka, M. Genesereth, A. Levy, Recursive query plans for data integration, J. Logic Programming (Special Issue on Logic Based Heterogeneous Information Systems) 43(1) (2000) 49-73.
18. O.M. Duschka, M.R. Genesereth, Answering recursive queries using views, in: Proceedings of PODS, Tucson, AZ, 1997, pp. 109-116.
19. O.M. Duschka, M.R. Genesereth, Query planning in infomaster. in: Proceedings of the ACM Symposium on Applied Computing, San Jose, CA, 1997, pp. 109-111.
20. D. Florescu, L. Raschid, P. Valduriez, A methodology for query reformulation in cis using semantic knowledge, Internat. J. Intell. Cooperative Inform. Systems (Special issue on Formal Methods in Cooperative Information Systems) 5 (4) (1996) 431-468.
21. M. Friedman, A. Levy, T. Millstein, Navigational plans for data integration, in: Proceedings of the National Conference on Artificial Intelligence, 1999.
22. M. Friedman, D. Weld, Efficient execution of information gathering plans. in: Proceedings of the International Joint Conference on Artificial Intelligence, Nagoya, Japan, 1997, pp. 785-791.
23. M.T. Friedman, Optimization Issues in Data Integration, Ph.D. Thesis, University of Washington, 1999.
24. H. Garcia-Molina, Y. Papakonstantinou, D. Quass, A. Rajaraman, Y. Sagiv, J. Ullman, J. Widom, The TSIMMIS project: integration of heterogeneous information sources, J. Intell. Inform. Systems 8 (2) (1997) 117-132.
25. G. Grahne, A.O. Mendelzon, Tableau techniques for querying information sources through global schemas, in: Proceedings of ICDT, Jerusalem, Israel, 1999, pp. 332-347.
26. A. Gupta, Y. Sagiv, J.D. Ullman, J. Widom, Constraint checking with partial information, in: Proceedings of PODS, Minneapolis, MN, 1994, 45-55.
27. L. Haas, D. Kossmann, E. Wimmers, J. Yang, Optimizing queries across diverse data sources, in: Proceedings of VLDB, Athens, Greece, 1997.
28. Z. Ives, D. Florescu, M. Friedman, A. Levy, D. Weld, An adaptive query execution engine for data integration, in: Proceedings of SIGMOD, 1999, pp. 299-310.
29. A.M. Keller, J. Basu. A predicate-based caching scheme for client-server database architectures, VLDB J. 5 (1) (1996) 35-47.
30. A. Klug, On conjunctive queries containing inequalities, J. ACM 35 (1) (1988) 146-160.
31. C.T. Kwok, D.S. Weld, Planning to gather information, in: Proceedings of the AAAI Thirteenth National Conference on Artificial Intelligence, Portland. Oregon, 1996. pp. 32-39.
32. E. Lambrecht, S. Kambhampati, S. Gnanapnikasam, Optimizing recursive information gathering plans, in: Proceedings of the 16th International Joint Conference on Artificial Intelligence, Stockholm, Sweden. 1999. pp. 1204-1211.
33. A.Y. Levy, A.O. Mendelzon, Y. Sagiv, D. Srivastava. Answering queries using views, in: Proceedings of PODS. San Jose. CA. 1995, pp. 95-104.
34. A.Y. Levy, A. Rajaraman, J.J. Ordille, Querying heterogeneous information sources using source descriptions, in: Proceedings of VLDB. Bombay, India. 1996, pp. 251-262.
35. A.Y. Levy, Y. Sagiv, Queries independent of updates, in: Proceedings of VLDB. Dublin. Ireland. 1993, pp. 171-181.
36. C. Li, K. Chang, On answering queries in the presence of limited access patterns, in: Proceedings of ICDT. London, UK. 2001. pp. 219-233.
37. T. Millstein, A. Levy, M. Friedman, Query containment for data integration systems, in: Proceedings of PODS. Dallas, TX. 2000. pp. 67-75.
38. R. Pottinger, A. Levy, A scalable algorithm for answering queries using views, in: Proceedings of VLDB. Cairo. Egypt. 2000, pp. 484-495.
39. A. Rajaraman, Y. Sagiv, J.D. Ullman, Answering queries using templates with binding patterns, in: Proceedings of PODS, San Jose, CA. 1995, pp. 105-112.
40. Y. Sagiv, M. Yannakakis, Equivalence among relational expressions with the union and difference operators, J. ACM 27 (4) (1980) 633-655.
41. O. Shmueli, Equivalence of datalog queries is undecidable. J. Logic Programming 15 (1993) 231-241.
42. L. Stockmeyer, The polynomial-time hierarchy, Theoret. Comput. Sci. 3 (1976) 1-22.
43. O.G. Tsatalos, M.H. Solomon, Y.E. Ioannidis, The GMAP: a versatile tool for physical data independence. VLDB J. 5 (2) (1996) 101-118.
44. R. van der Meyden, The complexity of querying indefinite data about linearly ordered domains, in: Proceedings of PODS, San Diego, CA, 1992, pp. 331 -345.
45. H.Z. Yang, P.A. Larson, Query transformation for PSJ-queries, in: Proceedings of VLDB, Brighton, England, 1987, pp. 245-254.