{"id":"https://openalex.org/W4409920225","doi":"https://doi.org/10.1145/3733620.3733641","title":"GPTuner: An LLM-Based Database Tuning System","display_name":"GPTuner: An LLM-Based Database Tuning System","publication_year":2025,"publication_date":"2025-04-28","ids":{"openalex":"https://openalex.org/W4409920225","doi":"https://doi.org/10.1145/3733620.3733641"},"language":"en","primary_location":{"id":"doi:10.1145/3733620.3733641","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3733620.3733641","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"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":"ACM SIGMOD Record","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/A5044736090","display_name":"Jiale Lao","orcid":null},"institutions":[{"id":"https://openalex.org/I24185976","display_name":"Sichuan University","ror":"https://ror.org/011ashp19","country_code":"CN","type":"education","lineage":["https://openalex.org/I24185976"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Jiale Lao","raw_affiliation_strings":["Sichuan University"],"affiliations":[{"raw_affiliation_string":"Sichuan University","institution_ids":["https://openalex.org/I24185976"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103147568","display_name":"Yibo Wang","orcid":"https://orcid.org/0009-0005-1971-3398"},"institutions":[{"id":"https://openalex.org/I24185976","display_name":"Sichuan University","ror":"https://ror.org/011ashp19","country_code":"CN","type":"education","lineage":["https://openalex.org/I24185976"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yibo Wang","raw_affiliation_strings":["Sichuan University"],"affiliations":[{"raw_affiliation_string":"Sichuan University","institution_ids":["https://openalex.org/I24185976"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5026638097","display_name":"Yufei Li","orcid":"https://orcid.org/0009-0004-4285-5696"},"institutions":[{"id":"https://openalex.org/I24185976","display_name":"Sichuan University","ror":"https://ror.org/011ashp19","country_code":"CN","type":"education","lineage":["https://openalex.org/I24185976"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yufei Li","raw_affiliation_strings":["Sichuan University"],"affiliations":[{"raw_affiliation_string":"Sichuan University","institution_ids":["https://openalex.org/I24185976"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100356291","display_name":"Jianping Wang","orcid":"https://orcid.org/0000-0002-9318-1482"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]},{"id":"https://openalex.org/I68986083","display_name":"Northwest Normal University","ror":"https://ror.org/00gx3j908","country_code":"CN","type":"education","lineage":["https://openalex.org/I68986083"]}],"countries":["CN","US"],"is_corresponding":false,"raw_author_name":"Jianping Wang","raw_affiliation_strings":["Northwest Normal University","Purdue University"],"affiliations":[{"raw_affiliation_string":"Northwest Normal University","institution_ids":["https://openalex.org/I68986083"]},{"raw_affiliation_string":"Purdue University","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010380683","display_name":"Yunjia Zhang","orcid":"https://orcid.org/0009-0001-7157-156X"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yunjia Zhang","raw_affiliation_strings":["University of Wisconsin-Madison"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103082481","display_name":"Zhiyuan Cheng","orcid":"https://orcid.org/0000-0002-0874-9572"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zhiyuan Cheng","raw_affiliation_strings":["Purdue University"],"affiliations":[{"raw_affiliation_string":"Purdue University","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5046558187","display_name":"Wanghu Chen","orcid":"https://orcid.org/0000-0002-9233-7609"},"institutions":[{"id":"https://openalex.org/I68986083","display_name":"Northwest Normal University","ror":"https://ror.org/00gx3j908","country_code":"CN","type":"education","lineage":["https://openalex.org/I68986083"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Wanghu Chen","raw_affiliation_strings":["Northwest Normal University"],"affiliations":[{"raw_affiliation_string":"Northwest Normal University","institution_ids":["https://openalex.org/I68986083"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101512458","display_name":"Mingjie Tang","orcid":"https://orcid.org/0000-0002-8893-4574"},"institutions":[{"id":"https://openalex.org/I24185976","display_name":"Sichuan University","ror":"https://ror.org/011ashp19","country_code":"CN","type":"education","lineage":["https://openalex.org/I24185976"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Mingjie Tang","raw_affiliation_strings":["Sichuan University"],"affiliations":[{"raw_affiliation_string":"Sichuan University","institution_ids":["https://openalex.org/I24185976"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100336334","display_name":"Jianguo Wang","orcid":"https://orcid.org/0000-0002-4935-9116"},"institutions":[{"id":"https://openalex.org/I68986083","display_name":"Northwest Normal University","ror":"https://ror.org/00gx3j908","country_code":"CN","type":"education","lineage":["https://openalex.org/I68986083"]},{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["CN","US"],"is_corresponding":false,"raw_author_name":"Jianguo Wang","raw_affiliation_strings":["Northwest Normal University","Purdue University"],"affiliations":[{"raw_affiliation_string":"Northwest Normal University","institution_ids":["https://openalex.org/I68986083"]},{"raw_affiliation_string":"Purdue University","institution_ids":["https://openalex.org/I219193219"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":9,"corresponding_author_ids":["https://openalex.org/A5044736090"],"corresponding_institution_ids":["https://openalex.org/I24185976"],"apc_list":null,"apc_paid":null,"fwci":11.1911,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.97922821,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":"54","issue":"1","first_page":"101","last_page":"110"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12535","display_name":"Machine Learning and Data Classification","score":0.9977999925613403,"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"}},"topics":[{"id":"https://openalex.org/T12535","display_name":"Machine Learning and Data Classification","score":0.9977999925613403,"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.9976999759674072,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9966999888420105,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8287679553031921},{"id":"https://openalex.org/keywords/bayesian-optimization","display_name":"Bayesian optimization","score":0.7538620233535767},{"id":"https://openalex.org/keywords/pipeline","display_name":"Pipeline (software)","score":0.6283011436462402},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.49342623353004456},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4798523783683777},{"id":"https://openalex.org/keywords/latency","display_name":"Latency (audio)","score":0.45459747314453125},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.45260894298553467},{"id":"https://openalex.org/keywords/domain-knowledge","display_name":"Domain knowledge","score":0.4504918158054352},{"id":"https://openalex.org/keywords/design-space-exploration","display_name":"Design space exploration","score":0.43555495142936707},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3728630542755127},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.34637004137039185},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.2946746349334717},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.10532733798027039},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.09419789910316467}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8287679553031921},{"id":"https://openalex.org/C2778049539","wikidata":"https://www.wikidata.org/wiki/Q17002908","display_name":"Bayesian optimization","level":2,"score":0.7538620233535767},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.6283011436462402},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.49342623353004456},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4798523783683777},{"id":"https://openalex.org/C82876162","wikidata":"https://www.wikidata.org/wiki/Q17096504","display_name":"Latency (audio)","level":2,"score":0.45459747314453125},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.45260894298553467},{"id":"https://openalex.org/C207685749","wikidata":"https://www.wikidata.org/wiki/Q2088941","display_name":"Domain knowledge","level":2,"score":0.4504918158054352},{"id":"https://openalex.org/C2776221188","wikidata":"https://www.wikidata.org/wiki/Q21072556","display_name":"Design space exploration","level":2,"score":0.43555495142936707},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3728630542755127},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.34637004137039185},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2946746349334717},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.10532733798027039},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.09419789910316467},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3733620.3733641","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3733620.3733641","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"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":"ACM SIGMOD Record","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.7300000190734863,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":38,"referenced_works":["https://openalex.org/W1934084512","https://openalex.org/W1992801522","https://openalex.org/W2100218206","https://openalex.org/W2105636195","https://openalex.org/W2112474496","https://openalex.org/W2131241448","https://openalex.org/W2240667924","https://openalex.org/W2613206411","https://openalex.org/W2760770811","https://openalex.org/W2948513753","https://openalex.org/W2970992672","https://openalex.org/W3007086929","https://openalex.org/W3098844916","https://openalex.org/W3104631761","https://openalex.org/W3139827290","https://openalex.org/W3165341913","https://openalex.org/W3174969457","https://openalex.org/W3198839277","https://openalex.org/W3203329898","https://openalex.org/W4211116959","https://openalex.org/W4221062824","https://openalex.org/W4281753793","https://openalex.org/W4281972940","https://openalex.org/W4285069940","https://openalex.org/W4288057686","https://openalex.org/W4303648559","https://openalex.org/W4303649020","https://openalex.org/W4312397585","https://openalex.org/W4361230777","https://openalex.org/W4379473936","https://openalex.org/W4385270687","https://openalex.org/W4386768482","https://openalex.org/W4387324006","https://openalex.org/W4398234929","https://openalex.org/W4399208444","https://openalex.org/W4399208468","https://openalex.org/W6733403177","https://openalex.org/W6845478269"],"related_works":["https://openalex.org/W2000785801","https://openalex.org/W986318368","https://openalex.org/W2384410913","https://openalex.org/W2352878646","https://openalex.org/W2004734601","https://openalex.org/W3042858012","https://openalex.org/W2742479298","https://openalex.org/W2619340758","https://openalex.org/W2996372837","https://openalex.org/W4310997605"],"abstract_inverted_index":{"Selecting":[0],"appropriate":[1],"values":[2],"for":[3],"the":[4,19,26,30,34,69,100,105,137,142,162,177,222],"configurable":[5],"knobs":[6],"of":[7,21,28,71,136,165],"Database":[8],"Management":[9],"Systems":[10],"(DBMS)":[11],"is":[12],"essential":[13],"to":[14,38,60,97,119,131,175,200,217],"improve":[15],"performance.":[16],"But":[17],"because":[18],"complexity":[20],"this":[22],"task":[23],"has":[24],"surpassed":[25],"abilities":[27],"even":[29],"best":[31],"human":[32],"experts,":[33],"database":[35,89],"community":[36],"turns":[37],"machine":[39],"learning":[40],"(ML)-":[41],"based":[42],"automatic":[43],"tuning":[44,52,90],"systems.":[45],"However,":[46],"these":[47],"systems":[48],"still":[49],"incur":[50],"significant":[51],"costs":[53],"or":[54],"only":[55],"yield":[56],"suboptimal":[57],"performance,":[58],"attributable":[59],"their":[61],"overly":[62],"high":[63],"reliance":[64],"on":[65,211],"black-box":[66],"optimization":[67,108,159],"and":[68,80,103,121,125,188,192,194,197],"lack":[70],"integration":[72],"with":[73],"domain":[74,95],"knowledge,":[75,124,144],"such":[76],"as":[77],"DBMS":[78,195],"manuals":[79],"forum":[81],"discussions.":[82],"Hence,":[83],"we":[84,111,145,181],"propose":[85,126,169],"GPTuner,":[86],"a":[87,113,127,133,148,156,170],"manual-reading":[88],"system":[91],"that":[92],"extensively":[93],"leverages":[94],"knowledge":[96],"automatically":[98],"optimize":[99],"search":[101,157],"space":[102,158],"enhance":[104],"runtime":[106],"feedback-based":[107],"process.":[109],"Firstly,":[110],"develop":[112,155],"Large":[114],"Language":[115],"Model":[116],"(LLM)-based":[117],"pipeline":[118],"collect":[120],"refine":[122],"heterogeneous":[123],"prompt":[128],"ensemble":[129],"algorithm":[130],"unify":[132],"structured":[134,143],"view":[135],"refined":[138],"knowledge.":[139],"Secondly,":[140],"using":[141],"(1)":[146],"design":[147],"workload-aware,":[149],"trainingfree":[150],"knob":[151],"selection":[152],"strategy,":[153],"(2)":[154],"technique":[160],"considering":[161],"value":[163],"range":[164],"each":[166],"knob,":[167],"(3)":[168],"Coarse-to-Fine":[171],"Bayesian":[172],"Optimization":[173],"Framework":[174],"explore":[176],"optimized":[178],"space.":[179],"Finally,":[180],"evaluate":[182],"GPTuner":[183,203,214],"under":[184],"different":[185],"benchmarks":[186],"(TPC-C":[187],"TPC-H),":[189],"metrics":[190],"(throughput":[191],"latency)":[193],"(PostgreSQL":[196],"MySQL).":[198],"Compared":[199],"state-of-the-art":[201],"methods,":[202],"identifies":[204],"better":[205],"configurations":[206],"in":[207],"16x":[208],"less":[209],"time":[210],"average.":[212],"Moreover,":[213],"achieves":[215],"up":[216],"30%":[218],"performance":[219],"improvement":[220],"over":[221],"best-performing":[223],"alternative.":[224]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3}],"updated_date":"2026-03-09T08:58:05.943551","created_date":"2025-10-10T00:00:00"}