Coverage Measurement for SQL Queries

During last years, many researches on coverage measurements and software test case adequacy criteria have been conducted. These criteria are usually applied to test the code of programs written in imperative and structured languages. Nevertheless, there is little previous work that approaches these issues for applications where the information is stored in a database and it is handled through SQL queries. In this paper, a measurement of the coverage of SQL queries is defined as test adequacy criterion for this kind of applications. Using this criterion, we also show how test cases composed of one or more test databases and combinations of values for parameters are designed.