{"id":"https://openalex.org/W4417071148","doi":"https://doi.org/10.1145/3769758","title":"AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning","display_name":"AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning","publication_year":2025,"publication_date":"2025-12-04","ids":{"openalex":"https://openalex.org/W4417071148","doi":"https://doi.org/10.1145/3769758"},"language":"en","primary_location":{"id":"doi:10.1145/3769758","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3769758","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","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/A5080646966","display_name":"Y. Li","orcid":"https://orcid.org/0009-0007-2620-7623"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Yiyan Li","raw_affiliation_strings":["Renmin University of China, Beijing, China and Key Laboratory of Data Engineering and Knowledge Engineering, MOE, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China and Key Laboratory of Data Engineering and Knowledge Engineering, MOE, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069391613","display_name":"Haoyang Li","orcid":"https://orcid.org/0000-0002-6610-3841"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Haoyang Li","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101681014","display_name":"Jing Zhang","orcid":"https://orcid.org/0000-0003-2019-225X"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jing Zhang","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034830759","display_name":"Renata Borovica\u2010Gajic","orcid":"https://orcid.org/0000-0003-3503-4123"},"institutions":[{"id":"https://openalex.org/I165779595","display_name":"The University of Melbourne","ror":"https://ror.org/01ej9dk98","country_code":"AU","type":"education","lineage":["https://openalex.org/I165779595"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Renata Borovica-Gajic","raw_affiliation_strings":["University of Melbourne, Melbourne, Australia"],"affiliations":[{"raw_affiliation_string":"University of Melbourne, Melbourne, Australia","institution_ids":["https://openalex.org/I165779595"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100328371","display_name":"Shuai Wang","orcid":"https://orcid.org/0000-0002-5073-3371"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Shuai Wang","raw_affiliation_strings":["ByteDance Inc., Beijing, China"],"affiliations":[{"raw_affiliation_string":"ByteDance Inc., Beijing, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101487889","display_name":"Tieying Zhang","orcid":"https://orcid.org/0009-0003-2250-5528"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Tieying Zhang","raw_affiliation_strings":["ByteDance Inc., San Jose, USA"],"affiliations":[{"raw_affiliation_string":"ByteDance Inc., San Jose, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100410508","display_name":"Jianjun Chen","orcid":"https://orcid.org/0000-0002-3734-892X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jianjun Chen","raw_affiliation_strings":["ByteDance Inc., San Jose, USA"],"affiliations":[{"raw_affiliation_string":"ByteDance Inc., San Jose, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101785595","display_name":"Rui Shi","orcid":"https://orcid.org/0009-0003-9122-4703"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Rui Shi","raw_affiliation_strings":["ByteDance Inc., Beijing, China"],"affiliations":[{"raw_affiliation_string":"ByteDance Inc., Beijing, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100619237","display_name":"Cuiping Li","orcid":"https://orcid.org/0000-0003-0089-1045"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Cuiping Li","raw_affiliation_strings":["Renmin University of China, Beijing, China and Engineering Research Center of Database and Business Intelligence, MOE, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China and Engineering Research Center of Database and Business Intelligence, MOE, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100420391","display_name":"Hong Chen","orcid":"https://orcid.org/0000-0001-8132-9382"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Hong Chen","raw_affiliation_strings":["Renmin University of China, Beijing, China and Key Laboratory of Data Engineering and Knowledge Engineering, MOE, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China and Key Laboratory of Data Engineering and Knowledge Engineering, MOE, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":10,"corresponding_author_ids":["https://openalex.org/A5080646966"],"corresponding_institution_ids":["https://openalex.org/I78988378"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.43870551,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"3","issue":"6","first_page":"1","last_page":"29"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.6650000214576721,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.6650000214576721,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.11389999836683273,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11719","display_name":"Data Quality and Management","score":0.02969999983906746,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.7972999811172485},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.6294000148773193},{"id":"https://openalex.org/keywords/reliability","display_name":"Reliability (semiconductor)","score":0.47999998927116394},{"id":"https://openalex.org/keywords/crash","display_name":"Crash","score":0.4593999981880188},{"id":"https://openalex.org/keywords/latency","display_name":"Latency (audio)","score":0.41690000891685486},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.40299999713897705}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8629999756813049},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.7972999811172485},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.6294000148773193},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5353000164031982},{"id":"https://openalex.org/C43214815","wikidata":"https://www.wikidata.org/wiki/Q7310987","display_name":"Reliability (semiconductor)","level":3,"score":0.47999998927116394},{"id":"https://openalex.org/C183469790","wikidata":"https://www.wikidata.org/wiki/Q333501","display_name":"Crash","level":2,"score":0.4593999981880188},{"id":"https://openalex.org/C82876162","wikidata":"https://www.wikidata.org/wiki/Q17096504","display_name":"Latency (audio)","level":2,"score":0.41690000891685486},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.40299999713897705},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3483000099658966},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3269999921321869},{"id":"https://openalex.org/C2778572836","wikidata":"https://www.wikidata.org/wiki/Q380933","display_name":"Space (punctuation)","level":2,"score":0.3142000138759613},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.2930000126361847},{"id":"https://openalex.org/C137293760","wikidata":"https://www.wikidata.org/wiki/Q3621696","display_name":"Language model","level":2,"score":0.271699994802475},{"id":"https://openalex.org/C51632099","wikidata":"https://www.wikidata.org/wiki/Q3985153","display_name":"Training set","level":2,"score":0.2678000032901764},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.2671999931335449},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.258899986743927},{"id":"https://openalex.org/C18762648","wikidata":"https://www.wikidata.org/wiki/Q42213","display_name":"Work (physics)","level":2,"score":0.2572000026702881},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.25699999928474426}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3769758","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3769758","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":45,"referenced_works":["https://openalex.org/W1992801522","https://openalex.org/W2100233978","https://openalex.org/W2112474496","https://openalex.org/W2123779036","https://openalex.org/W2125484876","https://openalex.org/W2135046866","https://openalex.org/W2396309311","https://openalex.org/W2396635388","https://openalex.org/W2613206411","https://openalex.org/W2760770811","https://openalex.org/W2919290281","https://openalex.org/W2964045208","https://openalex.org/W2966185412","https://openalex.org/W2970851599","https://openalex.org/W3085924233","https://openalex.org/W3139827290","https://openalex.org/W3168955346","https://openalex.org/W3174969457","https://openalex.org/W3198839277","https://openalex.org/W4221062824","https://openalex.org/W4226086155","https://openalex.org/W4226287673","https://openalex.org/W4246649926","https://openalex.org/W4281753793","https://openalex.org/W4281972940","https://openalex.org/W4283326127","https://openalex.org/W4288057686","https://openalex.org/W4289533904","https://openalex.org/W4312397585","https://openalex.org/W4366504025","https://openalex.org/W4382202531","https://openalex.org/W4386794445","https://openalex.org/W4388585881","https://openalex.org/W4390268206","https://openalex.org/W4391054929","https://openalex.org/W4392867188","https://openalex.org/W4395022582","https://openalex.org/W4396571402","https://openalex.org/W4399208444","https://openalex.org/W4401352024","https://openalex.org/W4402012962","https://openalex.org/W4402043038","https://openalex.org/W4403324134","https://openalex.org/W4406880389","https://openalex.org/W4407390556"],"related_works":[],"abstract_inverted_index":{"Database":[0],"knob":[1,111,190],"tuning":[2,79,112,126,246],"is":[3,35,227],"a":[4,144,177],"long-standing":[5],"challenge":[6],"in":[7],"the":[8,14,99,108,125,157,171,184,245],"database":[9,17,216],"community,":[10],"aimed":[11],"at":[12],"enhancing":[13],"performance":[15,95],"of":[16,67],"management":[18],"systems":[19],"(DBMSs)":[20],"by":[21,115],"minimizing":[22],"latency":[23],"and":[24,38,56,121,138,164,187,201,206,211,215,250],"maximizing":[25],"throughput.":[26],"Manual":[27],"tuning,":[28],"which":[29],"relies":[30],"heavily":[31],"on":[32,72],"human":[33],"expertise,":[34],"often":[36],"inefficient":[37],"impractical":[39],"for":[40,118,143,252],"large-scale":[41],"or":[42,70,81,96],"dynamic":[43],"deployments.":[44,254],"Recent":[45],"work":[46],"has":[47],"explored":[48],"automating":[49],"this":[50],"process":[51,127],"using":[52,233],"machine":[53],"learning":[54],"(ML)":[55],"large":[57],"language":[58],"models":[59],"(LLMs).":[60],"However,":[61],"existing":[62,224],"methods":[63],"typically":[64],"require":[65],"hundreds":[66],"workload":[68,159,236],"replays":[69],"rely":[71],"extensive":[73,194],"training":[74],"data,":[75],"leading":[76],"to":[77,160,169,181,223,229],"low":[78],"efficiency":[80],"high":[82],"preparation":[83],"costs.":[84],"Moreover,":[85],"they":[86],"also":[87],"risk":[88],"generating":[89],"invalid":[90,242],"configurations":[91,232,243],"that":[92],"can":[93],"degrade":[94],"even":[97],"crash":[98],"database.":[100],"To":[101],"address":[102],"these":[103],"limitations,":[104],"we":[105],"introduce":[106],"AgentTune,":[107],"first":[109,155],"agent-based":[110],"framework":[113],"powered":[114],"LLMs,":[116],"designed":[117],"efficiency,":[119],"adaptability,":[120],"reliability.":[122],"AgentTune":[123,154,226,239],"decomposes":[124],"into":[128],"four":[129],"specialized":[130],"agents:":[131],"Workload":[132],"Analyzer,":[133],"Knob":[134],"Selector,":[135],"Range":[136],"Pruner,":[137],"Configuration":[139],"Recommender,":[140],"each":[141],"responsible":[142],"distinct":[145],"subtask.":[146],"These":[147],"agents":[148],"collaborate":[149],"through":[150],"structured":[151],"prompt":[152],"chaining.":[153],"analyzes":[156],"input":[158],"identify":[161,188,230],"impactful":[162],"knobs":[163],"reconstructs":[165],"their":[166],"valid":[167],"ranges":[168],"reduce":[170],"search":[172,179],"space.":[173],"It":[174],"then":[175],"employs":[176],"tree-based":[178],"strategy":[180],"efficiently":[182],"explore":[183],"configuration":[185],"space":[186],"suitable":[189],"values.":[191],"We":[192],"conduct":[193],"evaluations":[195],"across":[196],"diverse":[197],"workloads":[198],"(public":[199],"benchmarks":[200],"real-world":[202,253],"workloads),":[203],"metrics":[204],"(latency":[205],"throughput),":[207],"DBMSs":[208],"(PostgreSQL,":[209],"MySQL,":[210],"TiDB),":[212],"hardware":[213],"environments,":[214],"scales.":[217],"Experimental":[218],"results":[219],"demonstrate":[220],"that,":[221],"compared":[222],"baselines,":[225],"able":[228],"superior":[231],"significantly":[234],"fewer":[235],"replays.":[237],"Furthermore,":[238],"rarely":[240],"generates":[241],"during":[244],"process,":[247],"ensuring":[248],"reliability":[249],"suitability":[251]},"counts_by_year":[],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-12-06T00:00:00"}
