{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,9,5]],"date-time":"2024-09-05T18:11:43Z","timestamp":1725559903708},"publisher-location":"Berlin, Heidelberg","reference-count":21,"publisher":"Springer Berlin Heidelberg","isbn-type":[{"type":"print","value":"9783540278726"},{"type":"electronic","value":"9783540318828"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2005]]},"DOI":"10.1007\/11527862_26","type":"book-chapter","created":{"date-parts":[[2010,7,20]],"date-time":"2010-07-20T19:48:01Z","timestamp":1279655281000},"page":"332-346","source":"Crossref","is-referenced-by-count":1,"title":["Designing Views to Efficiently Answer Real SQL Queries"],"prefix":"10.1007","author":[{"given":"Foto","family":"Afrati","sequence":"first","affiliation":[]},{"given":"Rada","family":"Chirkova","sequence":"additional","affiliation":[]},{"given":"Manolis","family":"Gergatsoulis","sequence":"additional","affiliation":[]},{"given":"Vassia","family":"Pavlaki","sequence":"additional","affiliation":[]}],"member":"297","reference":[{"key":"26_CR1","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"383","DOI":"10.1007\/978-3-540-30570-5_26","volume-title":"Database Theory - ICDT 2005","author":"F. Afrati","year":"2004","unstructured":"Afrati, F., Chirkova, R.: Selecting and using views to compute aggregate queries. In: Eiter, T., Libkin, L. (eds.) ICDT 2005. LNCS, vol.\u00a03363, pp. 383\u2013397. Springer, Heidelberg (2004)"},{"key":"26_CR2","doi-asserted-by":"crossref","unstructured":"Afrati, F., Li, C., Ullman, J.D.: Generating efficient plans for queries using views. In: Proceedings of ACM SIGMOD (2001)","DOI":"10.1145\/375663.375705"},{"key":"26_CR3","unstructured":"Agrawal, S., Chaudhuri, S., Narasayya, V.R.: Automated selection of materialized views and indexes in SQL databases. In: Proc. VLDB, pp. 496\u2013505 (2000)"},{"key":"26_CR4","unstructured":"Baralis, E., Paraboschi, S., Teniente, E.: Materialized view selection in a multidimensional database. In: Proceedings of VLDB, pp. 156\u2013165 (1997)"},{"key":"26_CR5","doi-asserted-by":"crossref","unstructured":"Chandra, A.K., Merlin, P.M.: Optimal implementation of conjunctive queries in relational databases. In: Proc. 9th ACM STOC, pp. 77\u201390 (1977)","DOI":"10.1145\/800105.803397"},{"key":"26_CR6","doi-asserted-by":"crossref","unstructured":"Chaudhuri, S., Krishnamurthy, R., Potamianos, S., Shim, K.: Optimizing queries with materialized views. In: Proceedings of ICDE, pp. 190\u2013200 (1995)","DOI":"10.1109\/ICDE.1995.380392"},{"key":"26_CR7","doi-asserted-by":"crossref","first-page":"59","DOI":"10.1145\/153850.153856","volume-title":"Proceedings of PODS","author":"S. Chaudhuri","year":"1993","unstructured":"Chaudhuri, S., Vardi, M.Y.: Optimization of real conjunctive queries. In: Proceedings of PODS, pp. 59\u201370. ACM Press, New York (1993)"},{"issue":"3","key":"26_CR8","doi-asserted-by":"publisher","first-page":"216","DOI":"10.1007\/s00778-002-0070-0","volume":"11","author":"R. Chirkova","year":"2002","unstructured":"Chirkova, R., Halevy, A.Y., Suciu, D.: A formal perspective on the view selection problem. The VLDB Journal\u00a011(3), 216\u2013237 (2002)","journal-title":"The VLDB Journal"},{"key":"26_CR9","first-page":"38","volume-title":"Proceedings of PODS","author":"R. Chirkova","year":"2003","unstructured":"Chirkova, R., Li, C.: Materializing views with minimal size to answer queries. In: Proceedings of PODS, pp. 38\u201348. ACM Press, New York (2003)"},{"key":"26_CR10","unstructured":"Deutsch, A.: XML Query Reformulation over Mixed and Redundant Storage. PhD thesis, University of Pennsylvania (2002)"},{"key":"26_CR11","unstructured":"Gribble, S., Halevy, A., Ives, Z., Rodrig, M., Suciu, D.: What can databases do for peer-to-peer? In: Proceedings of WebDB (2001)"},{"key":"26_CR12","series-title":"Lecture Notes in Computer Science","first-page":"98","volume-title":"Database Theory - ICDT \u201997","author":"H. Gupta","year":"1996","unstructured":"Gupta, H.: Selection of views to materialize in a data warehouse. In: Afrati, F.N., Kolaitis, P.G. (eds.) ICDT 1997. LNCS, vol.\u00a01186, pp. 98\u2013112. Springer, Heidelberg (1996)"},{"key":"26_CR13","doi-asserted-by":"crossref","unstructured":"Gupta, H., Harinarayan, V., Rajaraman, A., Ullman, J.D.: Index selection for OLAP. In: Proceedings of ICDE, pp. 208\u2013219 (1997)","DOI":"10.1109\/ICDE.1997.581755"},{"key":"26_CR14","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"453","DOI":"10.1007\/3-540-49257-7_28","volume-title":"Database Theory - ICDT\u201999","author":"H. Gupta","year":"1998","unstructured":"Gupta, H., Mumick, I.S.: Selection of views to materialize under a maintenance cost constraint. In: Beeri, C., Bruneman, P. (eds.) ICDT 1999. LNCS, vol.\u00a01540, pp. 453\u2013470. Springer, Heidelberg (1998)"},{"key":"26_CR15","doi-asserted-by":"crossref","unstructured":"Harinarayan, V., Rajaraman, A., Ullman, J.D.: Implementing data cubes efficiently. In: Proceedings of ACM SIGMOD, pp. 205\u2013216 (1996)","DOI":"10.1145\/233269.233333"},{"issue":"3","key":"26_CR16","doi-asserted-by":"publisher","first-page":"288","DOI":"10.1145\/211414.211419","volume":"20","author":"Y. Ioannidis","year":"1995","unstructured":"Ioannidis, Y., Ramakrishnan, R.: Containment of conjunctive queries: Beyond relations as sets. ACM Transactions on Database Systems\u00a020(3), 288\u2013324 (1995)","journal-title":"ACM Transactions on Database Systems"},{"key":"26_CR17","doi-asserted-by":"crossref","unstructured":"Karloff, H.J., Mihail, M.: On the complexity of the view-selection problem. In: Proceedings of PODS, Philadelphia, Pennsylvania, pp. 167\u2013173 (1999)","DOI":"10.1145\/303976.303993"},{"key":"26_CR18","doi-asserted-by":"crossref","first-page":"95","DOI":"10.1145\/212433.220198","volume-title":"Proceedings of PODS","author":"A.Y. Levy","year":"1995","unstructured":"Levy, A.Y., Mendelzon, A.O., Sagiv, Y., Srivastava, D.: Answering queries using views. In: Proceedings of PODS, pp. 95\u2013104. ACM Press, New York (1995)"},{"key":"26_CR19","unstructured":"Pottinger, R., Levy, A.Y.: A scalable algorithm for answering queries using views. In: Proceedings of VLDB, pp. 484\u2013495 (2000)"},{"key":"26_CR20","unstructured":"Theodoratos, D., Sellis, T.: Data warehouse configuration. In: Proceedings of VLDB, Athens, Greece, pp. 126\u2013135 (1997)"},{"key":"26_CR21","unstructured":"Yang, J., Karlapalem, K., Li, Q.: Algorithms for materialized view design in data warehousing environment. In: Proceedings of VLDB, pp. 136\u2013145 (1997)"}],"container-title":["Lecture Notes in Computer Science","Abstraction, Reformulation and Approximation"],"original-title":[],"link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/11527862_26.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2020,11,17]],"date-time":"2020-11-17T20:07:47Z","timestamp":1605643667000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/11527862_26"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2005]]},"ISBN":["9783540278726","9783540318828"],"references-count":21,"URL":"https:\/\/doi.org\/10.1007\/11527862_26","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2005]]}}}