Faults and failures in SQL-based data manipulation programming

Página do item simplificado
dc.creatorLeitão Júnior, Plínio de Sá
dc.creatorVilela, Plínio Roberto Souza
dc.creatorJino, Mario
dc.date.accessioned2018-06-05T10:54:57Z
dc.date.available2018-06-05T10:54:57Z
dc.date.issued2007-12
dc.description.abstractDatabase applications, including SQL-based applications, have received little attention directed towards improving the knowledge of their possible faults. This paper deals with issues related to software faults and failures aiming at understanding what types of faults occur in SQL manipulation commands, and how they are propagated to the output of command execution. SQL manipulation commands are studied and their structure is organized into structural items, a step towards understanding and grouping fault types. A list of manipulation fault types is determined and presented with SQL command examples. Failure dimensions are discussed along with query and state changing operations. An experiment to abstract the types of manipulation faults for SQL was carried out and the results are presented. The experiment built databases and faulty commands to promote failure in command execution. A database was built and a set of faulty SQL commands used to map fault types and failure dimensions. The analysis of data mapping indicates: i) there is a many-to-many mapping between faults and failures; ii) failure dimensions are dependent on fault type, faulty command, and the database itself; and iii) manipulation fault knowledge is crucial for SQL programming and testing of database applications. This work represents an initial step for testing SQL programmingpt_BR
dc.identifier.citationLEITÃO JÚNIOR, Plínio de Sá; VILELA, Plínio Roberto Souza; JINO, Mario. Faults and failures in SQL-based data manipulation programming. InfoComp: journal of computer science, Lavras, v. 6, n. 4, p. 70-79, Dec. 2007pt_BR
dc.identifier.issne- 1982-3363
dc.identifier.urihttp://repositorio.bc.ufg.br/handle/ri/15140
dc.language.isoengpt_BR
dc.publisher.countryBrasilpt_BR
dc.publisher.departmentInstituto de Informática - INF (RG)pt_BR
dc.rightsAcesso Abertopt_BR
dc.subjectSoftware testingpt_BR
dc.subjectFault enumerationpt_BR
dc.subjectSQL-based applicationspt_BR
dc.subjectDatabase application testingpt_BR
dc.subjectSoftware failurespt_BR
dc.titleFaults and failures in SQL-based data manipulation programmingpt_BR
dc.typeArtigopt_BR

Arquivos

Pacote Original
Agora exibindo 1 - 1 de 1
Imagem de Miniatura
Nome:
Artigo - Plínio de Sá Leitão Júnior - 2007.pdf
Tamanho:
428.8 KB
Formato:
Adobe Portable Document Format
Baixar
Licença do Pacote
Agora exibindo 1 - 1 de 1
Nenhuma Miniatura disponível
Nome:
license.txt
Tamanho:
1.71 KB
Formato:
Item-specific license agreed upon to submission
Descrição:
Baixar

Coleções

INF - Artigos publicados em periódicos