{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,12,18]],"date-time":"2025-12-18T14:30:21Z","timestamp":1766068221402,"version":"3.44.0"},"reference-count":5,"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":[[2025,8]]},"abstract":"<jats:p>Virtual indexes play a crucial role in database query optimization. However, with the rapid advancement of cloud computing and AI-driven models for database optimization, traditional virtual index approaches face significant challenges. Cloud-native environments often prohibit direct conducting query optimization process on production databases due to stability requirements and data privacy concerns. Moreover, while AI models show promising progress, their integration with database systems poses challenges in system complexity, inference acceleration, and model hot updates. In this paper, we present VIDEX, a three-layer disaggregated architecture that decouples database instances, the virtual index optimizer, and algorithm services, providing standardized interfaces for AI model integration. Users can configure VIDEX by either collecting production statistics or loading from a prepared file, enabling high-accuracy what-if analysis using virtual indexes that yield query plans identical to production instances. Additionally, users can freely integrate new AI-driven algorithms into VIDEX. VIDEX has been deployed at ByteDance, serving thousands of MySQL instances daily and over millions of SQL queries for index optimization tasks.<\/jats:p>","DOI":"10.14778\/3750601.3750639","type":"journal-article","created":{"date-parts":[[2025,9,16]],"date-time":"2025-09-16T13:38:05Z","timestamp":1758029885000},"page":"5231-5234","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":1,"title":["VIDEX: A Disaggregated and Extensible Virtual Index for the Cloud and AI Era"],"prefix":"10.14778","volume":"18","author":[{"given":"Rong","family":"Kang","sequence":"first","affiliation":[{"name":"ByteDance Inc., Beijing, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Shuai","family":"Wang","sequence":"additional","affiliation":[{"name":"ByteDance Inc., Beijing, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Tieying","family":"Zhang","sequence":"additional","affiliation":[{"name":"ByteDance Inc., San Jose, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Xianghong","family":"Xu","sequence":"additional","affiliation":[{"name":"ByteDance Inc., Beijing, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Linhui","family":"Xu","sequence":"additional","affiliation":[{"name":"ByteDance Inc., Beijing, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhimin","family":"Liang","sequence":"additional","affiliation":[{"name":"ByteDance Inc., Beijing, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Lei","family":"Zhang","sequence":"additional","affiliation":[{"name":"ByteDance Inc., Chengdu, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Rui","family":"Shi","sequence":"additional","affiliation":[{"name":"ByteDance Inc., Beijing, China"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jianjun","family":"Chen","sequence":"additional","affiliation":[{"name":"ByteDance Inc., San Jose, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2025,9,16]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"[n.d.]. Alibaba Cloud: Database Autonomy Service. https:\/\/www.alibabacloud.com\/en\/product\/das Accessed: 2025-03-26."},{"key":"e_1_2_1_2_1","unstructured":"[n.d.]. Apache Calcite: Dynamic data management framework. https:\/\/calcite.apache.org Accessed: 2025-03-26."},{"key":"e_1_2_1_3_1","first-page":"4","article-title":"Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation","volume":"15","author":"Han Yuxing","year":"2021","unstructured":"Yuxing Han, Ziniu Wu, Peizhi Wu, Rong Zhu, Jingyi Yang, Liang Wei Tan, Kai Zeng, Gao Cong, Yanzhao Qin, Andreas Pfadler, Zhengping Qian, Jingren Zhou, Jiangneng Li, and Bin Cui. 2021. Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation. VLDB 15, 4 (Dec. 2021), 752\u2013765.","journal-title":"VLDB"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.14778\/3696435.3696440"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.14778\/3717755.3717769"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3750601.3750639","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,16]],"date-time":"2025-09-16T13:38:48Z","timestamp":1758029928000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3750601.3750639"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,8]]},"references-count":5,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2025,8]]}},"alternative-id":["10.14778\/3750601.3750639"],"URL":"https:\/\/doi.org\/10.14778\/3750601.3750639","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2025,8]]},"assertion":[{"value":"2025-09-16","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}