{"id":"https://openalex.org/W1992302848","doi":"https://doi.org/10.1109/ase.2011.6100056","title":"Localizing SQL faults in database applications","display_name":"Localizing SQL faults in database applications","publication_year":2011,"publication_date":"2011-11-01","ids":{"openalex":"https://openalex.org/W1992302848","doi":"https://doi.org/10.1109/ase.2011.6100056","mag":"1992302848"},"language":"en","primary_location":{"id":"doi:10.1109/ase.2011.6100056","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ase.2011.6100056","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2011 26th IEEE/ACM International Conference on Automated Software Engineering (ASE 2011)","raw_type":"proceedings-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/A5046450159","display_name":"Sarah R. Clark","orcid":null},"institutions":[{"id":"https://openalex.org/I130701444","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44","country_code":"US","type":"education","lineage":["https://openalex.org/I130701444"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Sarah R. Clark","raw_affiliation_strings":["Georgia Institute of Technology, USA","Georgia Institute of Technology,  USA"],"affiliations":[{"raw_affiliation_string":"Georgia Institute of Technology, USA","institution_ids":["https://openalex.org/I130701444"]},{"raw_affiliation_string":"Georgia Institute of Technology,  USA","institution_ids":["https://openalex.org/I130701444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049342490","display_name":"Jake Cobb","orcid":null},"institutions":[{"id":"https://openalex.org/I130701444","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44","country_code":"US","type":"education","lineage":["https://openalex.org/I130701444"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jake Cobb","raw_affiliation_strings":["Georgia Institute of Technology, USA","Georgia Institute of Technology,  USA"],"affiliations":[{"raw_affiliation_string":"Georgia Institute of Technology, USA","institution_ids":["https://openalex.org/I130701444"]},{"raw_affiliation_string":"Georgia Institute of Technology,  USA","institution_ids":["https://openalex.org/I130701444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084185098","display_name":"Gregory M. Kapfhammer","orcid":null},"institutions":[{"id":"https://openalex.org/I120506574","display_name":"Allegheny College","ror":"https://ror.org/02jgzjj54","country_code":"US","type":"education","lineage":["https://openalex.org/I120506574"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Gregory M. Kapfhammer","raw_affiliation_strings":["Allegheny College, USA"],"affiliations":[{"raw_affiliation_string":"Allegheny College, USA","institution_ids":["https://openalex.org/I120506574"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5008140976","display_name":"James A. Jones","orcid":"https://orcid.org/0000-0002-5359-7934"},"institutions":[{"id":"https://openalex.org/I204250578","display_name":"University of California, Irvine","ror":"https://ror.org/04gyf1771","country_code":"US","type":"education","lineage":["https://openalex.org/I204250578"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"James A. Jones","raw_affiliation_strings":["University of California, Irvine, USA","University of California Irvine (USA)"],"affiliations":[{"raw_affiliation_string":"University of California, Irvine, USA","institution_ids":["https://openalex.org/I204250578"]},{"raw_affiliation_string":"University of California Irvine (USA)","institution_ids":["https://openalex.org/I204250578"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5038406724","display_name":"Mary Jean Harrold","orcid":null},"institutions":[{"id":"https://openalex.org/I130701444","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44","country_code":"US","type":"education","lineage":["https://openalex.org/I130701444"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mary Jean Harrold","raw_affiliation_strings":["Georgia Institute of Technology, USA","Georgia Institute of Technology,  USA"],"affiliations":[{"raw_affiliation_string":"Georgia Institute of Technology, USA","institution_ids":["https://openalex.org/I130701444"]},{"raw_affiliation_string":"Georgia Institute of Technology,  USA","institution_ids":["https://openalex.org/I130701444"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5046450159"],"corresponding_institution_ids":["https://openalex.org/I130701444"],"apc_list":null,"apc_paid":null,"fwci":7.3895,"has_fulltext":false,"cited_by_count":30,"citation_normalized_percentile":{"value":0.96647572,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"213","last_page":"222"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.9995999932289124,"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"}},"topics":[{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.9995999932289124,"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/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9995999932289124,"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.9994999766349792,"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.8672884702682495},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7944900989532471},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.7125322818756104},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.671936571598053},{"id":"https://openalex.org/keywords/debugging","display_name":"Debugging","score":0.6714408993721008},{"id":"https://openalex.org/keywords/statement","display_name":"Statement (logic)","score":0.5782337188720703},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5580541491508484},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.5410770773887634},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5394608974456787},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5072078704833984},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4644463360309601},{"id":"https://openalex.org/keywords/in-memory-processing","display_name":"In-Memory Processing","score":0.41860082745552063},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.319519579410553},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2986629605293274},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.10711479187011719}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8672884702682495},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7944900989532471},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.7125322818756104},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.671936571598053},{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.6714408993721008},{"id":"https://openalex.org/C2777026412","wikidata":"https://www.wikidata.org/wiki/Q2684591","display_name":"Statement (logic)","level":2,"score":0.5782337188720703},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5580541491508484},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5410770773887634},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5394608974456787},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5072078704833984},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4644463360309601},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.41860082745552063},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.319519579410553},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2986629605293274},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.10711479187011719},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/ase.2011.6100056","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ase.2011.6100056","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2011 26th IEEE/ACM International Conference on Automated Software Engineering (ASE 2011)","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.1033.3895","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.1033.3895","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"https://dspace.allegheny.edu/bitstream/handle/10456/35610/Kapfhammer_ASE_2011.pdf%3Bjsessionid%3DC7DA9E10FD814B0BDFF9D86D2B9D9B5C.alldspace_101?sequence%3D1","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.728.5565","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.728.5565","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.allegheny.edu/sites/gkapfham/download/research/papers/ase2011a-clark-cobb-kapfhammer-jones-harrold.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4699999988079071,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320309321","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44"},{"id":"https://openalex.org/F4320332688","display_name":"University of California, Irvine","ror":"https://ror.org/04gyf1771"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W139810517","https://openalex.org/W196452053","https://openalex.org/W1767990287","https://openalex.org/W1984248430","https://openalex.org/W2022274639","https://openalex.org/W2101819268","https://openalex.org/W2119021158","https://openalex.org/W2121081915","https://openalex.org/W2121084350","https://openalex.org/W2123659430","https://openalex.org/W2127961981","https://openalex.org/W2147427167","https://openalex.org/W2153418968","https://openalex.org/W2162045655","https://openalex.org/W2162376048","https://openalex.org/W2167751257","https://openalex.org/W2169212615","https://openalex.org/W2170830071","https://openalex.org/W2545480118","https://openalex.org/W2751199251","https://openalex.org/W2753439427","https://openalex.org/W4233319527","https://openalex.org/W4240309233","https://openalex.org/W4243127898","https://openalex.org/W6608071760","https://openalex.org/W6638118107"],"related_works":["https://openalex.org/W4323365709","https://openalex.org/W3209496184","https://openalex.org/W650213220","https://openalex.org/W2340883001","https://openalex.org/W1980548249","https://openalex.org/W2044009024","https://openalex.org/W2362753095","https://openalex.org/W1890845846","https://openalex.org/W2240099544","https://openalex.org/W2512476881"],"abstract_inverted_index":{"This":[0],"paper":[1,96],"presents":[2],"a":[3,13,35],"new":[4,129],"fault-localization":[5,111],"technique":[6,17,66],"designed":[7],"for":[8,70,88],"applications":[9],"that":[10,81,92],"interact":[11],"with":[12],"relational":[14],"database.":[15],"The":[16,65,95,104,131],"uses":[18,74],"dynamic":[19],"information":[20,76,140],"specific":[21],"to":[22,33,61,77,85,141],"the":[23,46,50,53,57,63,89,98,115,125,128,135],"application's":[24],"database,":[25],"such":[26],"as":[27],"Structured":[28],"Query":[29],"Language":[30],"(SQL)":[31],"commands,":[32],"provide":[34],"fault-location":[36],"diagnosis.":[37],"By":[38],"creating":[39],"statement-SQL":[40],"tuples":[41,72],"and":[42,56,73,109,113,117,144],"calculating":[43],"their":[44],"suspiciousness,":[45],"presented":[47],"method":[48],"lets":[49],"developer":[51],"identify":[52,78],"database":[54,139],"commands":[55],"program":[58],"statements":[59],"likely":[60,84],"cause":[62],"failures.":[64],"also":[67,123],"calculates":[68],"suspiciousness":[69,90],"statement-attribute":[71],"this":[75],"SQL":[79,93],"fragments":[80],"are":[82],"statistically":[83],"be":[86],"responsible":[87],"of":[91,100,119,127,137],"command.":[94],"reports":[97],"results":[99],"two":[101],"empirical":[102],"studies.":[103],"first":[105],"study":[106,133],"compares":[107],"existing":[108],"database-aware":[110],"methods,":[112],"reveals":[114],"strengths":[116],"limitations":[118],"prior":[120],"techniques,":[121],"while":[122],"highlighting":[124],"effectiveness":[126],"approach.":[130],"second":[132],"demonstrates":[134],"benefits":[136],"using":[138],"improve":[142],"understanding":[143],"reduce":[145],"manual":[146],"debugging":[147],"effort.":[148]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":5},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":5},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}