{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,12,11]],"date-time":"2025-12-11T20:43:36Z","timestamp":1765485816988},"reference-count":24,"publisher":"Association for Computing Machinery (ACM)","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2009,8]]},"abstract":"<jats:p>\n            Database statistics are crucial to cost-based optimizers for estimating the execution cost of a query plan. Using traditional basic statistics on base tables requires adopting unrealistic assumptions to estimate the cardinalities of intermediate results, which usually causes large estimation errors that can be several orders of magnitude. Modern commercial database systems support statistical or sample views, which give more accurate statistics on intermediate results and query sub-expressions. While previous research focused on creating and maintaining these advanced statistics, only little effort has been done towards automatically recommending the most beneficial statistical views to construct. In this paper, we present\n            <jats:bold>StatAdvisor<\/jats:bold>\n            , a system for recommending statistical views for a given SQL workload. The\n            <jats:bold>StatAdvisor<\/jats:bold>\n            addresses the special characteristics of statistical views with respect to view matching and benefit estimation, and introduces a novel plan-based candidate enumeration method, and a benefit-based analysis to determine the most useful statistical views. We present the basic concepts, architecture, and key features of\n            <jats:bold>StatAdvisor<\/jats:bold>\n            , and demonstrate its validity and benefits through an extensive experimental study using a prototype that we built in the IBM\u00ae DB2\u00ae database system as part of the\n            <jats:italic>DB2 Design Advisor<\/jats:italic>\n            tools.\n          <\/jats:p>","DOI":"10.14778\/1687553.1687556","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1306-1317","source":"Crossref","is-referenced-by-count":13,"title":["StatAdvisor"],"prefix":"10.14778","volume":"2","author":[{"given":"Amr","family":"El-Helw","sequence":"first","affiliation":[{"name":"University of Waterloo"}]},{"given":"Ihab F.","family":"Ilyas","sequence":"additional","affiliation":[{"name":"University of Waterloo"}]},{"given":"Calisto","family":"Zuzarte","sequence":"additional","affiliation":[{"name":"IBM Toronto Lab"}]}],"member":"320","published-online":{"date-parts":[[2009,8]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.5555\/1316689.1316788"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/304182.304207"},{"key":"e_1_2_1_3_1","volume-title":"VLDB","author":"Agrawal S.","year":"2000","unstructured":"S. Agrawal , S. Chaudhuri , and V. R. Narasayya . Automated Selection of Materialized Views and Indexes in SQL Databases . In VLDB , 2000 . S. Agrawal, S. Chaudhuri, and V. R. Narasayya. Automated Selection of Materialized Views and Indexes in SQL Databases. In VLDB, 2000."},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066172"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066171"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1145\/564691.564722"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/1007568.1007604"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/304182.304206"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1109\/69.908978"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2007.367897"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.5555\/1315451.1315533"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/1007568.1007641"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/115790.115835"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1145\/276304.276315"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247502"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.5555\/645484.656390"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/1007568.1007642"},{"key":"e_1_2_1_18_1","volume-title":"VLDB","author":"Olken F.","year":"1986","unstructured":"F. Olken and D. Rotem . Simple Random Sampling from Relational Databases . In VLDB , 1986 . F. Olken and D. Rotem. Simple Random Sampling from Relational Databases. In VLDB, 1986."},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2006.84"},{"key":"e_1_2_1_20_1","volume-title":"VLDB","author":"Stillger M.","year":"2001","unstructured":"M. Stillger , G. M. Lohman , V. Markl , and M. Kandil . LEO - DB2's LEarning Optimizer . In VLDB , 2001 . M. Stillger, G. M. Lohman, V. Markl, and M. Kandil. LEO - DB2's LEarning Optimizer. In VLDB, 2001."},{"key":"e_1_2_1_21_1","volume-title":"http:\/\/www.tpc.org\/tpcds","author":"Benchmark TPC. TPC-DS","year":"2005","unstructured":"TPC. TPC-DS Benchmark , http:\/\/www.tpc.org\/tpcds , 2005 . TPC. TPC-DS Benchmark, http:\/\/www.tpc.org\/tpcds, 2005."},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2000.839397"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/342009.335390"},{"key":"e_1_2_1_24_1","volume-title":"VLDB","author":"Zilio D. C.","year":"2004","unstructured":"D. C. Zilio , J. Rao , S. Lightstone , G. M. Lohman , A. Storm , C. Garcia-Arellano , and S. Fadden . DB2 Design Advisor: Integrated Automatic Physical Database Design . In VLDB , 2004 . D. C. Zilio, J. Rao, S. Lightstone, G. M. Lohman, A. Storm, C. Garcia-Arellano, and S. Fadden. DB2 Design Advisor: Integrated Automatic Physical Database Design. In VLDB, 2004."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/1687553.1687556","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:56:25Z","timestamp":1672224985000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/1687553.1687556"}},"subtitle":["recommending statistical views"],"short-title":[],"issued":{"date-parts":[[2009,8]]},"references-count":24,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2009,8]]}},"alternative-id":["10.14778\/1687553.1687556"],"URL":"https:\/\/doi.org\/10.14778\/1687553.1687556","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2009,8]]}}}