JISBD04 - Populating Test Databases for Testing SQL Queries

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 wi...

Full description

Saved in:
Bibliographic Details
Published in:Revista IEEE América Latina 2010-04, Vol.8 (2), p.164-171
Main Authors: Suarez-Cabal, Maria Jose, Riva, Claudio de la, Tuya, Javier
Format: Article
Language:English
Subjects:
Criteria
Queries
Query languages
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary: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.
ISSN:1548-0992
1548-0992
DOI:10.1109/TLA.2010.5514443