{"id":"https://openalex.org/W4366504025","doi":"https://doi.org/10.1109/tkde.2023.3266893","title":"Automatic Database Knob Tuning: A Survey","display_name":"Automatic Database Knob Tuning: A Survey","publication_year":2023,"publication_date":"2023-04-20","ids":{"openalex":"https://openalex.org/W4366504025","doi":"https://doi.org/10.1109/tkde.2023.3266893"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2023.3266893","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2023.3266893","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"},"type":"article","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/A5070250000","display_name":"Xinyang Zhao","orcid":"https://orcid.org/0009-0001-3534-1644"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xinyang Zhao","raw_affiliation_strings":["Department of Computer Science, Tsinghua University, Beijing, China"],"raw_orcid":"https://orcid.org/0009-0001-3534-1644","affiliations":[{"raw_affiliation_string":"Department of Computer Science, Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5056912386","display_name":"Xuanhe Zhou","orcid":"https://orcid.org/0000-0002-2285-7836"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xuanhe Zhou","raw_affiliation_strings":["Department of Computer Science, Tsinghua University, Beijing, China"],"raw_orcid":"https://orcid.org/0000-0002-2285-7836","affiliations":[{"raw_affiliation_string":"Department of Computer Science, Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100451576","display_name":"Guoliang Li","orcid":"https://orcid.org/0000-0002-1398-0621"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Guoliang Li","raw_affiliation_strings":["Department of Computer Science, Tsinghua University, Beijing, China"],"raw_orcid":"https://orcid.org/0000-0002-1398-0621","affiliations":[{"raw_affiliation_string":"Department of Computer Science, Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I99065089"],"apc_list":null,"apc_paid":null,"fwci":6.5553,"has_fulltext":false,"cited_by_count":49,"citation_normalized_percentile":{"value":0.97319962,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":100},"biblio":{"volume":"35","issue":"12","first_page":"12470","last_page":"12490"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9861000180244446,"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"}},"topics":[{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9861000180244446,"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"}},{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.9750000238418579,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9728999733924866,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/leverage","display_name":"Leverage (statistics)","score":0.7462050914764404},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7059561014175415},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5213505029678345},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.48401638865470886},{"id":"https://openalex.org/keywords/pipeline","display_name":"Pipeline (software)","score":0.4726511538028717},{"id":"https://openalex.org/keywords/heuristic","display_name":"Heuristic","score":0.4113948941230774},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3908311426639557},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.3752663731575012},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.12502163648605347}],"concepts":[{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.7462050914764404},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7059561014175415},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5213505029678345},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.48401638865470886},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.4726511538028717},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.4113948941230774},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3908311426639557},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.3752663731575012},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.12502163648605347}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tkde.2023.3266893","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2023.3266893","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G5725260554","display_name":null,"funder_award_id":"62232009","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G7169141996","display_name":null,"funder_award_id":"62102215","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G831406350","display_name":null,"funder_award_id":"61925205","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation 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/F4320329777","display_name":"Beijing National Research Center For Information Science And Technology","ror":null}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":108,"referenced_works":["https://openalex.org/W320896","https://openalex.org/W175221152","https://openalex.org/W1576035775","https://openalex.org/W1964144121","https://openalex.org/W1977556410","https://openalex.org/W1981988185","https://openalex.org/W2014181466","https://openalex.org/W2040428289","https://openalex.org/W2096468639","https://openalex.org/W2098443134","https://openalex.org/W2100218206","https://openalex.org/W2105636195","https://openalex.org/W2112474496","https://openalex.org/W2115258141","https://openalex.org/W2133741724","https://openalex.org/W2135046866","https://openalex.org/W2138766682","https://openalex.org/W2145020294","https://openalex.org/W2147419309","https://openalex.org/W2168503413","https://openalex.org/W2169671370","https://openalex.org/W2396309311","https://openalex.org/W2400667298","https://openalex.org/W2568283272","https://openalex.org/W2583754181","https://openalex.org/W2586673923","https://openalex.org/W2613206411","https://openalex.org/W2760770811","https://openalex.org/W2799015892","https://openalex.org/W2889252017","https://openalex.org/W2918721540","https://openalex.org/W2923804366","https://openalex.org/W2944240329","https://openalex.org/W2945459156","https://openalex.org/W2948513753","https://openalex.org/W2961614712","https://openalex.org/W2963745734","https://openalex.org/W2966185412","https://openalex.org/W2970836712","https://openalex.org/W2970851599","https://openalex.org/W2997325344","https://openalex.org/W2998249308","https://openalex.org/W3007086929","https://openalex.org/W3022630129","https://openalex.org/W3024784979","https://openalex.org/W3024860837","https://openalex.org/W3025775630","https://openalex.org/W3029327553","https://openalex.org/W3029535034","https://openalex.org/W3030387435","https://openalex.org/W3037027022","https://openalex.org/W3045004532","https://openalex.org/W3085364173","https://openalex.org/W3095166039","https://openalex.org/W3098844916","https://openalex.org/W3104631761","https://openalex.org/W3119448165","https://openalex.org/W3134578347","https://openalex.org/W3139827290","https://openalex.org/W3157139371","https://openalex.org/W3165341913","https://openalex.org/W3168955346","https://openalex.org/W3173850788","https://openalex.org/W3174394491","https://openalex.org/W3174465898","https://openalex.org/W3174969457","https://openalex.org/W3175573075","https://openalex.org/W3176153696","https://openalex.org/W3189646782","https://openalex.org/W3196849431","https://openalex.org/W3197917898","https://openalex.org/W3201123012","https://openalex.org/W3208735199","https://openalex.org/W3217092890","https://openalex.org/W4206064074","https://openalex.org/W4206343428","https://openalex.org/W4206830372","https://openalex.org/W4221062824","https://openalex.org/W4229050510","https://openalex.org/W4281753793","https://openalex.org/W4281855270","https://openalex.org/W4281972940","https://openalex.org/W4287186366","https://openalex.org/W4288057686","https://openalex.org/W4289533888","https://openalex.org/W4289533904","https://openalex.org/W4289761856","https://openalex.org/W4312397585","https://openalex.org/W4317641620","https://openalex.org/W6600011973","https://openalex.org/W6630006964","https://openalex.org/W6638867933","https://openalex.org/W6639007902","https://openalex.org/W6645515230","https://openalex.org/W6674836892","https://openalex.org/W6676817345","https://openalex.org/W6677651438","https://openalex.org/W6713201245","https://openalex.org/W6733129084","https://openalex.org/W6733403177","https://openalex.org/W6753146606","https://openalex.org/W6759199104","https://openalex.org/W6759932666","https://openalex.org/W6765435108","https://openalex.org/W6772169254","https://openalex.org/W6780261451","https://openalex.org/W6794535964","https://openalex.org/W6794702024"],"related_works":["https://openalex.org/W3037187668","https://openalex.org/W4234772502","https://openalex.org/W2787993192","https://openalex.org/W2380685755","https://openalex.org/W2252100032","https://openalex.org/W2963436428","https://openalex.org/W4400978025","https://openalex.org/W2918743509","https://openalex.org/W2734796617","https://openalex.org/W2158269427"],"abstract_inverted_index":{"Knob":[0],"tuning":[1,66,84,115,131,147,156,161,194,248,275,311,324,359],"plays":[2],"an":[3],"important":[4],"role":[5],"in":[6,28,313,326,373],"database":[7,16,100,187,230],"optimization,":[8],"which":[9],"tunes":[10],"knob":[11,29,65,71,83,114,130,146,155,165,188,193,235,323,358,375],"settings":[12,72,166],"to":[13,42,81,94,119,144,152,163,173,368],"optimize":[14],"the":[15,44,48,86,135,160,175,226,291,319,357,370],"performance":[17],"or":[18],"improve":[19],"resource":[20],"utilization.":[21],"However,":[22],"there":[23],"are":[24,54,117],"several":[25],"common":[26],"challenges":[27,292,343],"tuning.":[30,189,376],"First,":[31,217],"databases":[32,332],"have":[33],"hundreds":[34],"of":[35,55,88,99,128,137,192,229,274,321],"configuration":[36],"knobs,":[37],"and":[38,58,109,158,211,232,250,260,284,293,333,344,361,364],"it":[39,77,141],"is":[40,78,132,142],"hard":[41],"determine":[43],"knobs":[45,53,231],"that":[46,307],"cause":[47,59],"performance/resource":[49],"bottlenecks.":[50],"Second,":[51,238],"most":[52],"continuous":[56],"values":[57],"large":[60,97],"search":[61],"space,":[62],"where":[63,91],"heuristic":[64,278],"may":[67],"not":[68],"find":[69],"high-performance":[70],"within":[73],"limited":[74],"time.":[75],"Third,":[76,263],"increasingly":[79],"tricky":[80],"conduct":[82],"with":[85,134],"proliferation":[87],"cloud":[89],"services,":[90],"we":[92,181,224,245,270,289,302,317,339],"need":[93],"tune":[95],"a":[96,154,183],"number":[98],"instances":[101],"for":[102,167,218,239,264],"various":[103],"scenarios":[104],"(e.g.,":[105,256,329],"different":[106],"applications,":[107],"datasets,":[108],"hardware).":[110],"Recently,":[111],"many":[112],"learning-based":[113,129],"methods":[116,297,325],"proposed":[118],"alleviate":[120],"those":[121,299],"problems.":[122],"The":[123,190],"<italic":[124,196,201,206,212,219,240,265],"xmlns:mml=\"http://www.w3.org/1998/Math/MathML\"":[125,197,202,207,213,220,241,266],"xmlns:xlink=\"http://www.w3.org/1999/xlink\">core":[126],"idea</i>":[127],"that,":[133],"help":[136,353],"machine":[138],"learning":[139],"techniques,":[140],"reasonable":[143],"collect":[145],"data,":[148],"leverage":[149],"these":[150],"data":[151],"train":[153],"model,":[157],"utilize":[159,308],"model":[162],"recommend":[164],"new":[168,314],"similar":[169],"scenarios,":[170],"so":[171],"as":[172],"achieve":[174],"optimization":[176],"objectives.":[177],"In":[178,287],"this":[179,350],"paper,":[180],"provide":[182,340],"comprehensive":[184],"survey":[185,351],"on":[186],"pipeline":[191],"includes":[195],"xmlns:xlink=\"http://www.w3.org/1999/xlink\">knob":[198,221],"selection</i>":[199,204,222,243],",":[200,205,210,223,244,269],"xmlns:xlink=\"http://www.w3.org/1999/xlink\">feature":[203,242],"xmlns:xlink=\"http://www.w3.org/1999/xlink\">tuning":[208,267],"methods</i>":[209,268],"xmlns:xlink=\"http://www.w3.org/1999/xlink\">transfer":[214],"techniques</i>":[215],".":[216],"introduce":[225,246],"main":[227],"categories":[228],"summarize":[233,290],"existing":[234,252,296,362],"selection":[236,254,259],"algorithms.":[237],"commonly-used":[247],"features":[249],"explain":[251],"feature":[253],"techniques":[255,306],"runtime":[257],"metric":[258],"workload":[261],"encoding).":[262],"compare":[271],"four":[272],"classes":[273],"methods,":[276,279,281,283],"i.e.,":[277],"Bayesian-optimization":[280],"deep-learning":[282],"reinforcement-learning":[285],"methods.":[286],"particular,":[288],"discuss":[294,303,318],"how":[295],"address":[298],"challenges.":[300],"Moreover,":[301],"some":[304,341],"transfer":[305],"historically":[309],"well-trained":[310],"models":[312],"scenarios.":[315],"Fourth,":[316],"implementation":[320],"automatic":[322,374],"typical":[327],"systems":[328],"commercial":[330],"relational":[331],"Big":[334],"Data":[335],"analytics":[336],"systems).":[337],"Lastly,":[338],"research":[342,346],"future":[345],"opportunities.":[347],"We":[348],"believe":[349],"can":[352],"researchers":[354],"better":[355],"understand":[356],"problems":[360,372],"approaches":[363],"further":[365],"encourage":[366],"them":[367],"solve":[369],"remaining":[371]},"counts_by_year":[{"year":2026,"cited_by_count":6},{"year":2025,"cited_by_count":24},{"year":2024,"cited_by_count":16},{"year":2023,"cited_by_count":3}],"updated_date":"2026-07-17T09:13:05.818461","created_date":"2025-10-10T00:00:00"}