{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,19]],"date-time":"2026-05-19T07:13:45Z","timestamp":1779174825514,"version":"3.51.4"},"reference-count":65,"publisher":"Association for Computing Machinery (ACM)","issue":"10","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2024,6]]},"abstract":"<jats:p>Index advisors aim to improve workload performance by judiciously selecting an appropriate set of indexes. Various heuristic-based and learning-based methods have been proposed. However, there lacks a comprehensive assessment of existing index advisors, i.e., their advantages, limitations, and application scenarios. In this work, we conduct an in-depth study of existing index advisors in five key aspects. First, we initiate an end-to-end analysis, i.e., a completed analysis throughout the entire workflow of index advisors. We decompose index advisors into three essential building blocks, establish a taxonomy to classify methods used in each block, and analyze the strengths and weaknesses of these methods. Second, we develop a unified open-source testbed, implementing seventeen index advisors across eleven open-source or real-world datasets. We enable customizable configurations to meet diverse testing requirements. Third, we conduct an extensive assessment of index advisors across database systems in various scenarios. We evaluate their adaptability and robustness, identifying practical application scenarios. Fourth, we undertake a fine-grained ablation study by investigating variants of each building block. We identify effective variants and pinpoint significant factors impacting index advisors' performance via explainable machine-learning techniques. Lastly, we consolidate our findings that could shed light on research directions to advance the future development of index advisors.<\/jats:p>","DOI":"10.14778\/3675034.3675035","type":"journal-article","created":{"date-parts":[[2024,8,6]],"date-time":"2024-08-06T22:19:11Z","timestamp":1722982751000},"page":"2405-2418","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":12,"title":["Breaking It Down: An In-Depth Study of Index Advisors"],"prefix":"10.14778","volume":"17","author":[{"given":"Wei","family":"Zhou","sequence":"first","affiliation":[{"name":"School of Informatics, Xiamen University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Chen","family":"Lin","sequence":"additional","affiliation":[{"name":"School of Informatics, Xiamen University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Xuanhe","family":"Zhou","sequence":"additional","affiliation":[{"name":"Department of Computer, Science and Technology, Tsinghua University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Guoliang","family":"Li","sequence":"additional","affiliation":[{"name":"Department of Computer, Science and Technology, Tsinghua University"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2024,8,6]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"HypoPG. (Extension). https:\/\/github.com\/HypoPG\/hypopg visited on 2024-06-12."},{"key":"e_1_2_1_2_1","unstructured":"Index Advisor (EA&B). (Extended Version). https:\/\/github.com\/Beliefuture\/Index_EAB visited on 2024-06-12."},{"key":"e_1_2_1_3_1","unstructured":"PostgreSQL. (DBMS). https:\/\/www.postgresql.org visited on 2024-06-12."},{"key":"e_1_2_1_4_1","unstructured":"TPC-DS Benchmark. (TPC). https:\/\/www.tpc.org\/tpcds visited on 2024-06-12."},{"key":"e_1_2_1_5_1","unstructured":"TPC-H Benchmark. (TPC). https:\/\/www.tpc.org\/tpch visited on 2024-06-12."},{"key":"e_1_2_1_6_1","volume-title":"Proceedings of the International Conference on Management of Data (SIGMOD). 881--888","author":"Aulbach Stefan","year":"2009","unstructured":"Stefan Aulbach, Dean Jacobs, Alfons Kemper, and Michael Seibold. 2009. A comparison of flexible schemas for software as a service. In Proceedings of the International Conference on Management of Data (SIGMOD). 881--888."},{"key":"e_1_2_1_7_1","doi-asserted-by":"crossref","first-page":"22","DOI":"10.1287\/opre.21.1.22","article-title":"Linear Programming with a Fractional Objective Function","volume":"21","author":"Bitran Gabriel R.","year":"1973","unstructured":"Gabriel R. Bitran and A. G. Novaes. 1973. Linear Programming with a Fractional Objective Function. Operation Research 21, 1 (1973), 22--29.","journal-title":"Operation Research"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1109\/TCIAIG.2012.2186810"},{"key":"e_1_2_1_9_1","volume-title":"Proceedings of the International Conference on Management of Data (SIGMOD). 227--238","author":"Bruno Nicolas","year":"2005","unstructured":"Nicolas Bruno and Surajit Chaudhuri. 2005. Automatic Physical Database Tuning: A Relaxation-based Approach. In Proceedings of the International Conference on Management of Data (SIGMOD). 227--238."},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1109\/69.476501"},{"key":"e_1_2_1_11_1","unstructured":"S. Chaudhuri and V. Narasayya. 2020. Anytime Algorithm of Database Tuning Advisor for Microsoft SQL Server. https:\/\/www.microsoft.com\/en-us\/research\/publication\/. visited on 2024-06-12."},{"key":"e_1_2_1_12_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB). 146--155","author":"Chaudhuri Surajit","unstructured":"Surajit Chaudhuri and Vivek R. Narasayya. 1997. An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server. In Proceedings of the International Conference on Very Large Databases (VLDB). 146--155."},{"key":"e_1_2_1_13_1","volume-title":"Proceedings of the International Conference on Knowledge Discovery and Data Mining (KDD). 785--794","author":"Chen Tianqi","year":"2016","unstructured":"Tianqi Chen and Carlos Guestrin. 2016. XGBoost: A Scalable Tree Boosting System. In Proceedings of the International Conference on Knowledge Discovery and Data Mining (KDD). 785--794."},{"key":"e_1_2_1_14_1","volume-title":"Rauber","author":"Conserva Michelangelo","year":"2022","unstructured":"Michelangelo Conserva and Paulo E. Rauber. 2022. Hardness in Markov Decision Processes: Theory and Practice. In Proceedings of Advances in Neural Information Processing Systems (NeurIPS). 14824--14838."},{"key":"e_1_2_1_15_1","volume-title":"Proceedings of the International Conference on Management of Data (SIGMOD). 666--679","author":"Das Sudipto","year":"2019","unstructured":"Sudipto Das, Miroslav Grbic, Igor Ilic, Isidora Jovandic, Andrija Jovanovic, Vivek R. Narasayya, Miodrag Radulovic, Maja Stikic, Gaoxiang Xu, and Surajit Chaudhuri. 2019. Automatically Indexing Millions of Databases in Microsoft Azure SQL Database. In Proceedings of the International Conference on Management of Data (SIGMOD). 666--679."},{"key":"e_1_2_1_16_1","first-page":"6","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 4","author":"Dash Debabrata","year":"2011","unstructured":"Debabrata Dash, Neoklis Polyzotis, and Anastasia Ailamaki. 2011. CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads. Proceedings of the International Conference on Very Large Databases (VLDB) 4, 6 (2011), 362--372."},{"key":"e_1_2_1_17_1","volume-title":"Proceedings of the International Conference on Data Engineering (ICDE Workshops). 11--18","author":"Debnath Biplob K.","unstructured":"Biplob K. Debnath, David J. Lilja, and Mohamed F. Mokbel. 2008. SARD: A statistical approach for ranking database tuning parameters. In Proceedings of the International Conference on Data Engineering (ICDE Workshops). 11--18."},{"key":"e_1_2_1_18_1","first-page":"4","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 7","author":"Difallah Djellel Eddine","year":"2013","unstructured":"Djellel Eddine Difallah, Andrew Pavlo, Carlo Curino, and Philippe Cudr\u00e9-Mauroux. 2013. OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases. Proceedings of the International Conference on Very Large Databases (VLDB) 7, 4 (2013), 277--288."},{"key":"e_1_2_1_19_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 14","author":"Ding Bailu","year":"2021","unstructured":"Bailu Ding, Surajit Chaudhuri, Johannes Gehrke, and Vivek R. Narasayya. 2021. DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems. Proceedings of the International Conference on Very Large Databases (VLDB) 14, 13 (2021), 3376--3388."},{"key":"e_1_2_1_20_1","volume-title":"Proceedings of the International Conference on Management of Data (SIGMOD). 1241--1258","author":"Ding Bailu","unstructured":"Bailu Ding, Sudipto Das, Ryan Marcus, Wentao Wu, Surajit Chaudhuri, and Vivek R. Narasayya. 2019. AI Meets AI: Leveraging Query Executions to Improve Index Recommendations. In Proceedings of the International Conference on Management of Data (SIGMOD). 1241--1258."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1137\/090771806"},{"key":"e_1_2_1_22_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 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. Proceedings of the International Conference on Very Large Databases (VLDB) 15, 4 (2021), 752--765."},{"key":"e_1_2_1_23_1","volume-title":"Seo, Wook-Shin Han, Kangwoo Choi, and Jaehyok Chong. 2022. Learned Cardinality Estimation: An In-depth Study. In Proceedings of the International Conference on Management of Data (SIGMOD). 1214--1227","author":"Kim Kyoungmin","unstructured":"Kyoungmin Kim, Jisung Jung, In Seo, Wook-Shin Han, Kangwoo Choi, and Jaehyok Chong. 2022. Learned Cardinality Estimation: An In-depth Study. In Proceedings of the International Conference on Management of Data (SIGMOD). 1214--1227."},{"key":"e_1_2_1_24_1","volume-title":"Proceedings of the International Conference on Innovative Data Systems Research (CIDR). 1--8.","author":"Kipf Andreas","year":"2019","unstructured":"Andreas Kipf, Thomas Kipf, Bernhard Radke, Viktor Leis, Peter A. Boncz, and Alfons Kemper. 2019. Learned Cardinalities: Estimating Correlated Joins with Deep Learning. In Proceedings of the International Conference on Innovative Data Systems Research (CIDR). 1--8."},{"key":"e_1_2_1_25_1","volume-title":"Captum: A unified and generic model interpretability library for PyTorch. arXiv Preprint","author":"Kokhlikyan Narine","year":"2020","unstructured":"Narine Kokhlikyan, Vivek Miglani, Miguel Martin, Edward Wang, Bilal Alsallakh, Jonathan Reynolds, Alexander Melnikov, Natalia Kliushkina, Carlos Araya, Siqi Yan, and Orion Reblitz-Richardson. 2020. Captum: A unified and generic model interpretability library for PyTorch. arXiv Preprint (2020). https:\/\/arxiv.org\/abs\/2009.07896"},{"key":"e_1_2_1_26_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 13","author":"Kossmann Jan","year":"2020","unstructured":"Jan Kossmann, Stefan Halfpap, Marcel Jankrift, and Rainer Schlosser. 2020. Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms. Proceedings of the International Conference on Very Large Databases (VLDB) 13, 11 (2020), 2382--2395."},{"key":"e_1_2_1_27_1","volume-title":"Proceedings of the 25th International Conference on Extending Database Technology (EDBT). 2:155--2:168","author":"Kossmann Jan","year":"2022","unstructured":"Jan Kossmann, Alexander Kastius, and Rainer Schlosser. 2022. SWIRL: Selection of Workload-aware Indexes using Reinforcement Learning. In Proceedings of the 25th International Conference on Extending Database Technology (EDBT). 2:155--2:168."},{"key":"e_1_2_1_28_1","volume-title":"Proceedings of the International Conference on Management of Data (SIGMOD). ACM, 489--504","author":"Kraska Tim","year":"2018","unstructured":"Tim Kraska, Alex Beutel, Ed H. Chi, Jeffrey Dean, and Neoklis Polyzotis. 2018. The Case for Learned Index Structures. In Proceedings of the International Conference on Management of Data (SIGMOD). ACM, 489--504."},{"key":"e_1_2_1_29_1","volume-title":"Proceedings of the International Conference on Information and Knowledge Management (CIKM). 2105--2108","author":"Lan Hai","year":"2020","unstructured":"Hai Lan, Zhifeng Bao, and Yuwei Peng. 2020. An Index Advisor Using Deep Reinforcement Learning. In Proceedings of the International Conference on Information and Knowledge Management (CIKM). 2105--2108."},{"key":"e_1_2_1_30_1","volume-title":"Distributed Representations of Sentences and Documents. In Proceedings of the International Conference on Machine Learning (ICML) (JMLR Workshop and Conference Proceedings)","volume":"32","author":"Quoc","unstructured":"Quoc V. Le and Tom\u00e1s Mikolov. 2014. Distributed Representations of Sentences and Documents. In Proceedings of the International Conference on Machine Learning (ICML) (JMLR Workshop and Conference Proceedings), Vol. 32. 1188--1196."},{"key":"e_1_2_1_31_1","volume-title":"Hinton","author":"LeCun Yann","year":"2015","unstructured":"Yann LeCun, Yoshua Bengio, and Geoffrey E. Hinton. 2015. Deep learning. Nature 521, 7553 (2015), 436--444."},{"key":"e_1_2_1_32_1","first-page":"3","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 9","author":"Leis Viktor","year":"2015","unstructured":"Viktor Leis, Andrey Gubichev, Atanas Mirchev, Peter A. Boncz, Alfons Kemper, and Thomas Neumann. 2015. How Good Are Query Optimizers, Really? Proceedings of the International Conference on Very Large Databases (VLDB) 9, 3 (2015), 204--215."},{"key":"e_1_2_1_33_1","volume-title":"Proceedings of the International Conference on Management of Data (SIGMOD). 1920--1933","author":"Li Beibin","year":"2022","unstructured":"Beibin Li, Yao Lu, and Srikanth Kandula. 2022. Warper: Efficiently Adapting Learned Cardinality Estimators to Data and Workload Drifts. In Proceedings of the International Conference on Management of Data (SIGMOD). 1920--1933."},{"key":"e_1_2_1_34_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 14","author":"Li Guoliang","year":"2021","unstructured":"Guoliang Li, Xuanhe Zhou, Ji Sun, Xiang Yu, Yue Han, Lianyuan Jin, Wenbo Li, Tianqing Wang, and Shifu Li. 2021. openGauss: An Autonomous Database System. Proceedings of the International Conference on Very Large Databases (VLDB) 14, 12 (2021), 3028--3041."},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1007\/s10489-020-01674-8"},{"key":"e_1_2_1_36_1","volume-title":"Human-level control through deep reinforcement learning. Nature 518, 7540","author":"Mnih Volodymyr","year":"2015","unstructured":"Volodymyr Mnih, Koray Kavukcuoglu, David Silver, Andrei A. Rusu, Joel Veness, Marc G. Bellemare, Alex Graves, Martin A. Riedmiller, Andreas Fidjeland, Georg Ostrovski, Stig Petersen, Charles Beattie, Amir Sadik, Ioannis Antonoglou, Helen King, Dharshan Kumaran, Daan Wierstra, Shane Legg, and Demis Hassabis. 2015. Human-level control through deep reinforcement learning. Nature 518, 7540 (2015), 529--533."},{"key":"e_1_2_1_37_1","volume-title":"Proceedings of the International Conference on Management of Data (SIGMOD). 2465--2473","author":"Vivek","unstructured":"Vivek R. Narasayya and Surajit Chaudhuri. 2022. Multi-Tenant Cloud Data Services: State-of-the-Art, Challenges and Opportunities. In Proceedings of the International Conference on Management of Data (SIGMOD). 2465--2473."},{"key":"e_1_2_1_38_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 16","author":"Negi Parimarjan","year":"2023","unstructured":"Parimarjan Negi, Ziniu Wu, Andreas Kipf, Nesime Tatbul, Ryan Marcus, Sam Madden, Tim Kraska, and Mohammad Alizadeh. 2023. Robust Query Driven Cardinality Estimation under Changing Workloads. Proceedings of the International Conference on Very Large Databases (VLDB) 16, 6 (2023), 1520--1533."},{"key":"e_1_2_1_39_1","volume-title":"Proceedings of the International Conference on Data Engineering (ICDE). 600--611","author":"Perera R. Malinga","year":"2021","unstructured":"R. Malinga Perera, Bastian Oetomo, Benjamin I. P. Rubinstein, and Renata Borovica-Gajic. 2021. DBA bandits: Self-driving index tuning under ad-hoc, analytical workloads with safety guarantees. In Proceedings of the International Conference on Data Engineering (ICDE). 600--611."},{"key":"e_1_2_1_40_1","volume-title":"Proceedings of the Symposium on International Database Engineering and Applications (IDEAS). 11:1--11:8.","author":"Sadri Zahra","year":"2020","unstructured":"Zahra Sadri, Le Gruenwald, and Eleazar Leal. 2020. DRLindex: deep reinforcement learning index advisor for a cluster database. In Proceedings of the Symposium on International Database Engineering and Applications (IDEAS). 11:1--11:8."},{"key":"e_1_2_1_41_1","volume-title":"Proceedings of the International Conference on Data Engineering (ICDE Workshops). 158--161","author":"Sadri Zahra","year":"2020","unstructured":"Zahra Sadri, Le Gruenwald, and Eleazar Leal. 2020. Online Index Selection Using Deep Reinforcement Learning for a Cluster Database. In Proceedings of the International Conference on Data Engineering (ICDE Workshops). 158--161."},{"key":"e_1_2_1_42_1","volume-title":"Proceedings of the International Conference on Scientific and Statistical Database Management (SSDBM). 16:1--16:4.","author":"Schlosser Rainer","year":"2020","unstructured":"Rainer Schlosser and Stefan Halfpap. 2020. A Decomposition Approach for Risk-Averse Index Selection. In Proceedings of the International Conference on Scientific and Statistical Database Management (SSDBM). 16:1--16:4."},{"key":"e_1_2_1_43_1","volume-title":"Proceedings of the International Conference on Data Engineering (ICDE). 1238--1249","author":"Schlosser Rainer","year":"2019","unstructured":"Rainer Schlosser, Jan Kossmann, and Martin Boissier. 2019. Efficient Scalable Multi-attribute Index Selection Using Recursive Strategies. In Proceedings of the International Conference on Data Engineering (ICDE). 1238--1249."},{"key":"e_1_2_1_44_1","doi-asserted-by":"publisher","DOI":"10.1007\/s42979-022-01473-7"},{"key":"e_1_2_1_45_1","first-page":"5","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 5","author":"Schnaitter Karl","year":"2012","unstructured":"Karl Schnaitter and Neoklis Polyzotis. 2012. Semi-Automatic Index Tuning: Keeping DBAs in the Loop. Proceedings of the International Conference on Very Large Databases (VLDB) 5, 5 (2012), 478--489."},{"key":"e_1_2_1_46_1","volume-title":"Proximal Policy Optimization Algorithms. arXiv Preprint","author":"Schulman John","year":"2017","unstructured":"John Schulman, Filip Wolski, Prafulla Dhariwal, Alec Radford, and Oleg Klimov. 2017. Proximal Policy Optimization Algorithms. arXiv Preprint (2017). https:\/\/arxiv.org\/abs\/1707.06347"},{"key":"e_1_2_1_47_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 15","author":"Shi Jiachen","year":"2022","unstructured":"Jiachen Shi, Gao Cong, and Xiaoli Li. 2022. Learned Index Benefits: Machine Learning Based Index Performance Estimation. Proceedings of the International Conference on Very Large Databases (VLDB) 15, 13 (2022), 3950--3962."},{"key":"e_1_2_1_48_1","volume-title":"Proceedings of the International Conference on Management of Data (SIGMOD). 660--673","author":"Siddiqui Tarique","year":"2022","unstructured":"Tarique Siddiqui, Saehan Jo, Wentao Wu, Chi Wang, Vivek R. Narasayya, and Surajit Chaudhuri. 2022. ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning. In Proceedings of the International Conference on Management of Data (SIGMOD). 660--673."},{"key":"e_1_2_1_49_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 15","author":"Siddiqui Tarique","year":"2022","unstructured":"Tarique Siddiqui, Wentao Wu, Vivek R. Narasayya, and Surajit Chaudhuri. 2022. DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning. Proceedings of the International Conference on Very Large Databases (VLDB) 15, 10 (2022), 2019--2031."},{"key":"e_1_2_1_50_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 13","author":"Sun Ji","year":"2019","unstructured":"Ji Sun and Guoliang Li. 2019. An End-to-End Learning-based Cost Estimator. Proceedings of the International Conference on Very Large Databases (VLDB) 13, 3 (2019), 307--319."},{"key":"e_1_2_1_51_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 15","author":"Sun Ji","year":"2021","unstructured":"Ji Sun, Jintao Zhang, Zhaoyan Sun, Guoliang Li, and Nan Tang. 2021. Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation. Proceedings of the International Conference on Very Large Databases (VLDB) 15, 1 (2021), 85--97."},{"key":"e_1_2_1_52_1","doi-asserted-by":"publisher","DOI":"10.1162\/089976699300016728"},{"key":"e_1_2_1_53_1","volume-title":"Proceedings of the International Conference on Data Engineering (ICDE). 101--110","author":"Valentin Gary","year":"2000","unstructured":"Gary Valentin, Michael Zuliani, Daniel C. Zilio, Guy M. Lohman, and Alan Skelley. 2000. DB2 Advisor: An Optimizer Smart Enough to Recommend Its Own Indexes. In Proceedings of the International Conference on Data Engineering (ICDE). 101--110."},{"key":"e_1_2_1_54_1","volume-title":"Real-time Workload Pattern Analysis for Large-scale Cloud Databases. arXiv Preprint","author":"Wang Jiaqi","year":"2023","unstructured":"Jiaqi Wang, Tianyi Li, Anni Wang, Xiaoze Liu, Lu Chen, Jie Chen, Jianye Liu, Junyang Wu, Feifei Li, and Yunjun Gao. 2023. Real-time Workload Pattern Analysis for Large-scale Cloud Databases. arXiv Preprint (2023). https:\/\/arxiv.org\/abs\/2307.02626"},{"key":"e_1_2_1_55_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 14","author":"Wang Xiaoying","year":"2021","unstructured":"Xiaoying Wang, Changbo Qu, Weiyuan Wu, Jiannan Wang, and Qingqing Zhou. 2021. Are We Ready For Learned Cardinality Estimation? Proceedings of the International Conference on Very Large Databases (VLDB) 14, 9 (2021), 1640--1654."},{"key":"e_1_2_1_56_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-1-4613-1881-1_41"},{"key":"e_1_2_1_57_1","volume-title":"Proceedings of the International Conference on Data Engineering (ICDE). 1081--1092","author":"Wu Wentao","unstructured":"Wentao Wu, Yun Chi, Shenghuo Zhu, Jun'ichi Tatemura, Hakan Hacig\u00fcm\u00fcs, and Jeffrey F. Naughton. 2013. Predicting query execution time: Are optimizer cost models really unusable?. In Proceedings of the International Conference on Data Engineering (ICDE). 1081--1092."},{"key":"e_1_2_1_58_1","volume-title":"Proceedings of the International Conference on Management of Data (SIGMOD). 1528--1541","author":"Wu Wentao","unstructured":"Wentao Wu, Chi Wang, Tarique Siddiqui, Junxiong Wang, Vivek R. Narasayya, Surajit Chaudhuri, and Philip A. Bernstein. 2022. Budget-aware Index Tuning with Reinforcement Learning. In Proceedings of the International Conference on Management of Data (SIGMOD). 1528--1541."},{"key":"e_1_2_1_59_1","volume-title":"Proceedings of the International Conference on Management of Data (SIGMOD). 945--958","author":"Zhang Lixi","year":"2022","unstructured":"Lixi Zhang, Chengliang Chai, Xuanhe Zhou, and Guoliang Li. 2022. Learned-SQLGen: Constraint-aware SQL Generation using Reinforcement Learning. In Proceedings of the International Conference on Management of Data (SIGMOD). 945--958."},{"key":"e_1_2_1_60_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 15","author":"Zhao Yue","year":"2022","unstructured":"Yue Zhao, Gao Cong, Jiachen Shi, and Chunyan Miao. 2022. QueryFormer: A Tree Transformer Model for Query Plan Representation. Proceedings of the International Conference on Very Large Databases (VLDB) 15, 8 (2022), 1658--1670."},{"key":"e_1_2_1_61_1","volume-title":"Proceedings of the International Conference on Information and Knowledge Management (CIKM). 5133--5137","author":"Zhou Wei","year":"2023","unstructured":"Wei Zhou, Chen Lin, Xuanhe Zhou, Guoliang Li, and Tianqing Wang. 2023. Demonstration of ViTA: Visualizing, Testing and Analyzing Index Advisors. In Proceedings of the International Conference on Information and Knowledge Management (CIKM). 5133--5137."},{"key":"e_1_2_1_62_1","volume-title":"Proceedings of the International Conference on Data Engineering (ICDE).","author":"Zhou Wei","year":"2024","unstructured":"Wei Zhou, Chen Lin, Xuanhe Zhou, Guoliang Li, and Tianqing Wang. 2024. TRAP: Tailored Robustness Assessement for Index Advisors via Adversarial Perturbation. In Proceedings of the International Conference on Data Engineering (ICDE). to appear."},{"key":"e_1_2_1_63_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB) 16","author":"Zhou Xuanhe","year":"2023","unstructured":"Xuanhe Zhou, Cheng Chen, Kunyi Li, Bingsheng He, Mian Lu, Qiaosheng Liu, Wei Huang, Guoliang Li, Zhao Zheng, and Yuqiang Chen. 2023. FEBench: A Benchmark for Real-Time Relational Data Feature Extraction. Proceedings of the International Conference on Very Large Databases (VLDB) 16, 12 (2023), 3597--3609."},{"key":"e_1_2_1_64_1","volume-title":"Proceedings of the International Conference on Data Engineering (ICDE). 2196--2208","author":"Zhou Xuanhe","year":"2022","unstructured":"Xuanhe Zhou, Luyang Liu, Wenbo Li, Lianyuan Jin, Shifu Li, Tianqing Wang, and Jianhua Feng. 2022. AutoIndex: An Incremental Index Management System for Dynamic Workloads. In Proceedings of the International Conference on Data Engineering (ICDE). 2196--2208."},{"key":"e_1_2_1_65_1","volume-title":"Proceedings of the International Conference on Management of Data (SIGMOD Companion). 217--224","author":"Zhu Yiwen","year":"2023","unstructured":"Yiwen Zhu, Yuanyuan Tian, Joyce Cahoon, Subru Krishnan, Ankita Agarwal, Rana Alotaibi, Jes\u00fas Camacho-Rodr\u00edguez, Bibin Chundatt, Andrew Chung, Niharika Dutta, Andrew Fogarty, Anja Gruenheid, Brandon Haynes, Matteo Interlandi, Minu Iyer, Nick Jurgens, Sumeet Khushalani, Brian Kroth, Manoj Kumar, Jyoti Leeka, Sergiy Matusevych, Minni Mittal, Andreas M\u00fcller, Kartheek Muthyala, Harsha Nagulapalli, Yoonjae Park, Hiren Patel, Anna Pavlenko, Olga Poppe, Santhosh Ravindran, Karla Saur, Rathijit Sen, Steve Suh, Arijit Tarafdar, Kunal Waghray, Demin Wang, Carlo Curino, and Raghu Ramakrishnan. 2023. Towards Building Autonomous Data Services on Azure. In Proceedings of the International Conference on Management of Data (SIGMOD Companion). 217--224."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3675034.3675035","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,8,6]],"date-time":"2024-08-06T22:22:15Z","timestamp":1722982935000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3675034.3675035"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,6]]},"references-count":65,"journal-issue":{"issue":"10","published-print":{"date-parts":[[2024,6]]}},"alternative-id":["10.14778\/3675034.3675035"],"URL":"https:\/\/doi.org\/10.14778\/3675034.3675035","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2024,6]]},"assertion":[{"value":"2024-08-06","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}