Test case reduction based on the join condition in pairwise coverage-based database testing

Yuper Lay Myint, Hironori Washizaki, Yoshiaki Fukazawa, Hideyuki Kanuka, Hiroki Ohbayashi

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

    Abstract

    Testing database applications correctly and effectively remains an issue. This study improves Selected Pairwise Coverage Testing (SPCT), which is a pairwise coverage-based test method for database applications that can discover bugs not detected by conventional methods. Because SPCT considers only selected columns in the SQL query and the conditions in the simple WHERE clause, achieving full pairwise coverage has some redundancies. In this work, we propose a new pairwise coverage-based test method, Join-based Pairwise Coverage Testing (JPCT) by considering the condition in the JOIN clause to further reduce the redundant parameter combinations. The experimental results are evaluated to con?rm the effectiveness of the proposed method, JPCT compared to SPCT.

    Original languageEnglish
    Title of host publicationProceedings - 2018 IEEE 11th International Conference on Software Testing, Verification and Validation Workshops, ICSTW 2018
    PublisherInstitute of Electrical and Electronics Engineers Inc.
    Pages239-243
    Number of pages5
    ISBN (Electronic)9781538663523
    DOIs
    Publication statusPublished - 2018 Jul 16
    Event11th IEEE International Conference on Software Testing, Verification and Validation Workshops, ICSTW 2018 - Vasteras, Sweden
    Duration: 2018 Apr 92018 Apr 13

    Other

    Other11th IEEE International Conference on Software Testing, Verification and Validation Workshops, ICSTW 2018
    CountrySweden
    CityVasteras
    Period18/4/918/4/13

    Keywords

    • Database testing
    • Pairwise coverage

    ASJC Scopus subject areas

    • Software
    • Safety, Risk, Reliability and Quality

    Fingerprint Dive into the research topics of 'Test case reduction based on the join condition in pairwise coverage-based database testing'. Together they form a unique fingerprint.

  • Cite this

    Lay Myint, Y., Washizaki, H., Fukazawa, Y., Kanuka, H., & Ohbayashi, H. (2018). Test case reduction based on the join condition in pairwise coverage-based database testing. In Proceedings - 2018 IEEE 11th International Conference on Software Testing, Verification and Validation Workshops, ICSTW 2018 (pp. 239-243). Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/ICSTW.2018.00055