Answering queries using views: A survey

VLDB Journal

Volumn 10, Issue 4, 2001, Pages 270-294

  Halevy, A Y ^a  

^a University of Washington   (United States)

Author keywords

Data integration; Date warehousing; Materialized views; Query optimization; Survey; Web site management

Indexed keywords

EID: 0035658039     PISSN: 10668888     EISSN: None     Source Type: Journal    
DOI: 10.1007/s007780100054     Document Type: Review

References (122)

1. Abiteboul S. Querying semi-structured data. In: Proc. of ICDT. pp 1-18, Delphi, Greece, 1997
2. Abiteboul S., Buneman P., Suciu D. Data on the Web. Morgan Kaufmann, San Francisco, 1999
3. Agrawal S., Chaudhuri S., Narasayya V. Automated selection of materialized views and indexes in Microsoft SQL Server. In: Proc. of VLDB. pp 496-505, Cairo, Egypt, 2000
4. Adali S., Candan K., Papakonstantinou Y., Subrahmanian V.S. Query caching and optimization in distributed mediator systems. In: Proc. of SIGMOD. pp 137-148, Montreal, Canada, 1996
5. Abiteboul S., Duschka O. Complexity of answering queries using materialized views. In: Proc. of PODS. pp 254-263, Seattle, Wash., USA, 1998
6. Afrati F. Personal communication, 2000
7. Afrati F., Gergatsoulis M., Kavalieros T. Answering queries using materialized views with disjunctions. In: Proc. of ICDT. pp 435-452, 1999
8. Abiteboul S., Hull R., Vianu V. Foundations of databases. Addison Wesley, Reading, Mass., USA, 1995
9. Arens Y., Knoblock C.A., Shen W.M. Query reformulation for dynamic information integration. Int. J. Intell. Coop. Inf. Syst. (6)2/3:99-130, 1996
10. Afrati F., Li C., Ullman J. Generating efficient plans for queries using views. In: Proc. of SIGMOD. pp 319-330, 2001
11. +97] Abiteboul S., Quass D., McHugh J., Widom J., Wiener J. The Lorel query language for semistructured data. Int. J. Digital Libr. 1(1):68-88, 1997
12. +98] Bello R., Dias K., Downing A., Feenan J., Finnerty J., Norcott W., Sun H., Witkowski A., Ziauddin M. Materialized views in Oracle. In: Proc. of VLDB. pp 659-664, 1998
13. Buneman P., Davidson S., Hillebrand G., Suciu D. A query language and optimization techniques for unstructured data. In: Proc. of SIGMOD. pp 505-516, Montreal, Canada, 1996
14. Beeri C., Levy A.Y., Roussel M.C. Rewriting queries using views in description logics. In: Proc. of PODS. pp 99-108, Tucson, Ariz., USA, 1997
15. Borgida A. Description logics in data management. IEEE Trans. Knowl. Data Eng. 7(5):671-682, 1995
16. Baralis E., Paraboschi S., Teniente E. Materialized views selection in a multidimensional database. In: Proc. of VLDB. pp 156-165, 1997
17. Buneman P. Semistructured data. In: Proc. of PODS. pp 117-121, Tucson, Ariz., USA, 1997
18. Chirkova R., Genesereth M. Linearly bounded reformulations of conjunctive databases. In: Proc. of DOOD. pp 987-1001, 2000
19. Calvanese D., De Giacomo G., Lenzerini M. Answering queries using views in description logics. In: Working notes of the KRDB Workshop. 1999
20. Calvanese D., De Giacomo G., Lenzerini M., Vardi M. Rewriting of regular expressions and regular path queries. In: Proc. of PODS. pp 194-204, 1999
21. Calvanese D., De Giacomo G., Lenzerini M., Vardi M. Answering regular path queries using views. In: Proc. of ICDE. pp 389-398, 2000
22. Calvanese D., De Giacomo G., Lenzerini M., Vardi M. View-based query processing for regular path queries with inverse. In: Proc. of PODS. pp 58-66, 2000
23. Chirkova R., Halevy A., Suciu D. A formal perspective on the view selection problem. In: Proc. of VLDB. 2001
24. Chaudhuri S., Krishnamurthy R., Potamianos S., Shim K. Optimizing queries with materialized views. In: Proc. of ICDE. pp 190-200, Taipei, Taiwan, 1995
25. Catarci T., Lenzerini M. Representing and using interschema knowledge in cooperative information systems. J. Intell. Coop. Inf. Syst.. pp 55-62, 1993
26. Chandra A.K., Merlin P.M. Optimal implementation of conjunctive queries in relational databases. In: Proc. Ninth Annual ACM Symposium on Theory of Computing. pp 77-90, 1977
27. Chaudhuri S., Narasayya V.R. Autoadmin 'what-if' index analysis utility. In: Proc. of SIGMOD. pp 367-378, 1998
28. Chaudhuri S., Narasayya V.R. Microsoft index tuning wizard forSQL Server 7.0. In: Proc. of SIGMOD. pp 553-554, 1998
29. Cohen V.R., Nutt W., Serebrenik A. Rewriting aggregate queries using views. In: Proc. of PODS. pp 155-166, 1999
30. Chen C., Roussopoulos N. Implementation and performance evaluation of the ADMS query optimizer. In: Proc. of EDBT. pp 323-336, March 1994
31. Chekuri C., Rajaraman A. Conjunctive query containment revisited. In: Proc. of ICDT. pp 56-70, Delphi, Greece, 1997
32. Chamberlin D.D., Robie J., Florescu D. Quilt: an XML query language for heterogeneous data sources. In: WebDB (Informal Proceedings) 2000. pp 53-62, 2000
33. Chaudhuri S., Vardi M. On the equivalence of recursive and nonrecursive datalog programs. In: Proc. of PODS. pp 55-66, San Diego, Calif., USA, 1992
34. Chaudhuri S., Vardi M. Optimizing real conjunctive queries. In: Proc. of PODS. pp 59-70, Washington D.C., USA, 1993
35. Chaudhuri S., Vardi M. On the complexity of equivalence between recursive and nonrecursive datalog programs. In: Proc. of PODS. pp 55-66, Minneapolis, Minn., USA, 1994
36. +99] Deutsch A., Fernandez M., Florescu D., Levy A., Suciu D. A query language for XML. In: Proc. World-Wide Web 8 Conference. pp 1155-1169, 1999
37. +96] Dar S., Franklin M.J., Jonsson B., Srivastava D., Tan M. Semantic data caching and replacement. In: Proc. of VLDB. pp 330-341, 1996
38. Deutsch A., Fernandez M., Suciu D. Storing semi-structured data with STORED. In: Proc. of SIGMOD. pp 431-442, 1999
39. Duschka O.M., Genesereth M.R. Answering recursive queries using views. In: Proc. of PODS. pp 109-116, Tucson, Ariz., USA, 1997
40. Duschka O.M., Genesereth M.R. Query planning in infomaster. In: Proc. ACM Symposium on Applied Computing. pp 109-111, San Jose, Calif., USA, 1997
41. Duschka O., Genesereth M., Levy A. Recursive query plans for data integration. In: Special issue on Logic-Based Heterogeneous Information Systems. J. Logic Program. 43(1):49-73, 2000
42. Duschka O.M. Levy A.Y. Recursive plans for information gathering. In: Proc. 15th International Joint Conference on Artificial Intelligence. pp 778-784, 1997
43. Doan A., Levy A. Efficiently ordering query plans for data integration. In: IJCAI Workshop on Intelligent Data Integration. Stockholm, Sweden, August 1999
44. Deutsch A., Popa L., Tannen V. Physical data independence, constraints and optimization with universal plans. In: Proc. of VLDB. pp 459-470, 1999
45. Duschka O. Query optimization using local completeness. In: Proc. AAAI 14th National Conference on Artificial Intelligence. pp 249-255, 1997
46. Duschka O.M. Query planning and optimization in information integration. PhD thesis, Stanford University, Stanford, Calif., USA, 1998
47. Etzioni O., Golden K., Weld D.S. Sound and efficient closed-world reasoning for planning. Artif. Intell. 89(1-2):113-148, 1997
48. Fernandez M., Florescu D., Levy A., Suciu D. A query language for a web-site management system. SIGMOD Record 26(3):4-11, 1997
49. Florescu D., Kossmann D. Storing and querying XML data using an rdbms. IEEE Data Eng. Bull. 22(3):27-34, 1999
50. Florescu D., Koller D., Levy A. Using probabilistic information in data integration. In: Proc. of VLDB. pp 216-225, Athens, Greece, 1997
51. Florescu D., Levy A., Mendelzon A. Database techniques for the world-wide web: a survey. SIGMOD Record 27(3):59-74, 1998
52. Florescu D.D. Search spaces for object-oriented query optimization. PhD thesis, Univerisity of Paris VI. France, 1996
53. Florescu D., Levy A., Suciu D., Yagoub K. Optimization of run-time management of data intensive web sites. In: Proc. of VLDB. pp 627-638, 1999
54. Florescu D., Raschid L., Valcuriez P. Answering queries using OQL view expressions. In: Workshop on Materialized Views, in cooperation with ACM SIGMOD. Montreal, Canada, 1996
55. Friedman M., Weld D. Efficient execution of information gathering plans. In: Proc. International Joint Conference on Artificial Inlelligence, Nagoya, Japan. pp 785-791, 1997
56. Gray J., Bosworth A., Layman A., Pirahesh H. Data cube: a relational aggregation operator generalizing group-by, cross-tab and sub-totals. In: Proc. of ICDE. pp 152-159, 1998
57. -01] Gribble S., Halevy A., Ives Z., Rodrig M., Suciu D. What can databases do for peer-to-peer? In: ACM SIGMOD WebDB Workshop 2001. 2001
58. Gupta A., Harinarayan V., Quass D. Aggregate-query processing in data warehousing environments. In: Proc. of VLDB. pp 358-369, 1995
59. Gupta H., Harinarayan V., Rajaraman A., Ullman J.D. Index selection for OLAP. In: Proc. of ICDE. pp 208-219, 1997
60. Goldstein J., Larson P.A. Optimizing queries using materialized views: a practical, scalable solution. In: Proc. of SIGMOD. pp 331-342, 2001
61. Grahne G., Mendelzon A.O. Tableau techniques for querying information sources through global schemas. In: Proc. of ICDT. pp 332-347, 1999
62. Gupta A., Mumick I., (eds.) Materialized views: techniques, implementations and applications. MIT, Cambridge, Mass., USA, 1999
63. Gupta H., Mumick I.S. Selection of views to materialize under a maintenance cost constraint. In: Proc. of ICDT. pp 453-470, 1999
64. +97] Garcia-Molina H., Papakonstantinou Y., Quass D., Rajaraman A., Sagiv Y., Ullman J., Widom J. The TSIM-MIS project: Integration of heterogeneous information sources. J. Intell. Inf. Syst. 8(2):117-132, 1997
65. Grumbach S., Rafanelli M., Tininini L. Querying aggregate data. In: Proc. of PODS. pp 174-184, 1999
66. Gryz J. Query folding with inclusion dependencies. In: Proc. of ICDE. pp 126-133, Orlando, Fla., USA, 1998
67. Grumbach S., Tininini L. On the content of materialzed aggregate views. In: Proc. of PODS. 2000
68. Gupta H. Selection of views to materialize in a data warehouse. In: Proc. of ICDT. pp 98-112, 1997
69. Gupta H. Selection of views to materialize in a data warehouse. In: Proc. of ICDT. pp 98-112, Delphi, Greece, 1997
70. Haas L., Freytag J., Lohman G., Pirahesh H. Extensible query processing in Starburst. In: Proc. of SIGMOD. pp 377-388, 1989
71. Harinarayan V., Rajaraman A., Ullman J.D. Implementing data cubes efficiently. In: Proc. of SIGMOD. pp 205-216, 1996
72. +99] Ives Z., Florescu D., Friedman M., Levy A., Weld D. An adaptive query execution engine for data integration. In: Proc. of SIGMOD. pp 259-310, 1999
73. Imielinski T., Lipski W. Incomplete information in relational databases. J. ACM. 31(4):761-791, 1984
74. Keller A.M., Basu J. A predicate-based caching scheme for client-server database architectures. VLDB J. 5(1):35-47, 1996
75. Klug A. On conjunctive queries containing inequalities. J. ACM. pp 35(1):146-160, 1988
76. Kolaitis P., Martin D., Thakur M. On the complexity of the containment problem for conjunctive queries with built-in predicates. In: Proc. of PODS. pp 197-204, Seattle, Wash., USA, 1998
77. Kwok C.T., Weld D.S. Planning to gather information. In: Proc. AAAI 13th National Conference on Artificial Intelligence. pp 32-39, 1996
78. Levy A.Y. Obtaining complete answers from incomplete databases. In: Proc. of VLDB. pp 402-412, Bombay, India, 1996
79. Levy A.Y. Logic-based techniques in data integration. In: Minker J (ed.) Logic-based artificial intelligence. Kluwer Academic, Dordrecht, 2000, pp 575-595
80. Levy A. Y., Fikes R.E., Sagiv S. Speeding up inferences using relevance reasoning: a formalism and algorithms. Artif. Intell. 97(1-2), 1997
81. Lambrecht E., Kambhampati S., Gnanaprakasam S. Optimizing recursive information gathering plans. In: Proc. 16th International Joint Conference on Artificial Intelligence. pp 1204-1211, 1999
82. Levy A.Y., Mendelzon A.O., Sagiv Y., Srivastava D. Answering queries using views. In: Proc. of PODS. pp 95-104, San Jose, Calif, USA, 1995
83. Levy A.Y., Rajaraman A., Ordille J.J. Query answering algorithms for information agents. In: Proc. National Conference on Artificial Intelligence. pp 40-47, 1996
84. Levy A.Y., Rajaraman A., Ordille J.J. Querying heterogeneous information sources using source descriptions. In: Proc. of VLDB. pp 251-262, Bombay, India, 1996
85. Levy A.Y., Rajaraman A., Ullman J.D. Answering queries using limited external processors. In: Proc. of PODS. pp 227-237, Montreal, Canada, 1996
86. Levy A.Y., Sagiv Y. Queries independent of updates. In: Proc. of VLDB. pp 171-181, Dublin, Ireland, 1993
87. Steinbrunn M., Moerkotte G., Kemper A. Heuristic and randomized optimization for the join. VLDB J. 6(3):191-208, 1997
88. Miller R.J. Using schematically heterogeneous structures. In: Proc. of SIGMOD. pp 189-200, Seattle, Wash., USA, 1998
89. Millstein T., Levy A., Friedman M. Query containment for data integration systems. In: Proc. of PODS. pp 67-75, Dallas, Tex., USA, 2000
90. Mendelzon A., Mihaila G. Querying partially sound and complete data sources. In: Proc. of PODS. pp 162-170, 2001
91. Maier D., Mendelzon A., Sagiv Y. Testing implications of data dependencies. ACM Trans. Database Syst. 4(4):455-469, 1979
92. Minock M., Rusinkiewicz M., Perry B. The identification of missing information resources through the query difference operator. In: Proc. 4th IFCIS International Conference on Cooperative Information Systems (CoopIS 99). September 1999
93. Naumann F., Leser U., Freytag J.C. Quality-driven integration of heterogeneous information systems. In: 25th Conference on Very Large Database Systems (VLDB). pp 447-458, 1999
94. Popa L., Deutsch A., Sahuguet A., Tannen V. A chase too far? In: Proc. of SIGMOD. pp 273-284, 2000
95. Pottinger R., Halevy A. Minicon: a scalable algorithm for answering queries using views. VLDB J. 10(2): 182-198, 2001
96. Pottinger R., Levy A. A scalable algorithm for answering queries using views. In: Proc. of VLDB. pp 484-495, Cairo, Egypt, 2000
97. Popa L., Tannen V. An equational chase for path conjunctive queries, constraints and views. In: Proc. of ICDT. 1999
98. Papakonstantinou Y., Vassalos V. Query rewriting for semi-structured data. In: Proc. of SIGMOD. pp 455-466, 1999
99. Qian X. Query folding. In: Proc. of ICDE. pp 48-55, New Orleans, La., USA, 1996
100. Rajaraman A., Sagiv Y., Ullman J.D. Answering queries using templates with binding patterns. In: Proc. of PODS. pp 105-112, San Jose, Calif., USA, 1995
101. +79] Selinger P., Astrahan M., Chamberlin D., Lorie R., Price T. Access path selection in relational database systems. In: Proc. of SIGMOD. pp 23-34, Boston, Mass., USA, 1979
102. Sagiv Y. Optimizing datalog programs. In: Minker J (ed) Foundations of deductive databases and logic programming. pp 659-698. Morgan Kaufmann, Los Altos, Calif., USA, 1988
103. Srivastava D., Dar S., Jagadish H.V., Levy A.Y. Answering SQL queries using materialized views. In: Proc. of VLDB. Bombay, India, 1996
104. +99] Shanmugasundaram J., Gang H., Tufte K., Zhang C., DeWitt D.J., Naughton J. Relational databases for querying XML documents: limitations and opportunities. In: Proc. of VLDB. pp 302-314, 1999
105. Shmueli O. Equivalence of datalog queries is undecidable. J. Logic Program. 15:231-241, 1993
106. Srivastava D., Ramakrishnan R. Pushing constraint selections. In: Proc. of PODS. pp 301-315, San Diego, Calif., USA, 1992
107. Sagiv Y., Yannakakis M. Equivalence among relational expressions with the union and difference operators. J. ACM. 27(4):633-655, 1981
108. Tatarinov I., Ives Z., Halevy A., Weld D. Updating XML. In: Proc. of SIGMOD. pp 413-424, 2001
109. Theodoratos D., Sellis T. Data warehouse configuration. In: Proc. of VLDB. pp 126-135, Athens, Greece, 1997
110. Tsatalos O.G., Solomon M.H., Ioannidis Y.E. The GMAP: a versatile tool for physical data independence. In: Proc. of VLDB. pp 367-378, Santiago, Chile, 1994
111. Tsatalos O.G., Solomon M.H., Ioannidis Y.E. The GMAP: a versatile tool for physical data independence. VLDB J. 5(2):101-118, 1996
112. Urhan T., Franklin M.J., Amsaleg L. Cost-based query scrambling for initial delays. In: Proc. of SIGMOD. pp 130-141, Seattle, Wash., USA, 1998
113. Ullman J.D. Principles of database and knowledge-base systems, vols. I, II. Computer Science, Rockville, Md., USA, 1989
114. Ullman J.D. Information integration using logical views. In: Proc. of ICDT. pp 19-40, Delphi, Greece, 1997
115. Valduriez P. Join indices. ACM Trans. Database Syst. 12(2):218-246, 1987
116. Vassalos V., Papakonstantinou Y. Describing and using query capabilities of heterogeneous sources. In: Proc. of VLDB. pp 256-265, Athens, Greece, 1997
117. Wiederhold G. Mediators in the architecture of future information systems. IEEE Comput. pp 38-49, 1992
118. Yagoub K., Florescu D., Issarny V., Valduriez P. Caching strategies for data-intensive web sites. In: Proc. of VLDB. pp 188-199, Cairo, Egypt, 2000
119. Yang J., Karlapalem K., Li Q. Algorithms for materialized view design in data warehousing environment. In: Proc. of VLDB. pp 136-145, Athens, Greece, 1997
120. Yang H.Z., Larson P.A. Query transformation for PSJ-queries. In: Proc. of VLDB. pp 245-254, Brighton, UK, 1987
121. +00] Zaharioudakis M., Cochrane R., Lapis G., Pirahesh H., Urata M. Answering complex SQL queries using automatic summary tables. In: Proc. of SIGMOD. pp 105-116, 2000
122. Zhang X., Ozsoyoglu M.Z. On efficient reasoning with implication constraints. In: Proc. of DOOD. pp 236-252, 1993