{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,25]],"date-time":"2025-10-25T14:21:27Z","timestamp":1761402087632,"version":"3.44.0"},"reference-count":31,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2020,8]]},"abstract":"<jats:p>Automated generation of a right set of materialized views is a challenging task. It is a highly desirable feature for autonomous databases. The selection of materialized views must be based on cost and verifiable in the actual database environment. This paper describes an automated system that generates, selects, verifies, and maintains materialized views in the Oracle RDBMS; it presents a novel technique, called the extended covering sub-expression algorithm, for the automated generation of materialized views. An extensive set of experiments is described that demonstrates the feasibility and efficiency of this approach. This system has been fully implemented and is going to be deployed on the Oracle Autonomous Database on the Cloud.<\/jats:p>","DOI":"10.14778\/3415478.3415533","type":"journal-article","created":{"date-parts":[[2020,9,14]],"date-time":"2020-09-14T18:46:35Z","timestamp":1600109195000},"page":"3046-3058","source":"Crossref","is-referenced-by-count":26,"title":["Automated generation of materialized views in Oracle"],"prefix":"10.14778","volume":"13","author":[{"given":"Rafi","family":"Ahmed","sequence":"first","affiliation":[{"name":"Oracle Corporation"}]},{"given":"Randall","family":"Bello","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}]},{"given":"Andrew","family":"Witkowski","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}]},{"given":"Praveen","family":"Kumar","sequence":"additional","affiliation":[{"name":"Oracle Corporation"}]}],"member":"320","published-online":{"date-parts":[[2020,8]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"Proc. of the 26th Int. Conf. on VLDB","author":"Agarwal S.","year":"2000","unstructured":"Agarwal, S., Chaudhuri, S., and Narasayya, V., Automated Selection of Materialized Views and Indexes for SQL Databases, Proc. of the 26th Int. Conf. on VLDB, Cairo, Egypt, 2000."},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1016\/B978-012088469-8.50097-8"},{"issue":"13","key":"e_1_2_1_3_1","first-page":"1452","volume":"7","author":"Ahmed R.","year":"2014","unstructured":"Ahmed, R., Sen, R., Poess, M., and Chakkapen, S. Of Snowstorms and Bushy Trees. PVLDB, 7(13):1452--1461, 2014.","journal-title":"Of Snowstorms and Bushy Trees. PVLDB"},{"key":"e_1_2_1_4_1","volume-title":"Proc. of the 32nd VLDB Conf.","author":"Ahmed R.","year":"2006","unstructured":"Ahmed, R., Lee, A., Witkowski, A., Das, D., Su, H., and Cruanes, T., Cost-Based Query Transformation in Oracle, Proc. of the 32nd VLDB Conf., Seoul, S. Korea, 2006."},{"key":"e_1_2_1_5_1","volume-title":"An Introduction to Generalized Linear Models","author":"Annette J.D.","year":"2018","unstructured":"Annette, J.D. and Barnett, A.G., An Introduction to Generalized Linear Models, Fourth Edition, 2018."},{"issue":"6","key":"e_1_2_1_6_1","article-title":"Selecting and Using Views to Compute Aggregate Queries","volume":"77","author":"Arfati F.","year":"2011","unstructured":"Arfati, F. and Chirkova, R., Selecting and Using Views to Compute Aggregate Queries, Journal of Computer and System Sciences, vol. 77, no. 6, 2011.","journal-title":"Journal of Computer and System Sciences"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1214\/09-SS054"},{"key":"e_1_2_1_8_1","volume-title":"Proc. of the 24th Int. Conf. on VLDB","author":"Bello R.","year":"1998","unstructured":"Bello, R., Dias, K., Downing, A., Feenan, J., Finnerty, J., Norcott, W., Sun, H., Witkowski, A., and Ziauddin, M., Materialized Views in Oracle, Proc. of the 24th Int. Conf. on VLDB, New York, U.S.A., 1998."},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/335168.335230"},{"key":"e_1_2_1_10_1","volume-title":"Proc. of ACM SIGMOD","author":"Chaudhuri S.","year":"1998","unstructured":"Chaudhuri, S. and Narasayya, V., Auto-Admin: `What-If' Index Analysis Utility, Proc. of ACM SIGMOD, 1998."},{"issue":"11","key":"e_1_2_1_11_1","article-title":"Index Selection for Databases: A Hardness Study and a Principled Heuristic Solution","volume":"16","author":"Chaudhuri S.","year":"2004","unstructured":"Chaudhuri, S., Datar, M., and Narasayya, V., Index Selection for Databases: A Hardness Study and a Principled Heuristic Solution, IEEE Trans. Knowl. and Data Engg. 16(11), 2004.","journal-title":"IEEE Trans. Knowl. and Data Engg."},{"key":"e_1_2_1_12_1","volume-title":"Proc. of the 33rd VLDB Conf.","author":"Chaudhuri S.","year":"2007","unstructured":"Chaudhuri S. and Narasayya, V., Self-Tuning Database Systems: A Decade of Progress, Proc. of the 33rd VLDB Conf., Vienna Austria, 2007."},{"key":"e_1_2_1_13_1","volume-title":"Proc. of 23rd VLDB Conf.","author":"Chaudhuri S.","year":"1997","unstructured":"Chaudhuri S. and Narasayya, V., An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server, Proc. of 23rd VLDB Conf., Athens, Greece, 1997."},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1561\/1900000020"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1016\/B978-012088469-8.50096-6"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/3299869.3314035"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/375663.375706"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.5555\/645503.656261"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.14778\/3192965.3192971"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/3034786.3034792"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-20010-1"},{"key":"e_1_2_1_22_1","volume-title":"Intl. Conf. on Data Engineering.","author":"Lehner W.","year":"2001","unstructured":"Lehner, W., Cochrane, B., Pirahesh, H., and Zaharioudakis, M., Applying Mass Query Optimization to Speed Up Automatic Summary Table Refresh, Intl. Conf. on Data Engineering., 2001."},{"key":"e_1_2_1_23_1","volume-title":"Really?, PVLDB 9(3)","author":"Leis V.","year":"2015","unstructured":"Leis, V., Gubichev, A., Mirchev, A., Boncz, P., Kemper, A., and Neumann, T., How Good are Query Optimizers, Really?, PVLDB 9(3), November 2015."},{"key":"e_1_2_1_24_1","unstructured":"Lohman G. Is Query Optimizer a `Solved' Problem? http:\/\/wp.sigmod.org\/?p=1075 2015."},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1145\/342009.335419"},{"key":"e_1_2_1_26_1","volume-title":"SIGMOD Record 13(2)","author":"Shapiro G.P.","year":"1983","unstructured":"Shapiro, G.P., The Optimal Selection of Secondary Indices is NP-Complete, SIGMOD Record 13(2), 1983."},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2012.106"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/1353343.1353383"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247540"},{"key":"e_1_2_1_30_1","volume-title":"Proc. of 30th VLDB Conf.","author":"Zilio D. C.","year":"2004","unstructured":"Zilio, D. C., Rao, J., Lightstone, S., Lohman, G., Storm, A., Garcia-Arellano, C., and Fadden, S., DB2 Design Advisor: Integrated Automatic Physical Database Design, Proc. of 30th VLDB Conf., Toronto, Canada, 2004."},{"key":"e_1_2_1_31_1","volume-title":"Proc. of Intl. Conf. on Autonomic Computing","author":"Zilio D. C.","year":"2004","unstructured":"Zilio, D. C., Rao, J., Lightstone, S., Ma, W., Lohman, G., Cochrane, R., Pirahesh, H., Colby, L.S., Gryz, J., Alton, E., Liang, D., and Valentin, G., Recommending Materialized Views and Indexes with IBM DB2 Design Advisor, Proc. of Intl. Conf. on Autonomic Computing, 2004."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3415478.3415533","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,17]],"date-time":"2025-09-17T02:32:27Z","timestamp":1758076347000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3415478.3415533"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,8]]},"references-count":31,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2020,8]]}},"alternative-id":["10.14778\/3415478.3415533"],"URL":"https:\/\/doi.org\/10.14778\/3415478.3415533","relation":{},"ISSN":["2150-8097"],"issn-type":[{"type":"print","value":"2150-8097"}],"subject":[],"published":{"date-parts":[[2020,8]]}}}