Query-based test generation for database applications

David Chays, John Shahid, Phyllis G. Frankl

    Research output: Chapter in Book/Report/Conference proceedingConference contribution

    Abstract

    This paper describes a new approach to generating inputs to database applications. The goal is to generate inputs that satisfy certain properties specified by the tester and that also cause queries to return non-empty result sets and cause updates and inserts to execute without violating uniqueness or referential integrity constraints. Based on the SQL statements in the application, test generation queries are generated; execution of these queries yields test inputs with the desired properties. The test generation algorithm is described and illustrated by an example. The technique has been implemented and experimental evaluation is in progress.

    Original languageEnglish (US)
    Title of host publicationDBTest 2008 - Proceedings of the 1st International Workshop on Testing Database Systems
    DOIs
    StatePublished - Dec 15 2008
    Event1st International Workshop on Testing Database Systems, DBTest 2008 - Vancouver, BC, Canada
    Duration: Jun 13 2008Jun 13 2008

    Publication series

    NameDBTest 2008 - Proceedings of the 1st International Workshop on Testing Database Systems

    Other

    Other1st International Workshop on Testing Database Systems, DBTest 2008
    CountryCanada
    CityVancouver, BC
    Period6/13/086/13/08

    Keywords

    • Database
    • Software testing

    ASJC Scopus subject areas

    • Computational Theory and Mathematics
    • Software

    Cite this

    Chays, D., Shahid, J., & Frankl, P. G. (2008). Query-based test generation for database applications. In DBTest 2008 - Proceedings of the 1st International Workshop on Testing Database Systems [6] (DBTest 2008 - Proceedings of the 1st International Workshop on Testing Database Systems). https://doi.org/10.1145/1385269.1385277