Covering functionality of database applications by generating special data
Abstract
Software processing huge volumes of data is the one of the most used kind of software. In particular it is an important part of enterprise integration called data integration. There are tools supporting development and execution of applications implementing extract, transformation and load pattern. In regard of functional testing of such applications there is a specific is a number of combinations of input data. There are tools supporting test data generation for database application on the basis on schemes of databases or SQL queries of application under tests. Using their one can ensure the functionality covering only by means of a brute force of all available combinations. We propose a method reducing excessiveness of data generation. By means of the method the functionality coverage is achieved with fewer amounts of test data that is close to optimal (one set of test data for one functionality branch).
About the Authors
Evgeny Kostychev
ISP RAS, Moscow
Russian Federation
Russian Federation
Vitaly Omelchenko
ISP RAS, Moscow
Russian Federation
Russian Federation
Sergey Zelenov
ISP RAS, Moscow
Russian Federation
Russian Federation
References
1. British National Corpus (BNC), 2009, http://www.natcorp.ox.ac.uk/corpus/index.xml
2. . N. Oostdijk and P. Haan, Corpus-Based Research into Language. In honour of Jan Aarts, Amsterdam/Atlanta, GA, 1994, VII.
3. M. L. Songini, QuickStudy: Extract, Transform and Load (ETL), 2004, Computerworld, http://www.computerworld.com/s/article/89534/QuickStudy_ETL
4. DTM Data Generator, test data generator for database testing purposes, 2004, http://www.sqledit.com/dg/
5. Test Data Generator - TurboData - "Out of the Box", 2009, http://www.turbodata.ca/
6. DBMonster - The dbMonster home page – About, 2003, http://dbmonster.kernelpanic.pl/
7. D. Chays, Y. Deng, P.G. Frankl, E.J. Weyuker, An AGENDA for testing relational database applications, Software testing, verification and reliability, 2004, VOL 14; PART 1, pages 17-44
8. C. Binnig, D. Kossmann, E. Lo, Testing database applications, 2006, Proceedings of the 25th ACM SIGMOD international conference on management of data / Principles of database systems, Chicago
9. А.В. Демаков, С.В. Зеленов, С.А. Зеленова. Генерация тестовых данных сложной структуры с учетом контекстных ограничений. // Труды ИСП РАН, 2006, том 9, 83–96.
10. А.В. Демаков, С.В. Зеленов, С.А. Зеленова. Генератор сложных данных Pinery: реализация новых возможностей UniTESK // Труды ИСП РАН, Москва, 2008, т. 14, часть 1, 119–136.
11. А.В. Демаков, С.В. Зеленов, С.А. Зеленова. Использование абстрактных моделей для генерации тестовых данных сложной структуры // Программирование, Москва, 2008, том. 34, № 6, 341–350.
12. В. В. Кулямин, А. К. Петренко, А. С. Косачев, И. Б. Бурдонов. Подход UniTesK к разработке тестов. Программирование, 29(6):25-43, 2003.
13. А. В. Баранцев, И. Б. Бурдонов, А. В. Демаков, С. В. Зеленов, А. С. Косачев, В. В. Кулямин, В. А. Омельченко, Н. В. Пакулин, А. К. Петренко, А. В. Хорошилов. Подход UniTesK к разработке тестов: достижения и перспективы. // Труды ИСП РАН, 2004, том. 5, 121–156.
14. UniTESK, индустриальная технология надежного тестирования, 2006, http://unitesk.ru/
15. В. В. Кулямин, Н. В. Пакулин, О. Л. Петренко, А. А. Сортов, А. В. Хорошилов. Формализация требований на практике. // Препринт ИСП РАН. М.: ИСП РАН, 2006.
Review
For citations:
Kostychev E., Omelchenko V., Zelenov S. Covering functionality of database applications by generating special data. Proceedings of the Institute for System Programming of the RAS (Proceedings of ISP RAS). 2011;20. (In Russ.)
Email this article 