{"id":"https://openalex.org/W4399208444","doi":"https://doi.org/10.14778/3659437.3659449","title":"GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization","display_name":"GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization","publication_year":2024,"publication_date":"2024-04-01","ids":{"openalex":"https://openalex.org/W4399208444","doi":"https://doi.org/10.14778/3659437.3659449"},"language":"en","primary_location":{"id":"doi:10.14778/3659437.3659449","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3659437.3659449","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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 VLDB Endowment","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/A5026461715","display_name":"Yunjia Zhang","orcid":"https://orcid.org/0000-0002-8067-3592"},"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/A5102006509","display_name":"Mingjie Tang","orcid":"https://orcid.org/0009-0008-5012-5035"},"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/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":"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":13.1126,"has_fulltext":false,"cited_by_count":37,"citation_normalized_percentile":{"value":0.99008929,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":97,"max":100},"biblio":{"volume":"17","issue":"8","first_page":"1939","last_page":"1952"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12761","display_name":"Data Stream Mining Techniques","score":0.9994000196456909,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9994000196456909,"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.9965999722480774,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9939000010490417,"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.833710789680481},{"id":"https://openalex.org/keywords/bayesian-optimization","display_name":"Bayesian optimization","score":0.6468476057052612},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.5245316624641418},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5049734711647034},{"id":"https://openalex.org/keywords/pipeline","display_name":"Pipeline (software)","score":0.495126873254776},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4931573271751404},{"id":"https://openalex.org/keywords/domain-knowledge","display_name":"Domain knowledge","score":0.44483324885368347},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.4421784579753876},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.4045239984989166},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.39399921894073486},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.37815406918525696},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.08622723817825317}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.833710789680481},{"id":"https://openalex.org/C2778049539","wikidata":"https://www.wikidata.org/wiki/Q17002908","display_name":"Bayesian optimization","level":2,"score":0.6468476057052612},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5245316624641418},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5049734711647034},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.495126873254776},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4931573271751404},{"id":"https://openalex.org/C207685749","wikidata":"https://www.wikidata.org/wiki/Q2088941","display_name":"Domain knowledge","level":2,"score":0.44483324885368347},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.4421784579753876},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.4045239984989166},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.39399921894073486},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.37815406918525696},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.08622723817825317},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3659437.3659449","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3659437.3659449","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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 VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.7300000190734863}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":36,"referenced_works":["https://openalex.org/W2112474496","https://openalex.org/W2542459869","https://openalex.org/W2584555500","https://openalex.org/W2750779823","https://openalex.org/W2789758093","https://openalex.org/W2790634852","https://openalex.org/W2914761779","https://openalex.org/W2914906769","https://openalex.org/W2915048431","https://openalex.org/W2915063781","https://openalex.org/W2970851599","https://openalex.org/W2970992672","https://openalex.org/W3139827290","https://openalex.org/W3146953485","https://openalex.org/W3165341913","https://openalex.org/W3198839277","https://openalex.org/W3199199693","https://openalex.org/W3203329898","https://openalex.org/W3208735199","https://openalex.org/W4232456446","https://openalex.org/W4237498818","https://openalex.org/W4285045050","https://openalex.org/W4285306484","https://openalex.org/W4285451014","https://openalex.org/W4286447321","https://openalex.org/W4286970057","https://openalex.org/W4288057686","https://openalex.org/W4312397585","https://openalex.org/W4321448364","https://openalex.org/W4366504025","https://openalex.org/W4386768482","https://openalex.org/W4388221277","https://openalex.org/W4390626539","https://openalex.org/W4398235079","https://openalex.org/W6733403177","https://openalex.org/W6748328607"],"related_works":["https://openalex.org/W2378211422","https://openalex.org/W2745001401","https://openalex.org/W4321353415","https://openalex.org/W2130974462","https://openalex.org/W2028665553","https://openalex.org/W2086519370","https://openalex.org/W1583422155","https://openalex.org/W1649619740","https://openalex.org/W3213252596","https://openalex.org/W1534006406"],"abstract_inverted_index":{"Modern":[0],"database":[1,31,129],"management":[2],"systems":[3,60],"(DBMS)":[4],"expose":[5],"hundreds":[6],"of":[7,39,106,176,206],"configurable":[8],"knobs":[9,20,40],"to":[10,21,41,109,139,159,171,217,244,262],"control":[11],"system":[12,131],"behaviours.":[13],"Determining":[14],"the":[15,30,88,103,111,116,145,177,182,203,219,245,272],"appropriate":[16],"values":[17],"for":[18],"these":[19],"improve":[22],"DBMS":[23,94,239],"performance":[24,264],"is":[25,35,83],"a":[26,120,127,153,167,173,188,197,212],"long-standing":[27],"problem":[28],"in":[29,48,119,252],"community.":[32],"As":[33],"there":[34],"an":[36],"increasing":[37],"number":[38],"tune":[42],"and":[43,96,99,137,143,161,165,190,209,230,234,241],"each":[44,207],"knob":[45,192],"could":[46],"be":[47],"continuous":[49],"or":[50,77,113,268],"categorical":[51],"values,":[52],"manual":[53],"tuning":[54,59,75,130],"becomes":[55],"impractical.":[56],"Recently,":[57],"automatic":[58],"using":[61,181],"machine":[62],"learning":[63],"methods":[64],"have":[65],"shown":[66],"great":[67],"potentials.":[68],"However,":[69],"existing":[70],"approaches":[71],"still":[72],"incur":[73],"significant":[74],"costs":[76],"only":[78,100],"yield":[79],"sub-optimal":[80],"performance.":[81],"This":[82],"because":[84],"they":[85,114],"either":[86],"ignore":[87],"extensive":[89],"domain":[90,117,134],"knowledge":[91,118,135],"available":[92],"(e.g.,":[93],"manuals":[95],"forum":[97],"discussions)":[98],"rely":[101],"on":[102,256],"runtime":[104,146],"feedback":[105],"benchmark":[107],"evaluations":[108],"guide":[110],"optimization,":[112],"utilize":[115],"limited":[121],"way.":[122],"Hence,":[123],"we":[124,151,185,223],"propose":[125,166,211],"GPTuner,":[126],"manual-reading":[128],"that":[132],"leverages":[133],"extensively":[136],"automatically":[138],"optimize":[140],"search":[141,198],"space":[142,199],"enhance":[144],"feedback-based":[147],"optimization":[148,200],"process.":[149],"Firstly,":[150],"develop":[152,196],"Large":[154],"Language":[155],"Model":[156],"(LLM)-based":[157],"pipeline":[158],"collect":[160],"refine":[162],"heterogeneous":[163],"knowledge,":[164,184],"prompt":[168],"ensemble":[169],"algorithm":[170],"unify":[172],"structured":[174,183],"view":[175],"refined":[178],"knowledge.":[179],"Secondly,":[180],"(1)":[186],"design":[187],"workload-aware":[189],"training-free":[191],"selection":[193],"strategy,":[194],"(2)":[195],"technique":[201],"considering":[202],"value":[204],"range":[205],"knob,":[208],"(3)":[210],"Coarse-to-Fine":[213],"Bayesian":[214],"Optimization":[215],"Framework":[216],"explore":[218],"optimized":[220],"space.":[221],"Finally,":[222],"evaluate":[224],"GPTuner":[225,248,259],"under":[226],"different":[227],"benchmarks":[228],"(TPC-C":[229],"TPC-H),":[231],"metrics":[232],"(throughput":[233],"latency)":[235,270],"as":[236,238],"well":[237],"(PostgreSQL":[240],"MySQL).":[242],"Compared":[243],"state-of-the-art":[246],"approaches,":[247],"identifies":[249],"better":[250],"configurations":[251],"16x":[253],"less":[254],"time":[255],"average.":[257],"Moreover,":[258],"achieves":[260],"up":[261],"30%":[263],"improvement":[265],"(higher":[266],"throughput":[267],"lower":[269],"over":[271],"best-performing":[273],"alternative.":[274]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":31},{"year":2024,"cited_by_count":4}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}