JISBD04 - Generación de bases de datos de prueba para consultas SQL (JISBD04 - Populating Test Databases for Testing SQL Queries)

María José Suárez-Cabal (cabal@uniovi.es), Claudio de la Riva (claudio@uniovi.es), Javier Tuya (tuya@uniovi.es)

Universidad de Oviedo
This paper appears in: Revista IEEE América Latina

Publication Date: April 2010
Volume: 8,   Issue: 2 
ISSN: 1548-0992

An approach to automatically generate test data for SQL queries is described in this paper. Both the database schema and queries to be tested are used to guide the generation. The different test situations on the queries are identified using a condition coverage criterion and they are represented with a set of constraints that the information in the database must fulfill. Instances of a database that satisfy the constraints and thus constitute a test database are generated using the Alloy toolset. A case study of a real-life application is presented to illustrate and evaluate this work.

Index Terms:
Alloy toolset, database testing, full predicate coverage criterion, MCDC criterion, test data generation, software testing, SQL.   

Documents that cite this document
This function is not implemented yet.

[PDF Full-Text (296)]