Multi-RQP: generating test databases for the functional testing of OLTP applicationsCarsten Binnig; Donald Kossmann; Eric Lo
In: Leo Giakoumakis; Donald Kossmann (Hrsg.). Proceedings of the 1st International Workshop on Testing Database Systems. International Workshop on Testing Database Systems (DBTest-2008), June 13, Vancouver, BC, Canada, ACM, 2008.
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.