{"id":"https://openalex.org/W7140158379","doi":"https://doi.org/10.48550/arxiv.2603.21530","title":"LLM-Based Test Case Generation in DBMS through Monte Carlo Tree Search","display_name":"LLM-Based Test Case Generation in DBMS through Monte Carlo Tree Search","publication_year":2026,"publication_date":"2026-03-23","ids":{"openalex":"https://openalex.org/W7140158379","doi":"https://doi.org/10.48550/arxiv.2603.21530"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2603.21530","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2603.21530","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},"type":"preprint","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.48550/arxiv.2603.21530","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5146695336","display_name":"Yujia Chen","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chen, Yujia","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5056279274","display_name":"Yingli Zhou","orcid":"https://orcid.org/0009-0008-5630-6822"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhou, Yingli","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5146620074","display_name":"Fangyuan Zhang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhang, Fangyuan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5146620149","display_name":"Cuiyun Gao","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Gao, Cuiyun","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10743","display_name":"Software Testing and Debugging Techniques","score":0.5519000291824341,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T10743","display_name":"Software Testing and Debugging Techniques","score":0.5519000291824341,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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.20469999313354492,"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/T12127","display_name":"Software System Performance and Reliability","score":0.039500001817941666,"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/fuzz-testing","display_name":"Fuzz testing","score":0.5777999758720398},{"id":"https://openalex.org/keywords/code-coverage","display_name":"Code coverage","score":0.5576000213623047},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5489000082015991},{"id":"https://openalex.org/keywords/test-case","display_name":"Test case","score":0.5206999778747559},{"id":"https://openalex.org/keywords/tree","display_name":"Tree (set theory)","score":0.4399999976158142},{"id":"https://openalex.org/keywords/unit-testing","display_name":"Unit testing","score":0.35580000281333923},{"id":"https://openalex.org/keywords/abstract-syntax-tree","display_name":"Abstract syntax tree","score":0.3386000096797943},{"id":"https://openalex.org/keywords/model-based-testing","display_name":"Model-based testing","score":0.32839998602867126}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8385999798774719},{"id":"https://openalex.org/C111065885","wikidata":"https://www.wikidata.org/wiki/Q1189053","display_name":"Fuzz testing","level":3,"score":0.5777999758720398},{"id":"https://openalex.org/C53942775","wikidata":"https://www.wikidata.org/wiki/Q1211721","display_name":"Code coverage","level":3,"score":0.5576000213623047},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5489000082015991},{"id":"https://openalex.org/C128942645","wikidata":"https://www.wikidata.org/wiki/Q1568346","display_name":"Test case","level":3,"score":0.5206999778747559},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5141000151634216},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.4399999976158142},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.43470001220703125},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.37130001187324524},{"id":"https://openalex.org/C148027188","wikidata":"https://www.wikidata.org/wiki/Q907375","display_name":"Unit testing","level":3,"score":0.35580000281333923},{"id":"https://openalex.org/C58646249","wikidata":"https://www.wikidata.org/wiki/Q127380","display_name":"Abstract syntax tree","level":3,"score":0.3386000096797943},{"id":"https://openalex.org/C165825675","wikidata":"https://www.wikidata.org/wiki/Q1399743","display_name":"Model-based testing","level":4,"score":0.32839998602867126},{"id":"https://openalex.org/C19499675","wikidata":"https://www.wikidata.org/wiki/Q232207","display_name":"Monte Carlo method","level":2,"score":0.2935999929904938},{"id":"https://openalex.org/C46149586","wikidata":"https://www.wikidata.org/wiki/Q11785332","display_name":"Monte Carlo tree search","level":3,"score":0.2935999929904938},{"id":"https://openalex.org/C199519371","wikidata":"https://www.wikidata.org/wiki/Q942695","display_name":"Source lines of code","level":3,"score":0.2930999994277954},{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.2921000123023987},{"id":"https://openalex.org/C43126263","wikidata":"https://www.wikidata.org/wiki/Q128751","display_name":"Source code","level":2,"score":0.28999999165534973},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.28999999165534973},{"id":"https://openalex.org/C107683887","wikidata":"https://www.wikidata.org/wiki/Q782466","display_name":"Integration testing","level":3,"score":0.2879999876022339},{"id":"https://openalex.org/C16910744","wikidata":"https://www.wikidata.org/wiki/Q7705759","display_name":"Test data","level":2,"score":0.28700000047683716},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.2797999978065491},{"id":"https://openalex.org/C151552104","wikidata":"https://www.wikidata.org/wiki/Q7705809","display_name":"Test suite","level":4,"score":0.26489999890327454},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.26440000534057617},{"id":"https://openalex.org/C2776401178","wikidata":"https://www.wikidata.org/wiki/Q12050496","display_name":"Feature (linguistics)","level":2,"score":0.262800008058548},{"id":"https://openalex.org/C2779639559","wikidata":"https://www.wikidata.org/wiki/Q7661178","display_name":"Symbolic execution","level":3,"score":0.25780001282691956}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2603.21530","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2603.21530","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"doi:10.48550/arxiv.2603.21530","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2603.21530","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},"sustainable_development_goals":[{"score":0.645591676235199,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Database":[0],"Management":[1],"Systems":[2],"(DBMSs)":[3],"are":[4,69,95],"fundamental":[5],"infrastructure":[6],"for":[7,21,33,54,88,124,164],"modern":[8],"data-driven":[9],"applications,":[10],"where":[11],"thorough":[12],"testing":[13],"with":[14,205,234],"high-quality":[15],"SQL":[16,56,90],"test":[17,57,120],"cases":[18],"is":[19],"essential":[20],"ensuring":[22],"system":[23],"reliability.":[24],"Traditional":[25],"approaches":[26],"such":[27],"as":[28],"fuzzing":[29],"can":[30],"be":[31],"effective":[32],"specific":[34],"DBMSs,":[35],"but":[36,59,80],"adapting":[37],"them":[38],"to":[39,75,83,151,156,230],"different":[40,165],"proprietary":[41,89],"dialects":[42],"requires":[43],"substantial":[44],"manual":[45],"effort.":[46],"Large":[47],"Language":[48],"Models":[49],"(LLMs)":[50],"present":[51],"promising":[52],"opportunities":[53],"automated":[55],"generation,":[58,154],"face":[60],"critical":[61],"challenges":[62],"in":[63,72,217,221,226,241],"industrial":[64],"environments.":[65],"First,":[66],"lightweight":[67,207],"models":[68],"widely":[70],"used":[71],"organizations":[73],"due":[74],"security":[76],"and":[77,99,147,160,168,182,224],"privacy":[78],"constraints,":[79],"they":[81],"struggle":[82],"generate":[84],"syntactically":[85,158],"valid":[86,159],"queries":[87,94,163],"dialects.":[91],"Second,":[92],"LLM-generated":[93],"often":[96],"semantically":[97,161],"similar":[98],"exercise":[100],"only":[101],"shallow":[102],"execution":[103,198],"paths,":[104],"thereby":[105],"quickly":[106],"reaching":[107],"a":[108,143],"coverage":[109,188,194,228,238],"plateau.":[110],"To":[111],"address":[112],"these":[113],"challenges,":[114],"we":[115],"propose":[116],"MIST,":[117],"an":[118],"LLM-based":[119],"case":[121],"generatIon":[122],"framework":[123],"DBMS":[125,166],"through":[126],"Monte":[127,169],"Carlo":[128,170],"Tree":[129,171],"search.":[130],"MIST":[131,211],"consists":[132],"of":[133,215,239],"two":[134],"stages:":[135],"Feature-Guided":[136],"Error-Driven":[137],"Test":[138,173],"Case":[139,174],"Synthetization,":[140],"which":[141,176],"constructs":[142],"hierarchical":[144],"feature":[145],"tree":[146],"uses":[148],"error":[149],"feedback":[150],"guide":[152],"LLM":[153],"aiming":[155,190],"produce":[157],"diverse":[162],"dialects,":[167],"Search-Based":[172],"Mutation,":[175],"jointly":[177],"optimizes":[178],"seed":[179],"query":[180],"selection":[181],"mutation":[183],"rule":[184],"application":[185],"guided":[186],"by":[187,195],"feedback,":[189],"at":[191],"boosting":[192],"code":[193],"exploring":[196],"deeper":[197],"paths.":[199],"Experiments":[200],"on":[201],"three":[202],"widely-used":[203],"DBMSs":[204],"four":[206],"LLMs":[208],"show":[209],"that":[210],"achieves":[212],"average":[213],"improvements":[214],"43.3%":[216],"line":[218,237],"coverage,":[219,223],"32.3%":[220],"function":[222],"46.4%":[225],"branch":[227],"compared":[229],"the":[231,235,242],"baseline":[232],"approach":[233],"highest":[236],"69.3%":[240],"Optimizer":[243],"module.":[244]},"counts_by_year":[],"updated_date":"2026-08-12T21:12:35.861297","created_date":"2026-03-25T00:00:00"}