{"id":"https://openalex.org/W4399619591","doi":"https://doi.org/10.1145/3672449","title":"An Empirical Study on the Characteristics of Database Access Bugs in Java Applications","display_name":"An Empirical Study on the Characteristics of Database Access Bugs in Java Applications","publication_year":2024,"publication_date":"2024-06-13","ids":{"openalex":"https://openalex.org/W4399619591","doi":"https://doi.org/10.1145/3672449"},"language":"en","primary_location":{"id":"doi:10.1145/3672449","is_oa":true,"landing_page_url":"http://dx.doi.org/10.1145/3672449","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3672449","source":{"id":"https://openalex.org/S142627899","display_name":"ACM Transactions on Software Engineering and Methodology","issn_l":"1049-331X","issn":["1049-331X","1557-7392"],"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 Transactions on Software Engineering and Methodology","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3672449","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5028251305","display_name":"Wei Liu","orcid":"https://orcid.org/0000-0001-8956-730X"},"institutions":[{"id":"https://openalex.org/I4210119464","display_name":"Quality and Reliability (Greece)","ror":"https://ror.org/02f8mda22","country_code":"GR","type":"company","lineage":["https://openalex.org/I4210119464"]},{"id":"https://openalex.org/I60158472","display_name":"Concordia University","ror":"https://ror.org/0420zvk78","country_code":"CA","type":"education","lineage":["https://openalex.org/I60158472"]}],"countries":["CA","GR"],"is_corresponding":true,"raw_author_name":"Wei Liu","raw_affiliation_strings":["Software PErformance, Analysis, and Reliability (SPEAR) lab, Concordia University, Montreal, QC, Canada","Software PErformance, Analysis, and Reliability (SPEAR) lab, Concordia University, Canada"],"affiliations":[{"raw_affiliation_string":"Software PErformance, Analysis, and Reliability (SPEAR) lab, Concordia University, Montreal, QC, Canada","institution_ids":["https://openalex.org/I60158472","https://openalex.org/I4210119464"]},{"raw_affiliation_string":"Software PErformance, Analysis, and Reliability (SPEAR) lab, Concordia University, Canada","institution_ids":["https://openalex.org/I60158472"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5067225281","display_name":"Shouvick Mondal","orcid":"https://orcid.org/0000-0002-0703-8728"},"institutions":[{"id":"https://openalex.org/I27674431","display_name":"Indian Institute of Technology Gandhinagar","ror":"https://ror.org/0036p5w23","country_code":"IN","type":"education","lineage":["https://openalex.org/I27674431"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Shouvick Mondal","raw_affiliation_strings":["Software Engineering and Testing (SET) lab, Indian Institute of Technology Gandhinagar, Palaj, India","Software Engineering and Testing (SET) lab, Indian Institute of Technology Gandhinagar, India"],"affiliations":[{"raw_affiliation_string":"Software Engineering and Testing (SET) lab, Indian Institute of Technology Gandhinagar, Palaj, India","institution_ids":["https://openalex.org/I27674431"]},{"raw_affiliation_string":"Software Engineering and Testing (SET) lab, Indian Institute of Technology Gandhinagar, India","institution_ids":["https://openalex.org/I27674431"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5069372430","display_name":"Tse-Hsun Chen","orcid":"https://orcid.org/0000-0003-4027-0905"},"institutions":[{"id":"https://openalex.org/I4210119464","display_name":"Quality and Reliability (Greece)","ror":"https://ror.org/02f8mda22","country_code":"GR","type":"company","lineage":["https://openalex.org/I4210119464"]},{"id":"https://openalex.org/I60158472","display_name":"Concordia University","ror":"https://ror.org/0420zvk78","country_code":"CA","type":"education","lineage":["https://openalex.org/I60158472"]}],"countries":["CA","GR"],"is_corresponding":false,"raw_author_name":"Tse-Hsun (Peter) Chen","raw_affiliation_strings":["Software PErformance, Analysis, and Reliability (SPEAR) lab, Concordia University, Montreal, QC, Canada","Software PErformance, Analysis, and Reliability (SPEAR) lab, Concordia University, Canada"],"affiliations":[{"raw_affiliation_string":"Software PErformance, Analysis, and Reliability (SPEAR) lab, Concordia University, Montreal, QC, Canada","institution_ids":["https://openalex.org/I60158472","https://openalex.org/I4210119464"]},{"raw_affiliation_string":"Software PErformance, Analysis, and Reliability (SPEAR) lab, Concordia University, Canada","institution_ids":["https://openalex.org/I60158472"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5028251305"],"corresponding_institution_ids":["https://openalex.org/I4210119464","https://openalex.org/I60158472"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.09096573,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"33","issue":"7","first_page":"1","last_page":"25"},"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.9998999834060669,"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.9998999834060669,"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/T12423","display_name":"Software Reliability and Analysis Research","score":0.9994000196456909,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8515216708183289},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.7028661370277405},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6218001842498779},{"id":"https://openalex.org/keywords/java","display_name":"Java","score":0.5709680318832397},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.5426268577575684},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.5285740494728088},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.46922335028648376},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.46288084983825684},{"id":"https://openalex.org/keywords/commit","display_name":"Commit","score":0.45868444442749023},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.433106929063797},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.41605618596076965},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.26813143491744995},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.18970394134521484},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.10661861300468445}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8515216708183289},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7028661370277405},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6218001842498779},{"id":"https://openalex.org/C548217200","wikidata":"https://www.wikidata.org/wiki/Q251","display_name":"Java","level":2,"score":0.5709680318832397},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5426268577575684},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5285740494728088},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.46922335028648376},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.46288084983825684},{"id":"https://openalex.org/C153180980","wikidata":"https://www.wikidata.org/wiki/Q19776675","display_name":"Commit","level":2,"score":0.45868444442749023},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.433106929063797},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.41605618596076965},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.26813143491744995},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.18970394134521484},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.10661861300468445},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3672449","is_oa":true,"landing_page_url":"http://dx.doi.org/10.1145/3672449","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3672449","source":{"id":"https://openalex.org/S142627899","display_name":"ACM Transactions on Software Engineering and Methodology","issn_l":"1049-331X","issn":["1049-331X","1557-7392"],"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 Transactions on Software Engineering and Methodology","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/3672449","is_oa":true,"landing_page_url":"http://dx.doi.org/10.1145/3672449","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3672449","source":{"id":"https://openalex.org/S142627899","display_name":"ACM Transactions on Software Engineering and Methodology","issn_l":"1049-331X","issn":["1049-331X","1557-7392"],"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 Transactions on Software Engineering and Methodology","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4399619591.pdf"},"referenced_works_count":53,"referenced_works":["https://openalex.org/W89541942","https://openalex.org/W606501988","https://openalex.org/W1973601549","https://openalex.org/W1988296176","https://openalex.org/W2006247411","https://openalex.org/W2022274639","https://openalex.org/W2053154970","https://openalex.org/W2057516979","https://openalex.org/W2062666593","https://openalex.org/W2107531799","https://openalex.org/W2108349789","https://openalex.org/W2113531724","https://openalex.org/W2118731196","https://openalex.org/W2119021158","https://openalex.org/W2135841285","https://openalex.org/W2152980152","https://openalex.org/W2157913501","https://openalex.org/W2164777277","https://openalex.org/W2266149187","https://openalex.org/W2340417905","https://openalex.org/W2397554829","https://openalex.org/W2400781461","https://openalex.org/W2404555615","https://openalex.org/W2473995384","https://openalex.org/W2528596642","https://openalex.org/W2545480118","https://openalex.org/W2546913659","https://openalex.org/W2740841986","https://openalex.org/W2767894601","https://openalex.org/W2777616600","https://openalex.org/W2794933251","https://openalex.org/W2808642230","https://openalex.org/W2809221603","https://openalex.org/W2898548722","https://openalex.org/W2911468826","https://openalex.org/W2963426888","https://openalex.org/W2991727166","https://openalex.org/W2997401484","https://openalex.org/W3020616315","https://openalex.org/W3038801694","https://openalex.org/W3085921543","https://openalex.org/W3090643686","https://openalex.org/W3090668201","https://openalex.org/W3095376256","https://openalex.org/W3178148321","https://openalex.org/W4237143884","https://openalex.org/W4239146630","https://openalex.org/W4239584046","https://openalex.org/W4240107976","https://openalex.org/W4246594103","https://openalex.org/W4250170013","https://openalex.org/W4251194048","https://openalex.org/W4251334431"],"related_works":["https://openalex.org/W1588786827","https://openalex.org/W2185193035","https://openalex.org/W1016652228","https://openalex.org/W279222092","https://openalex.org/W2188578519","https://openalex.org/W1502610062","https://openalex.org/W2153455914","https://openalex.org/W2406556412","https://openalex.org/W3196679839","https://openalex.org/W2585880425"],"abstract_inverted_index":{"Database-backed":[0],"applications":[1,65],"rely":[2],"on":[3,199],"the":[4,11,44,76,84,89,98,126,154,184,200],"database":[5,13,23,40,56,102,130,166],"access":[6,24,41,57,105,131,167],"code":[7,31],"to":[8,157],"interact":[9],"with":[10],"underlying":[12],"management":[14],"systems":[15],"(DBMSs).":[16],"Although":[17],"many":[18],"prior":[19],"studies":[20],"aim":[21],"at":[22],"issues":[25,187],"like":[26],"SQL":[27,30,143,158,175],"anti-patterns":[28],"or":[29,72],"smells,":[32],"there":[33],"is":[34],"a":[35,108,197],"lack":[36],"of":[37,39,46,83,100,125,129,165,202],"study":[38,75],"bugs":[42,58,85,106,155,168],"during":[43],"maintenance":[45],"database-backed":[47],"applications.":[48,172],"In":[49,173],"this":[50],"paper,":[51],"we":[52,122,195],"empirically":[53],"investigate":[54],"423":[55],"collected":[59],"from":[60],"seven":[61],"large-scale":[62],"Java":[63],"open-source":[64],"that":[66,97,153],"use":[67],"relational":[68],"DBMSs":[69],"(e.g.,":[70,78],"MySQL":[71],"PostgreSQL).":[73],"We":[74,95,151],"characteristics":[77],"occurrence":[79],"and":[80,92,103,142,146,161,179,191,207],"root":[81,127,149],"causes)":[82],"by":[86],"manually":[87],"examining":[88],"bug":[90,116,177,181],"reports":[91],"commit":[93],"histories.":[94],"find":[96,152],"number":[99],"reported":[101],"non-database":[104],"share":[107],"similar":[109],"trend":[110],"but":[111],"their":[112],"modified":[113],"files":[114],"in":[115],"fixing":[117],"commits":[118],"are":[119,183],"different.":[120],"Additionally,":[121],"generalize":[123],"categories":[124,136],"causes":[128],"bugs,":[132],"containing":[133],"five":[134],"main":[135],"(SQL":[137],"queries,":[138,159],"Schema,":[139,160],"API,":[140],"Configuration,":[141],"query":[144],"result)":[145],"25":[147],"unique":[148],"causes.":[150],"pertaining":[156],"API":[162,180],"cover":[163],"84.2%":[164],"across":[169],"all":[170],"studied":[171],"particular,":[174],"queries":[176],"(54%)":[178],"(38.7%)":[182],"most":[185],"frequent":[186],"when":[188],"using":[189],"JDBC":[190],"Hibernate,":[192],"respectively.":[193],"Finally,":[194],"provide":[196],"discussion":[198],"implications":[201],"our":[203],"findings":[204],"for":[205],"developers":[206],"researchers.":[208]},"counts_by_year":[],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}