{"id":"https://openalex.org/W4391743034","doi":"https://doi.org/10.1109/imcom60618.2024.10418292","title":"DITune: A Reinforcement Learning Based Framework for Automated Database Index Selection","display_name":"DITune: A Reinforcement Learning Based Framework for Automated Database Index Selection","publication_year":2024,"publication_date":"2024-01-03","ids":{"openalex":"https://openalex.org/W4391743034","doi":"https://doi.org/10.1109/imcom60618.2024.10418292"},"language":"en","primary_location":{"id":"doi:10.1109/imcom60618.2024.10418292","is_oa":false,"landing_page_url":"https://doi.org/10.1109/imcom60618.2024.10418292","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 18th International Conference on Ubiquitous Information Management and Communication (IMCOM)","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5035676193","display_name":"Xiuqi Huang","orcid":"https://orcid.org/0009-0004-4443-1555"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiuqi Huang","raw_affiliation_strings":["Shanghai Jiao Tong University,MoE Key Lab of Artificial Intelligence,Department of Computer Science and Engineering,Shanghai,China","Department of Computer Science and Engineering, MoE Key Lab of Artificial Intelligence, Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Shanghai Jiao Tong University,MoE Key Lab of Artificial Intelligence,Department of Computer Science and Engineering,Shanghai,China","institution_ids":["https://openalex.org/I183067930"]},{"raw_affiliation_string":"Department of Computer Science and Engineering, MoE Key Lab of Artificial Intelligence, Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5019439900","display_name":"Xiaofeng Gao","orcid":"https://orcid.org/0000-0003-1776-8799"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiaofeng Gao","raw_affiliation_strings":["Shanghai Jiao Tong University,MoE Key Lab of Artificial Intelligence,Department of Computer Science and Engineering,Shanghai,China","Department of Computer Science and Engineering, MoE Key Lab of Artificial Intelligence, Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Shanghai Jiao Tong University,MoE Key Lab of Artificial Intelligence,Department of Computer Science and Engineering,Shanghai,China","institution_ids":["https://openalex.org/I183067930"]},{"raw_affiliation_string":"Department of Computer Science and Engineering, MoE Key Lab of Artificial Intelligence, Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100428808","display_name":"Guihai Chen","orcid":"https://orcid.org/0000-0002-6934-1685"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Guihai Chen","raw_affiliation_strings":["Shanghai Jiao Tong University,MoE Key Lab of Artificial Intelligence,Department of Computer Science and Engineering,Shanghai,China","Department of Computer Science and Engineering, MoE Key Lab of Artificial Intelligence, Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Shanghai Jiao Tong University,MoE Key Lab of Artificial Intelligence,Department of Computer Science and Engineering,Shanghai,China","institution_ids":["https://openalex.org/I183067930"]},{"raw_affiliation_string":"Department of Computer Science and Engineering, MoE Key Lab of Artificial Intelligence, Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I183067930"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"8"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.9990000128746033,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9986000061035156,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8529272675514221},{"id":"https://openalex.org/keywords/robustness","display_name":"Robustness (evolution)","score":0.6961023807525635},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.6785075664520264},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.6463959217071533},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.6248552799224854},{"id":"https://openalex.org/keywords/index-selection","display_name":"Index selection","score":0.5557785630226135},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.5489247441291809},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5447753667831421},{"id":"https://openalex.org/keywords/feature-selection","display_name":"Feature selection","score":0.5036398768424988},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.4997982978820801},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.4640606641769409},{"id":"https://openalex.org/keywords/database-tuning","display_name":"Database tuning","score":0.4410162568092346},{"id":"https://openalex.org/keywords/reinforcement-learning","display_name":"Reinforcement learning","score":0.4322274327278137},{"id":"https://openalex.org/keywords/database-index","display_name":"Database index","score":0.4287598133087158},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.36485224962234497},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.36428382992744446},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.3121490180492401},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.1888931691646576},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.12524613738059998}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8529272675514221},{"id":"https://openalex.org/C63479239","wikidata":"https://www.wikidata.org/wiki/Q7353546","display_name":"Robustness (evolution)","level":3,"score":0.6961023807525635},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6785075664520264},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.6463959217071533},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.6248552799224854},{"id":"https://openalex.org/C2778360486","wikidata":"https://www.wikidata.org/wiki/Q6019110","display_name":"Index selection","level":3,"score":0.5557785630226135},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.5489247441291809},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5447753667831421},{"id":"https://openalex.org/C148483581","wikidata":"https://www.wikidata.org/wiki/Q446488","display_name":"Feature selection","level":2,"score":0.5036398768424988},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.4997982978820801},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.4640606641769409},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.4410162568092346},{"id":"https://openalex.org/C97541855","wikidata":"https://www.wikidata.org/wiki/Q830687","display_name":"Reinforcement learning","level":2,"score":0.4322274327278137},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.4287598133087158},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.36485224962234497},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.36428382992744446},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.3121490180492401},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.1888931691646576},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.12524613738059998},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/imcom60618.2024.10418292","is_oa":false,"landing_page_url":"https://doi.org/10.1109/imcom60618.2024.10418292","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 18th International Conference on Ubiquitous Information Management and Communication (IMCOM)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G26000349","display_name":null,"funder_award_id":"62272302,62172276","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G4607672196","display_name":null,"funder_award_id":"2020YFB1707900","funder_id":"https://openalex.org/F4320335777","funder_display_name":"National Key Research and Development Program of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320335777","display_name":"National Key Research and Development Program of China","ror":null}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W283997035","https://openalex.org/W2017992824","https://openalex.org/W2091565802","https://openalex.org/W2101743436","https://openalex.org/W2108490710","https://openalex.org/W2118226259","https://openalex.org/W2147419309","https://openalex.org/W2165481122","https://openalex.org/W2168503413","https://openalex.org/W2170870260","https://openalex.org/W2170942635","https://openalex.org/W2593390416","https://openalex.org/W2613206411","https://openalex.org/W2944240329","https://openalex.org/W2963853546","https://openalex.org/W2970851599","https://openalex.org/W3121830976","https://openalex.org/W3174465898","https://openalex.org/W3175573075","https://openalex.org/W4289533888","https://openalex.org/W6684921986","https://openalex.org/W6758700417"],"related_works":["https://openalex.org/W1989645082","https://openalex.org/W3126171109","https://openalex.org/W2913707658","https://openalex.org/W2388203381","https://openalex.org/W2019999249","https://openalex.org/W2391630783","https://openalex.org/W2389713600","https://openalex.org/W204909595","https://openalex.org/W2373893224","https://openalex.org/W1872829912"],"abstract_inverted_index":{"Index":[0,59],"selection":[1],"is":[2,19],"a":[3,45,53,80,113],"crucial":[4],"and":[5,17,26,36,72,88,106,134,144,148],"essential":[6],"aspect":[7],"of":[8,22,70,124,146],"database":[9,30,86],"management":[10],"systems":[11],"(DBMS)":[12],"aiming":[13],"to":[14,41,83,102,120],"optimize":[15],"performance,":[16],"it":[18],"also":[20],"one":[21],"the":[23,67,74,85,95,117,122,128,142,151],"most":[24],"time-consuming":[25],"laborious":[27],"tasks":[28],"for":[29,49],"administrators":[31],"(DBAs).":[32],"Therefore,":[33],"automatic":[34],"methods":[35],"tools":[37],"are":[38],"urgently":[39],"needed":[40],"help":[42],"DBAs":[43],"choose":[44],"good":[46],"index":[47,75,104,108],"configuration":[48],"workloads.":[50],"We":[51,77],"propose":[52],"recommender":[54],"system":[55],"named":[56],"DITune":[57,147],"(Database":[58],"Tuning)":[60],"which":[61],"can":[62],"automatically":[63],"analyze":[64],"workloads,":[65],"explore":[66],"potential":[68],"benefits":[69],"indexes,":[71],"adjust":[73],"configuration.":[76,109],"first":[78],"implement":[79],"rule-based":[81],"method":[82,126],"embed":[84],"workload":[87,130],"data":[89],"distribution":[90],"feature.":[91],"Then":[92],"we":[93,111],"utilize":[94],"Deep":[96],"Deterministic":[97],"Policy":[98],"Gradient":[99],"(DDPG)":[100],"algorithm":[101],"generate":[103],"recommendations":[105],"construct":[107],"Moreover,":[110],"design":[112],"benchmark":[114],"based":[115,157],"on":[116,158],"standard":[118],"TPC-C":[119],"validate":[121],"performance":[123],"our":[125],"under":[127],"varying":[129],"patterns,":[131],"query":[132],"complexity,":[133],"running":[135],"phase":[136],"length.":[137],"The":[138],"experiment":[139],"results":[140],"show":[141],"effectiveness":[143],"robustness":[145],"indicate":[149],"that":[150],"data-driven":[152],"prediction":[153],"outperforms":[154],"those":[155],"models":[156],"cost":[159],"estimation.":[160]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}