Quality Software, International Conference on (2005)
Sept. 19, 2005 to Sept. 20, 2005
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/QSIC.2005.27
W. K. Chan , Hong Kong University of Science and Technology
S.C. Cheung , Hong Kong University of Science and Technology
T. H. Tse , University of Hong Kong
<p>Database application programs typically contain program units that use SQL statements to manipulate records in database instances. Testing the correctness of data manipulation by these programs is challenging. When a tester provides a database instance to test such a program, the program unit may output faulty SQL statements and, hence, manipulate inappropriate database records. Nonetheless, these failures may only be revealed in very specific database instances.</p> <p>This paper proposes to integrate SQL statements and the conceptual data models of an application for faultbased testing. It proposes a set of mutation operators based on the standard types of constraint used in the enhanced entity-relationship model. These operators are semantic in nature. This semantic information guides the construction of affected attributes and join conditions of mutants. The usefulness of our proposal is illustrated by an example in which a missing-record fault is revealed.</p>
database application testing, fault-based testing, semantic mutants.
T. H. Tse, S. Cheung and W. K. Chan, "Fault-Based Testing of Database Application Programs with Conceptual Data Model," Proceedings. Fifth International Conference on Quality Software (QSIC 2005)(QSIC), Melbourne, Victoria, Australia, 2005, pp. 187-196.