Automated test plan generator for database application systems

Abstract

As database applications increase in size and complexity, the development of usable test plans to test application software becomes essential. These testing plans must establish the applications' correctness and consistency as well as its reliability from the human expectation viewpoint. The designed automated/manual testing procedure integrated into the design phase, automates the generation of test plans for the comprehensive coverage of all details and timely updating, reducing the overall testing time and standardizing results. Human intervention remains to ascertain semantic nuances, ambiguities and user interface inconsistencies. A minimal set of test objects defines the test classes while a taxonomy categorizes the necessary tests and demonstrates the breadth and depth of the verification and validation procedures. Analysis of our experimental testing results showed the keystone to be the test plan, a data driven conceptual level, procedural document certifying the semantics, syntax and interfaces of a specific database application. A Test Plan Generator was constructed using C++ to generate a set of precise test plans from the design schema.