DMCA
An Intensional Approach to the Specification of Test Cases for Database Applications (2006)
| Venue: | In Proc. ICSE |
| Citations: | 24 - 0 self |
BibTeX
@INPROCEEDINGS{Willmor06anintensional,
author = {David Willmor},
title = {An Intensional Approach to the Specification of Test Cases for Database Applications},
booktitle = {In Proc. ICSE},
year = {2006},
pages = {102--111}
}
Share
 |
 |
 |
 |
||
OpenURL
Abstract
When testing database applications, in addition to creating in-memory fixtures it is also necessary to create an initial database state that is appropriate for each test case. Current approaches either require exact database states to be specified in advance, or else generate a single initial state (under guidance from the user) that is intended to be suitable for execution of all test cases. The first method allows large test suites to be executed in batch, but requires considerable programmer effort to create the test cases (and to maintain them). The second method requires less programmer effort, but increases the likelihood that test cases will fail in non-fault situations, due to unexpected changes to the content of the database. In this paper, we propose a new approach in which the database states required for testing are specified intensionally, as constrained queries, that can be used to prepare the database for testing automatically. This technique overcomes the limitations of the other approaches, and does not appear to impose significant performance overheads.
Keyphrases
test case database application intensional approach significant performance overhead second method single initial state first method initial database state exact database state in-memory fixture non-fault situation new approach large test suite considerable programmer effort unexpected change programmer effort constrained query
