{"id":"https://openalex.org/W4414020789","doi":"https://doi.org/10.1177/0926227x251370258","title":"SQLaser: Detecting database management system (DBMS) logic bugs with clause-guided fuzzing","display_name":"SQLaser: Detecting database management system (DBMS) logic bugs with clause-guided fuzzing","publication_year":2025,"publication_date":"2025-09-05","ids":{"openalex":"https://openalex.org/W4414020789","doi":"https://doi.org/10.1177/0926227x251370258"},"language":"en","primary_location":{"id":"doi:10.1177/0926227x251370258","is_oa":false,"landing_page_url":"https://doi.org/10.1177/0926227x251370258","pdf_url":null,"source":{"id":"https://openalex.org/S106992369","display_name":"Journal of Computer Security","issn_l":"0926-227X","issn":["0926-227X","1875-8924"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Computer Security","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/A5051463871","display_name":"Wei Jin","orcid":"https://orcid.org/0000-0001-7534-9598"},"institutions":[{"id":"https://openalex.org/I24943067","display_name":"Fudan University","ror":"https://ror.org/013q1eq08","country_code":"CN","type":"education","lineage":["https://openalex.org/I24943067"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jin Wei","raw_affiliation_strings":["Institute of Big\u00a0Data, Fudan University, Shanghai, China","School of Computer Science, Fudan University, Shanghai, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Big\u00a0Data, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]},{"raw_affiliation_string":"School of Computer Science, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102000233","display_name":"Ping Chen","orcid":"https://orcid.org/0000-0002-8517-0580"},"institutions":[{"id":"https://openalex.org/I24943067","display_name":"Fudan University","ror":"https://ror.org/013q1eq08","country_code":"CN","type":"education","lineage":["https://openalex.org/I24943067"]},{"id":"https://openalex.org/I4210155350","display_name":"Purple Mountain Laboratories","ror":"https://ror.org/04zcbk583","country_code":"CN","type":"facility","lineage":["https://openalex.org/I4210155350"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Ping Chen","raw_affiliation_strings":["Institute of Big\u00a0Data, Fudan University, Shanghai, China","Purple Mountain Laboratories, Nanjing, China"],"raw_orcid":"https://orcid.org/0000-0002-8517-0580","affiliations":[{"raw_affiliation_string":"Institute of Big\u00a0Data, Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]},{"raw_affiliation_string":"Purple Mountain Laboratories, Nanjing, China","institution_ids":["https://openalex.org/I4210155350"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043198742","display_name":"Kangjie Lu","orcid":"https://orcid.org/0000-0002-4763-7354"},"institutions":[{"id":"https://openalex.org/I130238516","display_name":"University of Minnesota","ror":"https://ror.org/017zqws13","country_code":"US","type":"education","lineage":["https://openalex.org/I130238516"]},{"id":"https://openalex.org/I4210101327","display_name":"Twin Cities Orthopedics","ror":"https://ror.org/01en4s460","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I4210101327"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kangjie Lu","raw_affiliation_strings":["University of Minnesota Twin Cities, Minneapolis, MN, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Minnesota Twin Cities, Minneapolis, MN, USA","institution_ids":["https://openalex.org/I130238516","https://openalex.org/I4210101327"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084217251","display_name":"Jun Dai","orcid":"https://orcid.org/0000-0002-6890-6429"},"institutions":[{"id":"https://openalex.org/I107077323","display_name":"Worcester Polytechnic Institute","ror":"https://ror.org/05ejpqr48","country_code":"US","type":"education","lineage":["https://openalex.org/I107077323"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jun Dai","raw_affiliation_strings":["Worcester Polytechnic Institute, Worcester, MA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Worcester Polytechnic Institute, Worcester, MA, USA","institution_ids":["https://openalex.org/I107077323"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5102217331","display_name":"Xiaoyan Sun","orcid":null},"institutions":[{"id":"https://openalex.org/I107077323","display_name":"Worcester Polytechnic Institute","ror":"https://ror.org/05ejpqr48","country_code":"US","type":"education","lineage":["https://openalex.org/I107077323"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xiaoyan Sun","raw_affiliation_strings":["Worcester Polytechnic Institute, Worcester, MA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Worcester Polytechnic Institute, Worcester, MA, USA","institution_ids":["https://openalex.org/I107077323"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5102000233"],"corresponding_institution_ids":["https://openalex.org/I24943067","https://openalex.org/I4210155350"],"apc_list":null,"apc_paid":null,"fwci":1.1762,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.83471074,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":97},"biblio":{"volume":"34","issue":"1","first_page":"3","last_page":"28"},"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.9997000098228455,"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.9997000098228455,"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/T12127","display_name":"Software System Performance and Reliability","score":0.9994000196456909,"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/T12479","display_name":"Web Application Security Vulnerabilities","score":0.9980999827384949,"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/fuzz-testing","display_name":"Fuzz testing","score":0.8183020353317261},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7802126407623291},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6700185537338257},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.48386991024017334},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.10501214861869812}],"concepts":[{"id":"https://openalex.org/C111065885","wikidata":"https://www.wikidata.org/wiki/Q1189053","display_name":"Fuzz testing","level":3,"score":0.8183020353317261},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7802126407623291},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6700185537338257},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.48386991024017334},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.10501214861869812}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1177/0926227x251370258","is_oa":false,"landing_page_url":"https://doi.org/10.1177/0926227x251370258","pdf_url":null,"source":{"id":"https://openalex.org/S106992369","display_name":"Journal of Computer Security","issn_l":"0926-227X","issn":["0926-227X","1875-8924"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Computer Security","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":38,"referenced_works":["https://openalex.org/W109452506","https://openalex.org/W2099525917","https://openalex.org/W2574017551","https://openalex.org/W2741068848","https://openalex.org/W2766540688","https://openalex.org/W2846896781","https://openalex.org/W2891235722","https://openalex.org/W2903039527","https://openalex.org/W2933883078","https://openalex.org/W2947109320","https://openalex.org/W2963764936","https://openalex.org/W2964097210","https://openalex.org/W2982547214","https://openalex.org/W2999244640","https://openalex.org/W3007127028","https://openalex.org/W3015193297","https://openalex.org/W3016185124","https://openalex.org/W3032341945","https://openalex.org/W3042605769","https://openalex.org/W3091620507","https://openalex.org/W3097728505","https://openalex.org/W3098450669","https://openalex.org/W3099032206","https://openalex.org/W3106731144","https://openalex.org/W3106959425","https://openalex.org/W3136108410","https://openalex.org/W3136690412","https://openalex.org/W3139023885","https://openalex.org/W3155065762","https://openalex.org/W3160235602","https://openalex.org/W3173990398","https://openalex.org/W3213182664","https://openalex.org/W4225508598","https://openalex.org/W4284698041","https://openalex.org/W4384305072","https://openalex.org/W4392353733","https://openalex.org/W4399156224","https://openalex.org/W4402264541"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2511770387","https://openalex.org/W3120811337","https://openalex.org/W2766647240","https://openalex.org/W4385301282","https://openalex.org/W2990186179","https://openalex.org/W4210660460","https://openalex.org/W3203597304"],"abstract_inverted_index":{"Database":[0],"management":[1],"systems":[2],"(DBMSs)":[3],"are":[4,19,84,152,286],"vital":[5],"components":[6],"in":[7,108,144],"modern":[8],"data-driven":[9],"systems.":[10],"Their":[11],"complexity":[12],"often":[13],"leads":[14],"to":[15,28,68,86,196,199,227,294],"logic":[16,88,106,116,145,190,262],"bugs,":[17,146],"which":[18,83,258,290],"implementation":[20],"errors":[21],"within":[22,267],"the":[23,248,268,281],"DBMSs":[24],"that":[25,141,220],"can":[26],"lead":[27],"incorrect":[29],"query":[30],"results,":[31],"data":[32],"exposure,":[33],"unauthorized":[34],"access,":[35],"etc.,":[36],"without":[37],"necessarily":[38],"causing":[39,124],"visible":[40],"system":[41,125],"failures.":[42],"Existing":[43],"detection":[44,50,65,232],"employs":[45],"two":[46,261,265],"strategies:":[47],"rule-based":[48,64],"bug":[49,224],"and":[51,70,147,187,202,217,295],"coverage-guided":[52],"fuzzing.":[53],"In":[54,95],"general,":[55],"rule":[56],"specification":[57],"itself":[58],"is":[59,66,93],"challenging;":[60],"as":[61,136,162,256],"a":[62,101,111,153,173,177,238],"result,":[63],"limited":[67],"specific":[69],"simple":[71],"rules.":[72],"Coverage-guided":[73],"fuzzing":[74,229],"blindly":[75],"explores":[76],"code":[77],"paths":[78],"or":[79],"blocks,":[80],"many":[81],"of":[82,114,155,168,247,280,289],"unlikely":[85],"contain":[87],"bugs;":[89],"therefore,":[90],"this":[91,96],"strategy":[92],"cost-ineffective.":[94],"paper,":[97],"we":[98,127],"design":[99],"SQLaser,":[100],"SQL-clause-guided":[102],"fuzzer":[103,175],"for":[104,182],"detecting":[105],"bugs":[107,117,205,244,263,282],"DBMSs.":[109],"Through":[110],"comprehensive":[112],"examination":[113],"existing":[115],"across":[118,264],"four":[119,279],"distinct":[120],"DBMSs,":[121],"excluding":[122],"those":[123],"crashes,":[126],"have":[128,291],"identified":[129,242],"35":[130,249],"logic-bug":[131,160,250],"patterns.":[132],"These":[133],"patterns":[134,161,266],"manifest":[135],"certain":[137],"SQL":[138],"clause":[139,150],"combinations":[140,151],"commonly":[142],"result":[143],"behind":[148],"these":[149,185,208],"sequence":[154],"functions.":[156],"We":[157,170],"therefore":[158],"model":[159],"error-prone":[163],"function":[164],"chains":[165,186],"(i.e.,":[166,272],"sequences":[167],"functions).":[169],"further":[171],"develop":[172],"directed":[174],"with":[176],"new":[178],"path-to-path":[179],"distance-calculation":[180],"mechanism":[181,193],"effectively":[183],"testing":[184,270,276],"discovering":[188],"additional":[189],"bugs.":[191],"This":[192],"enables":[194],"SQLaser":[195,221,241,285],"swiftly":[197],"navigate":[198],"target":[200],"sites":[201],"uncover":[203],"potential":[204],"emerging":[206],"from":[207],"paths.":[209],"Our":[210],"evaluation,":[211],"conducted":[212],"on":[213],"SQLite,":[214],"MySQL,":[215],"PostgreSQL,":[216],"TiDB,":[218],"demonstrates":[219],"significantly":[222],"accelerates":[223],"discovery":[225],"compared":[226],"other":[228],"approaches,":[230],"reducing":[231],"time":[233],"by":[234,284,297],"approximately":[235],"60%.":[236],"As":[237],"standalone":[239],"fuzzer,":[240],"22":[243],"spanning":[245],"18":[246],"patterns,":[251],"outperforming":[252],"contemporary":[253],"fuzzers":[254],"such":[255],"SQLRight,":[257],"only":[259],"uncovered":[260],"same":[269],"period":[271],"60":[273],"days)":[274],"when":[275],"SQLite.":[277],"Notably,":[278],"discovered":[283],"zero-day,":[287],"all":[288],"been":[292],"reported":[293],"confirmed":[296],"vendors.":[298]},"counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-07-22T07:51:19.307946","created_date":"2025-10-10T00:00:00"}