Faults and failures in SQL-based data manipulation programming
Carregando...
Data
2007-12
Título da Revista
ISSN da Revista
Título de Volume
Editor
Resumo
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
Descrição
Palavras-chave
Software testing, Fault enumeration, SQL-based applications, Database application testing, Software failures
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