Multi-RQP: generating test databases for the functional testing of OLTP applications

OLTP applications usually implement use cases which execute a sequence of actions whereas each action usually reads or updates only a small set of tuples in the database. In order to automatically test the correctness of the different execution paths of the use cases implemented by an OLTP application, a set of test cases and test databases needs to be created. In this paper, we suggest that a tester specifies a test database individually for each test case using SQL as a declarative test database specification language. Moreover, we also discuss the design of a database generator which creates a test database based on such a specification. Consequently, our approach allows to generate a tailor-made test database for each test case and to bundle them together for the test case execution phase.