Abstract
SQL is a ubiquitous language used in a wide range of applications for accessing the data stored in relational databases. However, the usual software testing techniques are not designed to address some important features of SQL. We present a set of practical guidelines for designing white-box tests cases that reasonably exercise the way in which an SQL query processes the stored data. These guidelines are illustrated using an example.
- S. Brass, C. Goldberg, "Semantic Errors in SQL Queries: A Quite Complete List". Journal of Systems and Software, 2005, in press. Google Scholar
Digital Library
- M. Y. Chan, S. C. Cheung, "Testing database applications with SQL semantics", 2nd International Symposium on Cooperative Database Systems for Advanced Applications, Springer, Singapore, 1999, pp. 363--374.Google Scholar
- D. Chays, Y. Deng, PG. Frankl, S. Dan, F. I. Vokolos, E. J. Weyuker, "An AGENDA for testing relational database applications", Software Testing, Verification and Reliability, Vol. 14(1), 2004, pp. 17--44. Google Scholar
Digital Library
- Y. Deng, P. Frankl, D. Chays, "Testing Database Transactions with AGENDA". 27th International Conference on Software Engineering, ACM Press, New York, NY, USA, 2005, pp. 78--87. Google Scholar
Digital Library
- N. Juristo, A. M. Moreno, S. Vegas, "Reviewing 25 Years of Testing Technique Experiments". Empirical Software Engineering, Vol. 9(1), 2004, pp. 7--44. Google Scholar
Digital Library
- G. M. Kapfhammer, M. L. Soffa, "A family of test adequacy criteria for database-driven applications". 9th European software engineering conference and the 11th ACM SIGSOFT international symposium on Foundations of software engineering, ACM Press, New York, NY, USA, 2003, pp. 98--107. Google Scholar
Digital Library
- H. Lu, H. C. Chan, K. K. Wei, "A Survey on Usage of SQL", SIGMOD Record, Vol. 22(4), 1993, pp. 60--65. Google Scholar
Digital Library
- T. J. Ostrand, M. J. Balcer, "The category-partition method for specifying and generating functional tests". Communications of the ACM, Vol. 31(6), 1988, pp. 676--686. Google Scholar
Digital Library
- M. J. Suárez-Cabal, J. Tuya, "Using an SQL Coverage Measurement for Testing Database Applications", ACM SIGSOFT Symposium on the Foundations of Software Engineering, ACM Press, NY, USA, 2004, pp. 253--262. Google Scholar
Digital Library
- D. Willmor, S. M. Embury, "Exploring test adequacy for database systems", Proceedings of the 3rd UK Software Testing Research workshop, 2005, pp. 123--133.Google Scholar
- Y. T. Yu, M. F. Lau, "A comparison of MC/DC, MUMCUT and several other coverage criteria for logical decisions". Journal of Systems and Software, 2005, in press. Google Scholar
Digital Library
- J. Zhang, C. Xu, S. C. Cheung, "Automatic generation of database instances for white-box testing", 25th Annual International Computer Software and Applications Conference, IEEE Computer Society Press, Los Alamitos, CA, 2001, pp. 161--165. Google Scholar
Digital Library
Index Terms
A practical guide to SQL white-box testing
Recommendations
A controlled experiment on white-box database testing
Controlled experiments are a powerful way to assess and compare the effectiveness of different techniques. In this paper we present the experimental results of the evaluation of the effectiveness of a structural test coverage criterion developed for SQL ...
Using an SQL coverage measurement for testing database applications
Many software applications have a component based on database management systems in which information is generally handled through SQL queries embedded in the application code. When automation of software testing is mentioned in the research, this is ...
Constraint-based test database generation for SQL queries
AST '10: Proceedings of the 5th Workshop on Automation of Software TestPopulating test databases with meaningful test data is a difficult task as it involves generating data for many joined tables that must be diverse enough to be able to reveal faults and small enough to make the testing process efficient. This paper ...






Comments