Mutating database queries

A set of mutation operators for SQL queries that retrieve information from a database is developed and tested against a set of queries drawn from the NIST SQL Conformance Test Suite. The mutation operators cover a wide spectrum of SQL features, including the handling of null values. Additional exper...

Descripción completa

Detalles Bibliográficos
Autores: Tuya González, Pablo Javier|||0000-0002-1091-934X, Suárez Cabal, María José|||0000-0001-8262-2871, Riva Álvarez, Claudio A. de la|||0000-0001-5592-9683
Tipo de recurso: artículo
Fecha de publicación:2007
País:España
Institución:Universidad de Oviedo (UNIOVI)
Repositorio:RUO. Repositorio Institucional de la Universidad de Oviedo
Idioma:inglés
OAI Identifier:oai:digibuo.uniovi.es:10651/29255
Acceso en línea:http://hdl.handle.net/10651/29255
https://dx.doi.org/10.1016/j.infsof.2006.06.009
Access Level:acceso abierto
Palabra clave:Software testing
Database testing
SQL testing
Fault-based testing
Mutation testing
Test adequacy criteria
Descripción
Sumario:A set of mutation operators for SQL queries that retrieve information from a database is developed and tested against a set of queries drawn from the NIST SQL Conformance Test Suite. The mutation operators cover a wide spectrum of SQL features, including the handling of null values. Additional experiments are performed to explore whether the cost of executing mutants can be reduced using selective mutation or the test suite size can be reduced by using an appropriate ordering of the mutants. The SQL mutation approach can be helpful in assessing the adequacy of database test cases and their development, and as a tool for systematically injecting faults in order to compare different database testing techniques