Query-based test generation for database applications

David Chays, John Shahid, Phyllis 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 - 2008
    Event1st International Workshop on Testing Database Systems, DBTest 2008 - Vancouver, BC, Canada
    Duration: Jun 13 2008Jun 13 2008

    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. (2008). Query-based test generation for database applications. In DBTest 2008 - Proceedings of the 1st International Workshop on Testing Database Systems [6] https://doi.org/10.1145/1385269.1385277

    Query-based test generation for database applications. / Chays, David; Shahid, John; Frankl, Phyllis.

    DBTest 2008 - Proceedings of the 1st International Workshop on Testing Database Systems. 2008. 6.

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

    Chays, D, Shahid, J & Frankl, P 2008, Query-based test generation for database applications. in DBTest 2008 - Proceedings of the 1st International Workshop on Testing Database Systems., 6, 1st International Workshop on Testing Database Systems, DBTest 2008, Vancouver, BC, Canada, 6/13/08. https://doi.org/10.1145/1385269.1385277
    Chays D, Shahid J, Frankl P. Query-based test generation for database applications. In DBTest 2008 - Proceedings of the 1st International Workshop on Testing Database Systems. 2008. 6 https://doi.org/10.1145/1385269.1385277
    Chays, David ; Shahid, John ; Frankl, Phyllis. / Query-based test generation for database applications. DBTest 2008 - Proceedings of the 1st International Workshop on Testing Database Systems. 2008.
    @inproceedings{1a7df7309a7a4479a7c629330c49a16a,
    title = "Query-based test generation for database applications",
    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.",
    keywords = "Database, Software testing",
    author = "David Chays and John Shahid and Phyllis Frankl",
    year = "2008",
    doi = "10.1145/1385269.1385277",
    language = "English (US)",
    isbn = "9781605582337",
    booktitle = "DBTest 2008 - Proceedings of the 1st International Workshop on Testing Database Systems",

    }

    TY - GEN

    T1 - Query-based test generation for database applications

    AU - Chays, David

    AU - Shahid, John

    AU - Frankl, Phyllis

    PY - 2008

    Y1 - 2008

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

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

    KW - Database

    KW - Software testing

    UR - http://www.scopus.com/inward/record.url?scp=57349137665&partnerID=8YFLogxK

    UR - http://www.scopus.com/inward/citedby.url?scp=57349137665&partnerID=8YFLogxK

    U2 - 10.1145/1385269.1385277

    DO - 10.1145/1385269.1385277

    M3 - Conference contribution

    SN - 9781605582337

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

    ER -