Use este identificador para citar ou linkar para este item: http://repositorio.bc.ufg.br/handle/ri/15140
Tipo do documento: Artigo
Título: Faults and failures in SQL-based data manipulation programming
Autor: Leitão Júnior, Plínio de Sá
Vilela, Plínio Roberto Souza
Jino, Mario
Abstract: Database 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 programming
Palavras-chave: Software testing
Fault enumeration
SQL-based applications
Database application testing
Software failures
País: Brasil
Unidade acadêmica: Instituto de Informática - INF (RG)
Citação: LEITÃ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. 2007
Tipo de acesso: Acesso Aberto
URI: http://repositorio.bc.ufg.br/handle/ri/15140
Data de publicação: Dez-2007
Aparece nas coleções:INF - Artigos publicados em periódicos

Arquivos associados a este item:
Arquivo Descrição TamanhoFormato 
Artigo - Plínio de Sá Leitão Júnior - 2007.pdf428,8 kBAdobe PDFThumbnail
Baixar/Abrir


Este item está licenciada sob uma Licença Creative Commons Creative Commons