Data generation method of database system test based on reverse query process
Zang Kang · Journal of Computer Applications · 2011
It is important to generate test data and database state for database system testing.The algorithm of Reverse Query Processing(RQP) provides a method to generate test data for database system testing,but it can only be used to process the Select query.In order to address this limitation,RQP was expanded into RMP(Reverse Manipulate Processing) so that it can be used for all the data manipulation statement in SQL.The main idea of RMP was to transform DML statements,such as Delete,Insert,Update,into Select.That is to use Select to describe the conditions that the database instance should meet the requirement of testing DML statements.Then RQP gets the transformed Select statements as inputs and returns a possible database instance that satisfies the conditions.RMP can reversely process the fundamental SQL statements and provide better support to automatic data generation for database system test.