{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,9,5]],"date-time":"2024-09-05T21:50:16Z","timestamp":1725573016071},"publisher-location":"Berlin, Heidelberg","reference-count":22,"publisher":"Springer Berlin Heidelberg","isbn-type":[{"type":"print","value":"9783540253341"},{"type":"electronic","value":"9783540320050"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2005]]},"DOI":"10.1007\/11408079_48","type":"book-chapter","created":{"date-parts":[[2010,12,20]],"date-time":"2010-12-20T20:38:10Z","timestamp":1292877490000},"page":"548-554","source":"Crossref","is-referenced-by-count":1,"title":["Designing and Using Views to Improve Performance of Aggregate Queries (Extended Abstract)"],"prefix":"10.1007","author":[{"given":"Foto","family":"Afrati","sequence":"first","affiliation":[]},{"given":"Rada","family":"Chirkova","sequence":"additional","affiliation":[]},{"given":"Shalu","family":"Gupta","sequence":"additional","affiliation":[]},{"given":"Charles","family":"Loftis","sequence":"additional","affiliation":[]}],"member":"297","reference":[{"key":"48_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":"48_CR2","doi-asserted-by":"crossref","unstructured":"Cohen, S., Nutt, W., Serebrenik, A.: Rewriting aggregate queries using views. In: Proceedings of PODS, pp. 155\u2013166 (1999)","DOI":"10.1145\/303976.303992"},{"key":"48_CR3","doi-asserted-by":"crossref","unstructured":"Harinarayan, V., Rajaraman, A., Ullman, J.: Implementing data cubes efficiently. In: Proc. SIGMOD, pp. 205\u2013216 (1996)","DOI":"10.1145\/233269.233333"},{"key":"48_CR4","volume-title":"Database Tuning: Principles, Experiments, and Troubleshooting Techniques","author":"D. Shasha","year":"2002","unstructured":"Shasha, D., Bonnet, P.: Database Tuning: Principles, Experiments, and Troubleshooting Techniques. Morgan Kaufmann, San Francisco (2002), \n                    \n                      http:\/\/www.distlab.dk\/dbtune\/"},{"key":"48_CR5","unstructured":"Microsoft Research AutoAdmin Project: Self-Tuning and Self-Administering Databases, \n                    \n                      http:\/\/research.microsoft.com\/dmx\/autoadmin\/default.asp"},{"key":"48_CR6","unstructured":"IBM Autonomic Computing, \n                    \n                      http:\/\/www.research.ibm.com\/autonomic\/"},{"key":"48_CR7","unstructured":"Afrati, F., Chirkova, R., Gupta, S., Loftis, C.: Designing and Using Views to Improve Performance of Aggregate Queries. Technical Report NCSU CSC TR-2004-26 (2004), \n                    \n                      http:\/\/www4.ncsu.edu\/~rychirko\/Papers\/techReport090904.pdf"},{"key":"48_CR8","unstructured":"Chirkova, R., Gupta, S., Kim, K.H., Sandhu, S.: Extensible framework for query-performance enhancement by tuning (2004), Code downloads and documentation are available from \n                    \n                      http:\/\/research.csc.ncsu.edu\/selftune\/"},{"key":"48_CR9","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., Suciu, D.: A formal perspective on the view selection problem. VLDB Journal\u00a011, 216\u2013237 (2002)","journal-title":"VLDB Journal"},{"key":"48_CR10","unstructured":"Agrawal, S., Chaudhuri, S., Narasayya, V.: Automated selection of materialized views and indexes in SQL databases. In: Proceedings of VLDB, pp. 496\u2013505 (2000)"},{"key":"48_CR11","doi-asserted-by":"crossref","unstructured":"Gupta, H., Harinarayan, V., Rajaraman, A., Ullman, J.: Index selection for OLAP. In: Proceedings of ICDE, pp. 208\u2013219 (1997)","DOI":"10.1109\/ICDE.1997.581755"},{"key":"48_CR12","unstructured":"Shukla, A., Deshpande, P., Naughton, J.: Materialized view selection for multidimensional datasets. In: Proceedings of VLDB, pp. 488\u2013499 (1998)"},{"key":"48_CR13","doi-asserted-by":"publisher","first-page":"270","DOI":"10.1007\/s007780100054","volume":"10","author":"A.Y. Halevy","year":"2001","unstructured":"Halevy, A.Y.: Answering queries using views: A survey. VLDB Journal\u00a010, 270\u2013294 (2001)","journal-title":"VLDB Journal"},{"key":"48_CR14","doi-asserted-by":"crossref","unstructured":"Chaudhuri, S., Krishnamurthy, R., Potamianos, S., Shim, K.: Optimizing queries with materialized views. In: Proceedings of the Eleventh International Conference on Data Engineering (ICDE), pp. 190\u2013200 (1995)","DOI":"10.1109\/ICDE.1995.380392"},{"key":"48_CR15","doi-asserted-by":"crossref","unstructured":"Widom, J.: Research problems in data warehousing. In: Proceedings of CIKM (1995)","DOI":"10.1145\/221270.221319"},{"key":"48_CR16","doi-asserted-by":"publisher","first-page":"29","DOI":"10.1023\/A:1009726021843","volume":"1","author":"J. Gray","year":"1997","unstructured":"Gray, J., Chaudhuri, S., Bosworth, A., Layman, A., Reichart, D., Venkatrao, M.: Data cube: A relational aggregation operator generalizing Group-by, Cross-Tab, and Sub Totals. Data Mining and Knowledge Discovery\u00a01, 29\u201353 (1997)","journal-title":"Data Mining and Knowledge Discovery"},{"key":"48_CR17","doi-asserted-by":"publisher","first-page":"65","DOI":"10.1145\/248603.248616","volume":"26","author":"S. Chaudhuri","year":"1997","unstructured":"Chaudhuri, S., Dayal, U.: An overview of data warehousing and OLAP technology. SIGMOD Record\u00a026, 65\u201374 (1997)","journal-title":"SIGMOD Record"},{"key":"48_CR18","unstructured":"Agarwal, S., Agrawal, R., Deshpande, P., Gupta, A., Naughton, J., Ramakrishnan, R., Sarawagi, S.: On the computation of multidimensional aggregates. In: Proceedings of VLDB, pp. 506\u2013521 (1996)"},{"key":"48_CR19","unstructured":"Gupta, A., Harinarayan, V., Quass, D.: Aggregate-query processing in data warehousing environments. In: Proceedings of VLDB, pp. 358\u2013369 (1995)"},{"key":"48_CR20","unstructured":"Srivastava, D., Dar, S., Jagadish, H., Levy, A.: Answering queries with aggregation using views. In: Proc. VLDB, pp. 318\u2013329 (1996)"},{"key":"48_CR21","unstructured":"PostgreSQL (Open source database-management system), \n                    \n                      http:\/\/www.postgresql.org\/"},{"key":"48_CR22","unstructured":"TPC-H: TPC Benchmark H (Decision Support), Available from \n                    \n                      http:\/\/www.tpc.org\/tpch\/spec\/tpch2.1.0.pdf"}],"container-title":["Lecture Notes in Computer Science","Database Systems for Advanced Applications"],"original-title":[],"link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/11408079_48.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2021,4,27]],"date-time":"2021-04-27T07:03:14Z","timestamp":1619506994000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/11408079_48"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2005]]},"ISBN":["9783540253341","9783540320050"],"references-count":22,"URL":"https:\/\/doi.org\/10.1007\/11408079_48","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2005]]}}}