Published February 1, 2009 | Version v1

Structural Coverage Criteria for Testing SQL Queries

  • 1. University of Oviedo, Oviedo, Spain

Description

Adequacy criteria provide an objective measurement of test quality. Although these criteria are a major research issue in software testing, little work has been specifically targeted towards the testing of database-driven applications. In this paper, two structural coverage criteria are provided for evaluating the adequacy of a test suite for SQL queries that retrieve information from the database. The first deals with the way in which the queries select and join information from different tables and the second with the way in which selected data is further processed. The criteria take into account both the structure and the data loaded in the database, as well as the syntax and semantics of the query. The coverage criteria are subsequently used to develop test inputs of queries drawn from a real-life application. Finally, a number of issues related to the kind of faults that can be detected and the size of the test suite are discussed.

Files

jucs_article_29325.pdf

Files (343.5 kB)

Name Size
md5:6c3c3d4932a4dc71913e2207a556a6cb
343.5 kB Preview Download