{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,1,1]],"date-time":"2025-01-01T05:07:41Z","timestamp":1735708061076,"version":"3.32.0"},"reference-count":11,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2024,8]]},"abstract":"<jats:p>Materialized views (MVs) are critical for improving query performance of database systems, especially in online analytical processing (OLAP) databases. Typically, MVs are maintained by DBAs, which relies on prior knowledge and manual operations. Recently, autonomous solutions are designed for specific databases. However, a data warehouse for OLAP is typically hierarchical, which uses different database engines at different stages. Hence, existing methods have limitations in terms of autonomy and unification to support practical applications.<\/jats:p>\n          <jats:p>Motivated by these, we develop UniView, a unified autonomous materialized view management system that supports various popular databases, including Spark SQL, PostgreSQL, and ClickHouse. Moreover, we provide a cross-platform web user interface, where users can carry out the process of materialized views and evaluate the optimization performance. In the demonstration, we show that UniView is user-friendly and can achieve superior performance in the practical industry scenarios.<\/jats:p>","DOI":"10.14778\/3685800.3685873","type":"journal-article","created":{"date-parts":[[2024,11,8]],"date-time":"2024-11-08T17:25:21Z","timestamp":1731086721000},"page":"4353-4356","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":0,"title":["UniView: A Unified Autonomous Materialized View Management System for Various Databases"],"prefix":"10.14778","volume":"17","author":[{"given":"Zhenrong","family":"Xu","sequence":"first","affiliation":[{"name":"Zhejiang University, Hangzhou, China"}]},{"given":"Pengfei","family":"Wang","sequence":"additional","affiliation":[{"name":"Zhejiang University, Hangzhou, China"}]},{"given":"Guoze","family":"Xue","sequence":"additional","affiliation":[{"name":"Zhejiang University, Hangzhou, China"}]},{"given":"Qitong","family":"Yan","sequence":"additional","affiliation":[{"name":"Zhejiang University, Hangzhou, China"}]},{"given":"Shenghao","family":"Gong","sequence":"additional","affiliation":[{"name":"Zhejiang University, Hangzhou, China"}]},{"given":"Yelan","family":"Jiang","sequence":"additional","affiliation":[{"name":"Zhejiang University, Hangzhou, China"}]},{"given":"Yuren","family":"Mao","sequence":"additional","affiliation":[{"name":"Zhejiang University, Hangzhou, China"}]},{"given":"Yunjun","family":"Gao","sequence":"additional","affiliation":[{"name":"Zhejiang University, Hangzhou, China"}]},{"given":"Shu","family":"Shen","sequence":"additional","affiliation":[{"name":"Huawei, Hangzhou, China"}]},{"given":"Wei","family":"Zhang","sequence":"additional","affiliation":[{"name":"Huawei, Hangzhou, China"}]},{"given":"Dan","family":"Luo","sequence":"additional","affiliation":[{"name":"Huawei, Hangzhou, China"}]},{"given":"Lu","family":"Chen","sequence":"additional","affiliation":[{"name":"Zhejiang University, Hangzhou, China"}]}],"member":"320","published-online":{"date-parts":[[2024,11,8]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.14778\/3415478.3415533"},{"key":"e_1_2_1_2_1","unstructured":"Yue Han Chengliang Chai Jiabin Liu Guoliang Li Chuangxian Wei and Chaoqun Zhan. 2023. Dynamic Materialized View Management using Graph Neural Network. In ICDE."},{"key":"e_1_2_1_3_1","doi-asserted-by":"crossref","unstructured":"Yue Han Guoliang Li Haitao Yuan and Ji Sun. 2021. An autonomous materialized view management system with deep reinforcement learning. In ICDE. 2159--2164.","DOI":"10.1109\/ICDE51399.2021.00217"},{"key":"e_1_2_1_4_1","volume-title":"AutoView: An Autonomous Materialized View Management System with Encoder-Reducer. TKDE","author":"Han Yue","year":"2022","unstructured":"Yue Han, Guoliang Li, Haitao Yuan, and Ji Sun. 2022. AutoView: An Autonomous Materialized View Management System with Encoder-Reducer. TKDE (2022)."},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.14778\/3192965.3192971"},{"key":"e_1_2_1_6_1","volume-title":"Opportunistic view materialization with deep reinforcement learning. arXiv preprint arXiv:1903.01363","author":"Liang Xi","year":"2019","unstructured":"Xi Liang, Aaron J Elmore, and Sanjay Krishnan. 2019. Opportunistic view materialization with deep reinforcement learning. arXiv preprint arXiv:1903.01363 (2019)."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.14778\/3565816.3565824"},{"key":"e_1_2_1_8_1","doi-asserted-by":"crossref","unstructured":"Georgia Troullinou Haridimos Kondylakis Matteo Lissandrini and Davide Mottin. 2021. SOFOS: demonstrating the challenges of materialized view selection on knowledge graphs. In SIGMOD. 2789--2793.","DOI":"10.1145\/3448016.3452765"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1007\/s41019-022-00186-4"},{"key":"e_1_2_1_10_1","doi-asserted-by":"crossref","unstructured":"Haitao Yuan Guoliang Li Ling Feng Ji Sun and Yue Han. 2020. Automatic view generation with deep learning and reinforcement learning. In ICDE. 1501--1512.","DOI":"10.1109\/ICDE48307.2020.00133"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.14778\/3476311.3476334"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3685800.3685873","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,12,31]],"date-time":"2024-12-31T05:25:59Z","timestamp":1735622759000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3685800.3685873"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,8]]},"references-count":11,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2024,8]]}},"alternative-id":["10.14778\/3685800.3685873"],"URL":"https:\/\/doi.org\/10.14778\/3685800.3685873","relation":{},"ISSN":["2150-8097"],"issn-type":[{"type":"print","value":"2150-8097"}],"subject":[],"published":{"date-parts":[[2024,8]]},"assertion":[{"value":"2024-11-08","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}