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.

[1]  Hong Zhu,et al.  Software unit test coverage and adequacy , 1997, ACM Comput. Surv..

[2]  Shing-Chi Cheung,et al.  Automatic generation of database instances for white-box testing , 2001, 25th Annual International Computer Software and Applications Conference. COMPSAC 2001.

[3]  Mary Lou Soffa,et al.  A family of test adequacy criteria for database-driven applications , 2003, ESEC/FSE-11.

[4]  Javier Tuya,et al.  Mejora de casos de prueba midiendo la cobertura de sentencias SQL , 2003, JISBD.

[5]  Javier Tuya,et al.  Using an SQL coverage measurement for testing database applications , 2004, SIGSOFT '04/FSE-12.

[6]  Gregory Tassey,et al.  Prepared for what , 2007 .

[7]  Javier Tuya,et al.  Improvement of test data by measuring SQL statement coverage , 2003, Eleventh Annual International Workshop on Software Technology and Engineering Practice.

[8]  Shing-Chi Cheung,et al.  Applying white box testing to database applications , 1999 .

[9]  Ramzi A. Haraty,et al.  Regression testing of database applications , 2001, SAC.

[10]  Alan Hartman.  Is ISSTA research relevant to industry? , 2002, ISSTA '02.

[11]  Elaine J. Weyuker,et al.  An AGENDA for testing relational database applications , 2004, Softw. Test. Verification Reliab..

[12]  Donald R. Slutz,et al.  Massive Stochastic Testing of SQL , 1998, VLDB.