Abstract
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 normally associated with programs written in imperative and structured languages. However, the problem of automated software testing applied to programs that manage databases using SQL is still an open issue. This paper presents a measurement of the coverage of SQL queries and the tool that automates it. We also show how database test data may be revised and changed using this measurement by means of completing or deleting information to achieve the highest possible value of coverage of queries that have access to the database.
- ANSI/ISO/IEC International Standard (IS). Database Language SQL-Part 2: Foundation (SQL/Foundation). "Part 2". 1999.Google Scholar
- Chan, M.Y. and Cheung, S.C. Applying white box testing to database applications. CSTR, Hong Kong University of Science and Technology, HKUST-CS99-01. 1999.Google Scholar
- Chays D., Deng, Y., Frankl, P.G., Dan S., Vokolos, F.I. and Weyuker, E.J. An AGENDA for testing relational database applications. Software Testing, Verification and Reliability. 14 17--44. 2004. Google ScholarDigital Library
- Davies, R.A., Beynon, R.J.A. and Jones, B.F. Automating the testing of databases. 1st International Workshop of Automated Program Analysis, Testing and Verification. 2000.Google Scholar
- Daou, B., Haraty, R.A. and Mansour, N. Regression testing of database applications. Symposium of Applied Computing. ACM. 2001. Google ScholarDigital Library
- Encontre, V. Empowering the developer to be a tester tool. Int. Symposium on Software Testing and Analysis, Industry panel. ACM SIGSOFT Software Engineering Notes. 2002.Google Scholar
- Hartman, A. Is ISSTA research relevant to industry? Int. Symposium on Software Testing and Analysis, Industry panel. ACM SIGSOFT Software Engineering Notes. 2002. Google ScholarDigital Library
- Kapfhammer, G.M. and Soffa, M.L. A family of test adequacy criteria for database-driven applications. ESEC/FSE'03. ACM SIGSOFT Software Engineering Notes. 2003. Google ScholarDigital Library
- Slutz, D. Massive Stochastic Testing of SQL. 24th Very Large Data Base Conference. 1998. Google ScholarDigital Library
- SQLUnit Project. http://sqlunit.sourceforge.netGoogle Scholar
- Tassey, G. The economic impacts of inadequate infrastructure for software testing. National Institute of Standards and Technology. Planning Report 02-3. 2002.Google Scholar
- Zang, J., Xu, C. and Cheung, S. C. Automatic generation of database instances for white-box testing. 25th International Computer Software and Applications Conference. 2001. Google ScholarDigital Library
- Zhu, H., Hall, P. A. V., May, J. H. R. Software Unit Test Coverage and Adequacy. ACM Computing Surveys, 49(4) 366--427. 1997. Google ScholarDigital Library
Index Terms
- Using an SQL coverage measurement for testing database applications
Recommendations
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 ...
Using an SQL coverage measurement for testing database applications
SIGSOFT '04/FSE-12: Proceedings of the 12th ACM SIGSOFT twelfth international symposium on Foundations of software engineeringMany 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 ...
Mutating database queries
A set of mutation operators for SQL queries that retrieve information from a database is developed and tested against a set of queries drawn from the NIST SQL Conformance Test Suite. The mutation operators cover a wide spectrum of SQL features, ...
Comments