{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,8]],"date-time":"2026-04-08T08:53:45Z","timestamp":1775638425075,"version":"3.50.1"},"reference-count":144,"publisher":"Institute of Electrical and Electronics Engineers (IEEE)","issue":"12","license":[{"start":{"date-parts":[[2024,12,1]],"date-time":"2024-12-01T00:00:00Z","timestamp":1733011200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/ieeexplore.ieee.org\/Xplorehelp\/downloads\/license-information\/IEEE.html"},{"start":{"date-parts":[[2024,12,1]],"date-time":"2024-12-01T00:00:00Z","timestamp":1733011200000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-029"},{"start":{"date-parts":[[2024,12,1]],"date-time":"2024-12-01T00:00:00Z","timestamp":1733011200000},"content-version":"stm-asf","delay-in-days":0,"URL":"https:\/\/doi.org\/10.15223\/policy-037"}],"funder":[{"name":"National Key R&D Program of China","award":["2023YFB4503600"],"award-info":[{"award-number":["2023YFB4503600"]}]},{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation of China","doi-asserted-by":"publisher","award":["61925205"],"award-info":[{"award-number":["61925205"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation of China","doi-asserted-by":"publisher","award":["62232009"],"award-info":[{"award-number":["62232009"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]},{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation of China","doi-asserted-by":"publisher","award":["62102215"],"award-info":[{"award-number":["62102215"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]},{"name":"Zhongguancun Lab, Huawei, TAL education"},{"DOI":"10.13039\/501100017582","name":"Beijing National Research Center for Information Science and Technology","doi-asserted-by":"publisher","id":[{"id":"10.13039\/501100017582","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["IEEE Trans. Knowl. Data Eng."],"published-print":{"date-parts":[[2024,12]]},"DOI":"10.1109\/tkde.2024.3422006","type":"journal-article","created":{"date-parts":[[2024,7,2]],"date-time":"2024-07-02T19:40:55Z","timestamp":1719949255000},"page":"7657-7676","source":"Crossref","is-referenced-by-count":6,"title":["Automatic Index Tuning: A Survey"],"prefix":"10.1109","volume":"36","author":[{"ORCID":"https:\/\/orcid.org\/0009-0007-2605-7901","authenticated-orcid":false,"given":"Yang","family":"Wu","sequence":"first","affiliation":[{"name":"Department of Computer Science, Tsinghua University, Beijing, China"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-2285-7836","authenticated-orcid":false,"given":"Xuanhe","family":"Zhou","sequence":"additional","affiliation":[{"name":"Department of Computer Science, Tsinghua University, Beijing, China"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-8803-2055","authenticated-orcid":false,"given":"Yong","family":"Zhang","sequence":"additional","affiliation":[{"name":"Beijing National Research Center for Information Science and Technology, Tsinghua University, Beijing, China"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-1398-0621","authenticated-orcid":false,"given":"Guoliang","family":"Li","sequence":"additional","affiliation":[{"name":"Department of Computer Science, Tsinghua University, Beijing, China"}]}],"member":"263","reference":[{"key":"ref8","article-title":"Oracle base - SQL access advisor in oracle database 10G"},{"key":"ref9","doi-asserted-by":"publisher","DOI":"10.14778\/3551793.3551857"},{"key":"ref10","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066292"},{"key":"ref11","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142549"},{"key":"ref12","doi-asserted-by":"publisher","DOI":"10.1109\/BigData.2015.7364084"},{"key":"ref13","doi-asserted-by":"publisher","DOI":"10.1145\/320521.320537"},{"key":"ref14","article-title":"The automatic indexer for postgres"},{"key":"ref15","article-title":"Predictive indexing","author":"Arulraj","year":"2019"},{"key":"ref16","doi-asserted-by":"publisher","DOI":"10.1109\/32.44361"},{"key":"ref17","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-22849-5_18"},{"key":"ref18","doi-asserted-by":"publisher","DOI":"10.14778\/3503585.3503588"},{"key":"ref19","doi-asserted-by":"publisher","DOI":"10.1109\/TCIAIG.2012.2186810"},{"key":"ref20","doi-asserted-by":"publisher","DOI":"10.1145\/3639305"},{"key":"ref21","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066184"},{"key":"ref22","doi-asserted-by":"publisher","DOI":"10.1109\/icde.2007.367928"},{"key":"ref23","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247608"},{"key":"ref24","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376710"},{"key":"ref25","doi-asserted-by":"publisher","DOI":"10.1109\/69.476501"},{"key":"ref26","doi-asserted-by":"publisher","DOI":"10.1007\/BF02568608"},{"key":"ref27","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2004.75"},{"key":"ref28","doi-asserted-by":"publisher","DOI":"10.1145\/564691.564747"},{"key":"ref29","doi-asserted-by":"publisher","DOI":"10.1145\/276305.276337"},{"key":"ref30","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.1999.754945"},{"key":"ref31","article-title":"Anytime algorithm of database tuning advisor for microsoft SQL server","author":"Chaudhuri","year":"2020"},{"key":"ref32","doi-asserted-by":"publisher","DOI":"10.1016\/B978-012722442-8\/50070-7"},{"key":"ref33","first-page":"146","article-title":"An efficient, cost-driven index selection tool for microsoft SQL server","volume-title":"Proc. 23rd Int. Conf. Very Large Data Bases","author":"Chaudhuri"},{"key":"ref34","doi-asserted-by":"publisher","DOI":"10.1109\/ICCI.1993.315323"},{"key":"ref35","first-page":"13","article-title":"Increasing database performance using indexes","volume":"2","author":"Cioloca","year":"2011","journal-title":"Database Syst. J."},{"key":"ref36","doi-asserted-by":"publisher","DOI":"10.1145\/320289.320296"},{"key":"ref37","doi-asserted-by":"publisher","DOI":"10.1145\/2213836.2213843"},{"key":"ref38","doi-asserted-by":"publisher","DOI":"10.1145\/1807128.1807152"},{"key":"ref39","doi-asserted-by":"publisher","DOI":"10.1145\/3299869.3314035"},{"key":"ref40","doi-asserted-by":"publisher","DOI":"10.14778\/1978665.1978668"},{"key":"ref41","doi-asserted-by":"publisher","DOI":"10.1137\/13093875X"},{"key":"ref43","doi-asserted-by":"publisher","DOI":"10.14778\/3430915.3430931"},{"key":"ref44","doi-asserted-by":"publisher","DOI":"10.1145\/3299869.3324957"},{"key":"ref45","doi-asserted-by":"publisher","DOI":"10.1016\/j.knosys.2006.08.005"},{"key":"ref46","article-title":"Learning permutations with sinkhorn policy gradient","author":"Emami","year":"2018"},{"key":"ref47","doi-asserted-by":"publisher","DOI":"10.1007\/s11023-020-09548-1"},{"key":"ref48","doi-asserted-by":"publisher","DOI":"10.1007\/bfb0038500"},{"key":"ref49","doi-asserted-by":"publisher","DOI":"10.1145\/3511808.3557163"},{"key":"ref50","doi-asserted-by":"publisher","DOI":"10.14778\/2180912.2180918"},{"key":"ref51","doi-asserted-by":"publisher","DOI":"10.1145\/1739041.1739087"},{"key":"ref52","article-title":"Index tuning with machine learning on quantum computers for large-scale database applications","volume-title":"Proc. VLDB Workshops","author":"Gruenwald"},{"key":"ref53","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.1997.581755"},{"key":"ref54","doi-asserted-by":"publisher","DOI":"10.14778\/2168651.2168652"},{"key":"ref55","doi-asserted-by":"publisher","DOI":"10.1145\/773153.773177"},{"key":"ref56","doi-asserted-by":"publisher","DOI":"10.14778\/3551793.3551799"},{"key":"ref57","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3389704"},{"key":"ref58","doi-asserted-by":"publisher","DOI":"10.1162\/neco.1997.9.8.1735"},{"key":"ref59","doi-asserted-by":"publisher","DOI":"10.1145\/1645953.1646193"},{"key":"ref60","doi-asserted-by":"publisher","DOI":"10.32473\/flairs.v35i.130584"},{"key":"ref61","first-page":"68","article-title":"Database cracking","volume-title":"Proc. 3rd Biennial Conf. Innov. Data Syst. Res.","author":"Idreos"},{"key":"ref62","doi-asserted-by":"publisher","DOI":"10.14778\/2002938.2002944"},{"key":"ref63","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3199671"},{"key":"ref64","doi-asserted-by":"publisher","DOI":"10.1109\/TSE.1983.236458"},{"key":"ref65","doi-asserted-by":"publisher","DOI":"10.1088\/0034-4885\/43\/9\/002"},{"key":"ref66","doi-asserted-by":"publisher","DOI":"10.1145\/2213836.2213932"},{"key":"ref67","doi-asserted-by":"publisher","DOI":"10.1016\/j.cor.2021.105385"},{"key":"ref68","first-page":"169","article-title":"Automated management of indexes for dataflow processing engines in IaaS clouds","volume-title":"Proc. 23rd Int. Conf. Extending Database Technol.","author":"Kllapi"},{"key":"ref69","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-02190-9_1"},{"key":"ref70","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-24844-6_179"},{"key":"ref71","doi-asserted-by":"publisher","DOI":"10.14778\/3407790.3407832"},{"key":"ref72","first-page":"2","article-title":"SWIRL: Selection of workload-aware indexes using reinforcement learning","volume-title":"Proc. Int. Conf. Extending Database Technol.","author":"Kossmann"},{"key":"ref73","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3196909"},{"key":"ref74","doi-asserted-by":"publisher","DOI":"10.1007\/3-540-36605-9_26"},{"key":"ref75","doi-asserted-by":"publisher","DOI":"10.1002\/0471721379"},{"key":"ref76","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-030-85899-5_13"},{"key":"ref77","doi-asserted-by":"publisher","DOI":"10.1145\/3340531.3412106"},{"key":"ref78","volume-title":"Source Code Analysis of Opengauss Database","author":"Li","year":"2021"},{"key":"ref79","doi-asserted-by":"publisher","DOI":"10.14778\/3476311.3476380"},{"key":"ref80","article-title":"RoBERTa: A robustly optimized bert pretraining approach","author":"Liu","year":"2019"},{"key":"ref81","doi-asserted-by":"publisher","DOI":"10.1109\/ICDEW.2007.4401028"},{"key":"ref82","doi-asserted-by":"publisher","DOI":"10.1145\/800184.810505"},{"key":"ref83","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3196908"},{"key":"ref84","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3457276"},{"key":"ref85","doi-asserted-by":"publisher","DOI":"10.14778\/3342263.3342646"},{"key":"ref86","article-title":"Playing atari with deep reinforcement learning","author":"Mnih","year":"2013"},{"key":"ref87","doi-asserted-by":"publisher","DOI":"10.1145\/2245276.2245450"},{"key":"ref88","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2010.5447889"},{"key":"ref89","doi-asserted-by":"publisher","DOI":"10.18293\/SEKE2019-135"},{"key":"ref90","doi-asserted-by":"publisher","DOI":"10.1007\/s002360050048"},{"key":"ref91","article-title":"The star schema benchmark (SSB)","volume":"200","author":"O\u2019Neil","year":"2007","journal-title":"Pat"},{"key":"ref92","doi-asserted-by":"publisher","DOI":"10.1007\/s10489-020-01674-8"},{"key":"ref93","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2009.191"},{"key":"ref94","doi-asserted-by":"publisher","DOI":"10.1109\/ICDEW.2007.4401027"},{"key":"ref95","first-page":"1093","article-title":"Efficient use of the query optimizer for automated physical design","volume-title":"Proc. 33rd Int. Conf. Very Large Data Bases","author":"Papadomanolakis"},{"key":"ref96","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-319-92639-1_60"},{"key":"ref97","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE51399.2021.00058"},{"key":"ref98","doi-asserted-by":"publisher","DOI":"10.14778\/3565816.3565824"},{"key":"ref99","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2723719"},{"key":"ref100","doi-asserted-by":"publisher","DOI":"10.1145\/984523.984530"},{"key":"ref101","doi-asserted-by":"publisher","DOI":"10.1137\/1.9781611973440.53"},{"issue":"3","key":"ref102","first-page":"634","article-title":"Intelligent index tuning approach for relational databases","volume":"31","author":"Qiu","year":"2020","journal-title":"J. Softw."},{"key":"ref103","volume-title":"Neural Networks and Deep Learning","author":"Qiu","year":"2019"},{"key":"ref104","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-031-12423-5_11"},{"key":"ref105","doi-asserted-by":"publisher","DOI":"10.1145\/3410566.3410603"},{"key":"ref106","doi-asserted-by":"publisher","DOI":"10.1109\/ICDEW49219.2020.00035"},{"key":"ref107","doi-asserted-by":"publisher","DOI":"10.1109\/TNN.2008.2005605"},{"key":"ref108","doi-asserted-by":"publisher","DOI":"10.1016\/0306-4379(75)90003-4"},{"key":"ref109","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2019.00113"},{"key":"ref110","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142592"},{"key":"ref111","doi-asserted-by":"publisher","DOI":"10.1109\/ICDEW.2007.4401029"},{"key":"ref112","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2009.166"},{"key":"ref113","doi-asserted-by":"publisher","DOI":"10.14778\/2140436.2140444"},{"key":"ref114","doi-asserted-by":"publisher","DOI":"10.14778\/1687627.1687766"},{"key":"ref115","article-title":"Proximal policy optimization algorithms","author":"Schulman","year":"2017"},{"key":"ref116","article-title":"The case for automatic database administration using deep reinforcement learning","author":"Sharma","year":"2018"},{"key":"ref117","doi-asserted-by":"publisher","DOI":"10.1145\/3477314.3507691"},{"key":"ref118","doi-asserted-by":"publisher","DOI":"10.1145\/3472163.3472176"},{"key":"ref119","doi-asserted-by":"publisher","DOI":"10.14778\/3565838.3565848"},{"key":"ref120","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526152"},{"key":"ref121","doi-asserted-by":"publisher","DOI":"10.1145\/3641832.3641836"},{"key":"ref122","doi-asserted-by":"publisher","DOI":"10.14778\/3547305.3547309"},{"key":"ref123","doi-asserted-by":"publisher","DOI":"10.14778\/3368289.3368296"},{"key":"ref124","doi-asserted-by":"publisher","DOI":"10.1109\/tnn.1998.712192"},{"key":"ref125","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2012.11.001"},{"key":"ref126","doi-asserted-by":"publisher","DOI":"10.1145\/1353452.1353455"},{"key":"ref127","doi-asserted-by":"publisher","DOI":"10.1145\/2791347.2791376"},{"key":"ref128","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3517843"},{"key":"ref129","doi-asserted-by":"publisher","DOI":"10.14778\/3625054.3625066"},{"key":"ref130","article-title":"A survey on database index tuning and defragmentation","author":"Valavala","year":"2020"},{"key":"ref131","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2000.839397"},{"key":"ref132","doi-asserted-by":"publisher","DOI":"10.1007\/11564096_42"},{"key":"ref133","doi-asserted-by":"publisher","DOI":"10.1145\/3448016.3452754"},{"key":"ref134","first-page":"1","article-title":"The case for multi-task zero-shot learning for databases","volume-title":"Proc. 4th Int. Workshop Appl. AI Database Syst. Appl. Colocated VLDB","author":"Wehrstein"},{"key":"ref135","article-title":"Learning index selection with structured action spaces","author":"Welborn","year":"2019"},{"key":"ref136","doi-asserted-by":"publisher","DOI":"10.1007\/978-1-4613-1881-1_41"},{"key":"ref137","doi-asserted-by":"publisher","DOI":"10.1109\/TC.1984.1676418"},{"key":"ref138","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2013.6544899"},{"key":"ref139","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526128"},{"key":"ref140","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-031-22137-8_32"},{"key":"ref142","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE55515.2023.00257"},{"key":"ref143","doi-asserted-by":"publisher","DOI":"10.1016\/j.ins.2021.01.003"},{"issue":"6","key":"ref144","article-title":"CedarAdvisor: A load-adaptive automatic indexing recommendation tool","volume":"2020","author":"Yang","year":"2020","journal-title":"J. East China Normal Univ."},{"key":"ref145","doi-asserted-by":"publisher","DOI":"10.14778\/3654621.3654622"},{"key":"ref146","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE48307.2020.00133"},{"key":"ref147","doi-asserted-by":"publisher","DOI":"10.1145\/3589331"},{"key":"ref148","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2023.3266893"},{"key":"ref149","doi-asserted-by":"publisher","DOI":"10.14778\/3529337.3529349"},{"key":"ref150","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE53745.2022.00210"},{"key":"ref151","doi-asserted-by":"publisher","DOI":"10.1007\/s41019-023-00235-6"},{"key":"ref152","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-030-85899-5_34"},{"key":"ref153","doi-asserted-by":"publisher","DOI":"10.14778\/3654621.3654631"}],"container-title":["IEEE Transactions on Knowledge and Data Engineering"],"original-title":[],"link":[{"URL":"http:\/\/xplorestaging.ieee.org\/ielx8\/69\/10750897\/10582533.pdf?arnumber=10582533","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,11,27]],"date-time":"2024-11-27T00:30:30Z","timestamp":1732667430000},"score":1,"resource":{"primary":{"URL":"https:\/\/ieeexplore.ieee.org\/document\/10582533\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,12]]},"references-count":144,"journal-issue":{"issue":"12"},"URL":"https:\/\/doi.org\/10.1109\/tkde.2024.3422006","relation":{},"ISSN":["1041-4347","1558-2191","2326-3865"],"issn-type":[{"value":"1041-4347","type":"print"},{"value":"1558-2191","type":"electronic"},{"value":"2326-3865","type":"electronic"}],"subject":[],"published":{"date-parts":[[2024,12]]}}}