Ivannikov Institute for System Programming of the RAS

Test data generation for covering functionality of database applications.


V. Omelchenko, S. Zelenov, E. Kostychev.


Applications for processing great volumes of data is a very widely used kind of software. In enterprise integration there are tasks of data integration. When solving these tasks, special tools supporting development and execution of applications implementing extract, transformation and load pattern are often used. From the point of view of functional testing, such applications have a specific peculiarity related to a huge number of combinations of input data. Existing approaches and tools solving the problem of test data generation for database application build large arrays of input data based on database scheme or on SQL queries of application under tests. To ensure covering functionality of an application under test using these approaches and tools, a brute force of all available combinations is needed. In the paper, we prpose a method allowing less excessive data generation for covering functionality of database applications. It allows achieving functionality coverage with acceptable amount of test data close to optimal one (one test per one functionality branch) in acceptable generation time.

Full text of the paper in pdf (in Russian)


Test data generation; database applications; functional testing; data integration; ETL-applications testing.


Proceedings of the 4th Spring/Summer Young Researchers' Colloquium on Software Engineering (SYRCoSE 2010), 2010, 43-49.

DOI: 10.15514/SYRCOSE-2010-4-8

ISBN 978-5-91474-015-0

Research Group

Software Engineering

All publications during 2010 All publications