{"id":"https://openalex.org/W2128539867","doi":"https://doi.org/10.1109/aiccsa.2005.1387036","title":"Mapping faults to failures in SQL manipulation commands","display_name":"Mapping faults to failures in SQL manipulation commands","publication_year":2005,"publication_date":"2005-04-01","ids":{"openalex":"https://openalex.org/W2128539867","doi":"https://doi.org/10.1109/aiccsa.2005.1387036","mag":"2128539867"},"language":"en","primary_location":{"id":"doi:10.1109/aiccsa.2005.1387036","is_oa":false,"landing_page_url":"https://doi.org/10.1109/aiccsa.2005.1387036","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The 3rd ACS/IEEE International Conference onComputer Systems and Applications, 2005.","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/A5081551463","display_name":"Plinio de Sa Leit\u00e3o","orcid":null},"institutions":[{"id":"https://openalex.org/I181391015","display_name":"Universidade Estadual de Campinas (UNICAMP)","ror":"https://ror.org/04wffgt70","country_code":"BR","type":"education","lineage":["https://openalex.org/I181391015"]}],"countries":["BR"],"is_corresponding":true,"raw_author_name":"P. de Sa Leitao","raw_affiliation_strings":["DCA-FEEC-Unicamp, State University of Campinas, Sao Paulo, Brazil","DCA-FEEC-Unicamp, Campinas State Univ., Brazil#TAB#"],"affiliations":[{"raw_affiliation_string":"DCA-FEEC-Unicamp, State University of Campinas, Sao Paulo, Brazil","institution_ids":["https://openalex.org/I181391015"]},{"raw_affiliation_string":"DCA-FEEC-Unicamp, Campinas State Univ., Brazil#TAB#","institution_ids":["https://openalex.org/I181391015"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030673847","display_name":"Pl\u00ednio Robert Souza Vilela","orcid":null},"institutions":[{"id":"https://openalex.org/I4210095520","display_name":"Methodist University of Piracicaba","ror":"https://ror.org/00shzgx32","country_code":"BR","type":"education","lineage":["https://openalex.org/I4210095520"]},{"id":"https://openalex.org/I76835614","display_name":"University of Missouri","ror":"https://ror.org/02ymw8z06","country_code":"US","type":"education","lineage":["https://openalex.org/I76835614"]}],"countries":["BR","US"],"is_corresponding":false,"raw_author_name":"P.R.S. Vilela","raw_affiliation_strings":["Methodist University of Piracicaba, Sao Paulo, Brazil","SCE, Missouri Univ., Kansas, PA, USA"],"affiliations":[{"raw_affiliation_string":"Methodist University of Piracicaba, Sao Paulo, Brazil","institution_ids":["https://openalex.org/I4210095520"]},{"raw_affiliation_string":"SCE, Missouri Univ., Kansas, PA, USA","institution_ids":["https://openalex.org/I76835614"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5068540423","display_name":"M\u00e1rio Jino","orcid":"https://orcid.org/0000-0002-1914-5790"},"institutions":[{"id":"https://openalex.org/I181391015","display_name":"Universidade Estadual de Campinas (UNICAMP)","ror":"https://ror.org/04wffgt70","country_code":"BR","type":"education","lineage":["https://openalex.org/I181391015"]},{"id":"https://openalex.org/I76835614","display_name":"University of Missouri","ror":"https://ror.org/02ymw8z06","country_code":"US","type":"education","lineage":["https://openalex.org/I76835614"]}],"countries":["BR","US"],"is_corresponding":false,"raw_author_name":"M. Jino","raw_affiliation_strings":["DCA-FEEC-Unicamp, State University of Campinas, Sao Paulo, Brazil","SCE, Missouri Univ., Kansas, PA, USA"],"affiliations":[{"raw_affiliation_string":"DCA-FEEC-Unicamp, State University of Campinas, Sao Paulo, Brazil","institution_ids":["https://openalex.org/I181391015"]},{"raw_affiliation_string":"SCE, Missouri Univ., Kansas, PA, USA","institution_ids":["https://openalex.org/I76835614"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5081551463"],"corresponding_institution_ids":["https://openalex.org/I181391015"],"apc_list":null,"apc_paid":null,"fwci":1.4325,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.83611111,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"172","last_page":"175"},"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/T12423","display_name":"Software Reliability and Analysis Research","score":0.9990000128746033,"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/T10260","display_name":"Software Engineering Research","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/computer-science","display_name":"Computer science","score":0.7932741045951843},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6404518485069275},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.47507160902023315},{"id":"https://openalex.org/keywords/software-quality","display_name":"Software quality","score":0.4656117260456085},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.46483632922172546},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.4317713677883148},{"id":"https://openalex.org/keywords/software-fault-tolerance","display_name":"Software fault tolerance","score":0.4280169606208801},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3956134021282196},{"id":"https://openalex.org/keywords/software-development","display_name":"Software development","score":0.3277229368686676},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3266449272632599},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.30119362473487854}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7932741045951843},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6404518485069275},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.47507160902023315},{"id":"https://openalex.org/C117447612","wikidata":"https://www.wikidata.org/wiki/Q1412670","display_name":"Software quality","level":4,"score":0.4656117260456085},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.46483632922172546},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.4317713677883148},{"id":"https://openalex.org/C50712370","wikidata":"https://www.wikidata.org/wiki/Q4269346","display_name":"Software fault tolerance","level":3,"score":0.4280169606208801},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3956134021282196},{"id":"https://openalex.org/C529173508","wikidata":"https://www.wikidata.org/wiki/Q638608","display_name":"Software development","level":3,"score":0.3277229368686676},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3266449272632599},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.30119362473487854},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/aiccsa.2005.1387036","is_oa":false,"landing_page_url":"https://doi.org/10.1109/aiccsa.2005.1387036","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The 3rd ACS/IEEE International Conference onComputer Systems and Applications, 2005.","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.5600000023841858,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W127224647","https://openalex.org/W1523736726","https://openalex.org/W1563960834","https://openalex.org/W1910771831","https://openalex.org/W2063462461","https://openalex.org/W2109322951","https://openalex.org/W2131467114","https://openalex.org/W2140297147","https://openalex.org/W2157657084","https://openalex.org/W2185907055","https://openalex.org/W2751084063","https://openalex.org/W2988119170","https://openalex.org/W6631592580","https://openalex.org/W6633685834","https://openalex.org/W6676191175"],"related_works":["https://openalex.org/W2769255368","https://openalex.org/W4321848582","https://openalex.org/W1488984669","https://openalex.org/W2212955619","https://openalex.org/W3124296310","https://openalex.org/W1911878188","https://openalex.org/W2155445882","https://openalex.org/W2141411717","https://openalex.org/W3145773044","https://openalex.org/W2149450576"],"abstract_inverted_index":{"Summary":[0],"form":[1],"only":[2],"given.":[3],"Databases":[4],"and":[5,15,31,52,67,81,98,110,114,125],"their":[6,28],"applications":[7],"are":[8,103],"topics":[9],"of":[10,35,43,56,71,85,117],"interest":[11],"to":[12,40,53,123],"both":[13],"academia":[14],"industry.":[16],"However,":[17],"they":[18],"have":[19],"received":[20],"little":[21],"attention":[22],"towards":[23],"improving":[24],"the":[25,41,54,69,77,111,118],"knowledge":[26,36,116],"about":[27],"associated":[29],"faults":[30,80,97,120],"failures.":[32,82],"This":[33],"lack":[34],"is":[37,92,121],"an":[38,72],"impediment":[39],"definition":[42],"adequate":[44],"software":[45],"testing":[46,126],"techniques":[47],"applicable":[48],"in":[49],"this":[50],"domain":[51],"development":[55],"quality":[57],"software.":[58],"We":[59],"discuss":[60],"issues":[61],"arising":[62],"from":[63],"SQL":[64],"manipulation":[65,119],"failures":[66],"present":[68],"results":[70],"investigation":[73],"aiming":[74],"at":[75],"understanding":[76],"relationship":[78],"between":[79,96],"The":[83],"analysis":[84],"data":[86],"mapping":[87,95],"indicates":[88],"that:":[89],"i)":[90],"there":[91],"a":[93],"many-to-many":[94],"failures;":[99],"ii)":[100],"failure":[101],"dimensions":[102],"dependent":[104],"on":[105],"fault":[106],"type,":[107],"faulty":[108],"command,":[109],"database":[112,127],"itself;":[113],"iii)":[115],"crucial":[122],"programming":[124],"applications.":[128]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}