{"id":"https://openalex.org/W4415743509","doi":"https://doi.org/10.1109/tse.2025.3625300","title":"A Comprehensive Study of Bugs in Relational DBMS","display_name":"A Comprehensive Study of Bugs in Relational DBMS","publication_year":2025,"publication_date":"2025-10-31","ids":{"openalex":"https://openalex.org/W4415743509","doi":"https://doi.org/10.1109/tse.2025.3625300"},"language":null,"primary_location":{"id":"doi:10.1109/tse.2025.3625300","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tse.2025.3625300","pdf_url":null,"source":{"id":"https://openalex.org/S8351582","display_name":"IEEE Transactions on Software Engineering","issn_l":"0098-5589","issn":["0098-5589","1939-3520","2326-3881"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Software Engineering","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/A5100319073","display_name":"Shuang Liu","orcid":"https://orcid.org/0000-0001-8766-7235"},"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":"Shuang Liu","raw_affiliation_strings":["School of Information, Renmin University of China, Beijing, China","School of Information, Renmin University of China, China"],"raw_orcid":"https://orcid.org/0000-0001-8766-7235","affiliations":[{"raw_affiliation_string":"School of Information, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"School of Information, Renmin University of China, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Ruifeng Wang","orcid":"https://orcid.org/0009-0007-1709-3484"},"institutions":[{"id":"https://openalex.org/I162868743","display_name":"Tianjin University","ror":"https://ror.org/012tb2g32","country_code":"CN","type":"education","lineage":["https://openalex.org/I162868743"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Ruifeng Wang","raw_affiliation_strings":["College of Intelligence and Computing, Tianjin University, Tianjin, China","College of Intelligence and Computing, Tianjin University, China"],"raw_orcid":"https://orcid.org/0009-0007-1709-3484","affiliations":[{"raw_affiliation_string":"College of Intelligence and Computing, Tianjin University, Tianjin, China","institution_ids":["https://openalex.org/I162868743"]},{"raw_affiliation_string":"College of Intelligence and Computing, Tianjin University, China","institution_ids":["https://openalex.org/I162868743"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Yuanfeng Xie","orcid":"https://orcid.org/0009-0008-6732-4006"},"institutions":[{"id":"https://openalex.org/I162868743","display_name":"Tianjin University","ror":"https://ror.org/012tb2g32","country_code":"CN","type":"education","lineage":["https://openalex.org/I162868743"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yuanfeng Xie","raw_affiliation_strings":["College of Intelligence and Computing, Tianjin University, Tianjin, China","College of Intelligence and Computing, Tianjin University, China"],"raw_orcid":"https://orcid.org/0009-0008-6732-4006","affiliations":[{"raw_affiliation_string":"College of Intelligence and Computing, Tianjin University, Tianjin, China","institution_ids":["https://openalex.org/I162868743"]},{"raw_affiliation_string":"College of Intelligence and Computing, Tianjin University, China","institution_ids":["https://openalex.org/I162868743"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100365555","display_name":"Junjie Chen","orcid":"https://orcid.org/0000-0003-3056-9962"},"institutions":[{"id":"https://openalex.org/I162868743","display_name":"Tianjin University","ror":"https://ror.org/012tb2g32","country_code":"CN","type":"education","lineage":["https://openalex.org/I162868743"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Junjie Chen","raw_affiliation_strings":["College of Intelligence and Computing, Tianjin University, Tianjin, China","College of Intelligence and Computing, Tianjin University, China"],"raw_orcid":"https://orcid.org/0000-0003-3056-9962","affiliations":[{"raw_affiliation_string":"College of Intelligence and Computing, Tianjin University, Tianjin, China","institution_ids":["https://openalex.org/I162868743"]},{"raw_affiliation_string":"College of Intelligence and Computing, Tianjin University, China","institution_ids":["https://openalex.org/I162868743"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005529387","display_name":"Wei L\u00fc","orcid":"https://orcid.org/0000-0001-6769-2695"},"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":"Wei Lu","raw_affiliation_strings":["Key Laboratory of Data Engineering and Knowledge Engineering (MOE), Renmin University of China, Beijing, China","Laboratory of Data Engineering and Knowledge Engineering (MOE), Renmin University of China, China"],"raw_orcid":"https://orcid.org/0000-0001-6769-2695","affiliations":[{"raw_affiliation_string":"Key Laboratory of Data Engineering and Knowledge Engineering (MOE), Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"Laboratory of Data Engineering and Knowledge Engineering (MOE), Renmin University of China, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Xiao Zhang","orcid":"https://orcid.org/0009-0001-1857-1368"},"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":"Xiao Zhang","raw_affiliation_strings":["School of Information, Renmin University of China, Beijing, China","School of Information, Renmin University of China, China"],"raw_orcid":"https://orcid.org/0009-0001-1857-1368","affiliations":[{"raw_affiliation_string":"School of Information, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"School of Information, Renmin University of China, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074979952","display_name":"Quanqing Xu","orcid":"https://orcid.org/0000-0001-8989-9662"},"institutions":[{"id":"https://openalex.org/I4210125741","display_name":"Oceanic Research Group","ror":"https://ror.org/02vf9n064","country_code":"US","type":"nonprofit","lineage":["https://openalex.org/I4210125741"]},{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN","US"],"is_corresponding":false,"raw_author_name":"Quanqing Xu","raw_affiliation_strings":["Ant Group, OceanBase, Hangzhou, China","OceanBaseAnt Group"],"raw_orcid":"https://orcid.org/0000-0001-8989-9662","affiliations":[{"raw_affiliation_string":"Ant Group, OceanBase, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]},{"raw_affiliation_string":"OceanBaseAnt Group","institution_ids":["https://openalex.org/I4210125741"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086810340","display_name":"Chuanhui Yang","orcid":"https://orcid.org/0009-0009-3530-6476"},"institutions":[{"id":"https://openalex.org/I4210125741","display_name":"Oceanic Research Group","ror":"https://ror.org/02vf9n064","country_code":"US","type":"nonprofit","lineage":["https://openalex.org/I4210125741"]},{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN","US"],"is_corresponding":false,"raw_author_name":"Chuanhui Yang","raw_affiliation_strings":["Ant Group, OceanBase, Hangzhou, China","OceanBaseAnt Group"],"raw_orcid":"https://orcid.org/0009-0009-3530-6476","affiliations":[{"raw_affiliation_string":"Ant Group, OceanBase, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]},{"raw_affiliation_string":"OceanBaseAnt Group","institution_ids":["https://openalex.org/I4210125741"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5008721449","display_name":"Xiaoyong Du","orcid":"https://orcid.org/0000-0002-5757-9135"},"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":"Xiaoyong Du","raw_affiliation_strings":["Key Laboratory of Data Engineering and Knowledge Engineering (MOE), School of Information, Renmin University of China, Beijing, China","Laboratory of Data Engineering and Knowledge Engineering (MOE), Renmin University of China, China"],"raw_orcid":"https://orcid.org/0000-0002-5757-9135","affiliations":[{"raw_affiliation_string":"Key Laboratory of Data Engineering and Knowledge Engineering (MOE), School of Information, Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]},{"raw_affiliation_string":"Laboratory of Data Engineering and Knowledge Engineering (MOE), Renmin University of China, China","institution_ids":["https://openalex.org/I78988378"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":9,"corresponding_author_ids":["https://openalex.org/A5100319073"],"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.3559242,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"51","issue":"12","first_page":"3654","last_page":"3668"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.3188999891281128,"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/T12127","display_name":"Software System Performance and Reliability","score":0.3188999891281128,"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/T10260","display_name":"Software Engineering Research","score":0.14749999344348907,"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.08340000361204147,"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/relational-database-management-system","display_name":"Relational database management system","score":0.8529000282287598},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6924999952316284},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.623199999332428},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.438400000333786},{"id":"https://openalex.org/keywords/software-bug","display_name":"Software bug","score":0.41620001196861267},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.4099999964237213},{"id":"https://openalex.org/keywords/security-bug","display_name":"Security bug","score":0.4036000072956085},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.3725000023841858}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8586999773979187},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.8529000282287598},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6924999952316284},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.623199999332428},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6021000146865845},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.438400000333786},{"id":"https://openalex.org/C1009929","wikidata":"https://www.wikidata.org/wiki/Q179550","display_name":"Software bug","level":3,"score":0.41620001196861267},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.4099999964237213},{"id":"https://openalex.org/C131275738","wikidata":"https://www.wikidata.org/wiki/Q7445023","display_name":"Security bug","level":5,"score":0.4036000072956085},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.3725000023841858},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.3693999946117401},{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.3528999984264374},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.3499999940395355},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.34940001368522644},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.3230000138282776},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2985000014305115},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.29600000381469727},{"id":"https://openalex.org/C198531522","wikidata":"https://www.wikidata.org/wiki/Q485146","display_name":"Sample (material)","level":2,"score":0.28209999203681946},{"id":"https://openalex.org/C128942645","wikidata":"https://www.wikidata.org/wiki/Q1568346","display_name":"Test case","level":3,"score":0.28029999136924744},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.2667999863624573},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2623000144958496},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.2533999979496002},{"id":"https://openalex.org/C138958017","wikidata":"https://www.wikidata.org/wiki/Q190087","display_name":"Data type","level":2,"score":0.2524999976158142}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tse.2025.3625300","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tse.2025.3625300","pdf_url":null,"source":{"id":"https://openalex.org/S8351582","display_name":"IEEE Transactions on Software Engineering","issn_l":"0098-5589","issn":["0098-5589","1939-3520","2326-3881"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Software Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G4612863498","display_name":null,"funder_award_id":"62472429","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G8073827331","display_name":null,"funder_award_id":"62322208","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W2055864412","https://openalex.org/W2135198734","https://openalex.org/W2139086035","https://openalex.org/W2158437127","https://openalex.org/W2405678927","https://openalex.org/W2461570336","https://openalex.org/W2963900765","https://openalex.org/W2982547214","https://openalex.org/W3042605769","https://openalex.org/W3090561201","https://openalex.org/W3097728505","https://openalex.org/W3106731144","https://openalex.org/W3196239222","https://openalex.org/W4284665426","https://openalex.org/W4313563635","https://openalex.org/W4313563670","https://openalex.org/W4327594616","https://openalex.org/W4384155409","https://openalex.org/W4384345799","https://openalex.org/W4394745231","https://openalex.org/W4394769417","https://openalex.org/W4400485311"],"related_works":[],"abstract_inverted_index":{"Relational":[0],"Database":[1],"Management":[2],"Systems":[3],"(RDBMSs)":[4],"are":[5],"crucial":[6],"infrastructures":[7],"supporting":[8],"a":[9,136],"wide":[10],"range":[11],"of":[12,28,95],"applications,":[13],"making":[14],"bug":[15,47,50,52,127],"mitigation":[16],"within":[17],"these":[18,132],"systems":[19],"essential.":[20],"This":[21],"study":[22],"presents":[23],"the":[24,57,60,66,90],"first":[25],"comprehensive":[26],"analysis":[27],"bugs":[29,42,103,144],"in":[30],"three":[31],"popular":[32],"open-source":[33],"RDBMSs\u2014MySQL,":[34],"SQLite,":[35],"and":[36,56,93,109,117,129],"openGauss.":[37],"We":[38,63,81],"manually":[39],"examined":[40],"777":[41],"across":[43,54],"four":[44,152],"dimensions,":[45],"i.e.,":[46],"root":[48],"causes,":[49],"symptoms,":[51],"distribution":[53],"modules,":[55],"correlations":[58],"between":[59],"studied":[61],"aspects.":[62],"also":[64],"analyzed":[65],"bug-triggering":[67],"SQL":[68,106],"statements":[69],"to":[70,105],"uncover":[71],"test":[72],"cases":[73],"that":[74,102],"cannot":[75],"be":[76],"generated":[77],"by":[78,149],"existing":[79],"tools.":[80],"have":[82],"made":[83],"12":[84],"findings,":[85],"which":[86,139],"throw":[87],"lights":[88],"on":[89],"development,":[91],"maintenance":[92],"testing":[94],"RDBMS":[96,126,143],"systems.":[97],"Particularly,":[98],"our":[99],"findings":[100],"reveal":[101],"related":[104],"data":[107],"types":[108],"complex":[110],"features,":[111],"such":[112],"as":[113],"database":[114,118],"triggers,":[115],"procedures":[116],"parameter":[119],"settings,":[120],"present":[121],"significant":[122],"opportunities":[123],"for":[124],"enhancing":[125],"detection":[128],"mitigation.":[130],"Leveraging":[131],"insights,":[133],"we":[134],"developed":[135],"tool,":[137],"SQLT,":[138],"effectively":[140],"identified":[141],"eight":[142],"(five":[145],"type-related),":[146],"all":[147],"verified":[148],"developers,":[150],"with":[151],"subsequently":[153],"fixed.":[154]},"counts_by_year":[],"updated_date":"2026-04-25T08:17:42.794288","created_date":"2025-10-31T00:00:00"}