Author: Klaus Haller
Published in: Proceedings of the Second International Workshop on Testing Database Systems (DBTest ’09)

Abstract.White-box testing is an important part of every software testing and quality assurance strategy. Testing database-driven applications requires the adoption of white-box testing, but it is not clear what adoption is needed. Instead of focusing on a single problem and a possible solution, this paper elaborates all of the main challenges from a practitioner’s view. Starting with a generic testing process, we analyze for each process step whether and, if so, which adoptions are needed, and redefine the concepts of test cases and coverage. We discuss test database state generation methods and the problem of scheduling test cases efficiently. Thereby, we provide a road map for the emerging domain of testing database-driven applications and for making such testing useful for commercial software development.

Read the full paper:
Klaus Haller: The Test Data Challenge for Database-Driven Applications (DB Test 2010) – download from ACM Digital Library
Klaus Haller: The Test Data Challenge for Database-Driven Applications (DB Test 2010) – local download