Structural Testing of Integration of Relational Database Application Programs

• Edmundo Sérgio Spoto UNIVEM
• Plínio de Sá Leitão Junior UNICAMP
• Mario Jino UNICAMP
• José Carlos Maldonado USP

DOI: https://doi.org/10.5753/sbqs.2005.16166

Abstract

The search for quality in Relational Database Applications (RDA) involves the definition of testing approaches that consider persistent data flow. The structural testing technique is based on the internal structure of programs; it is applied in the unit testing of programs and in the integration testing of those units. This work explores the analysis of persistent dataflow in RDA, to determine requirements for structural integration testing. Specifically, an approach is proposed for the structural integration testing of programs with embedded SQL, where the persistence of data establishes data flow associations. The approach considers intra-modular and inter-modular integration testing to define test requirements. The testing criteria proposed are based on the call structure of units and on the exclusive data dependence, focused on the relationships of persistent dataflow.

Keywords: Structural Testing, Program Integration, Relational Database Application

References

Chaim, M. L. “Poke-tool – Uma Ferramenta para Suporte ao Teste Estrutural de Programas Baseado em Análise de Fluxo de Dados”, Dissertação de Mestrado, DCA/FEE/UNICAMP, Campinas – SP – Brasil, Abril 1991.

Chays, D., Dan, S., Frankl, P.G., Vokolos, F.I., Weyuker, E.J. “A Framework for Testing Database Applications”. Proceedings of the ISSTA ́00-, Agosto, 2000, pp. 147-157.

Chays, D., Deng, Y., “Demonstration of AGENDA Tool Set for Testing Relational Database Applications”, Proc. of The Intl. Symposium on Software Engineering, Porland, Oregon, 2003.

Clarke, L. A., Podgurski, A., Richardson, D. J., Zeil, S.J., “A Formal Evaluation of Data Flow Path Selection Criteria”, IEEE TSE, 15(11), Novembro, 1989, pp. 1318-1332.

Leitão, P. S. J., Vilela, P. R. S., Jino, Mario, “Mapping Faults to Failures in SQL Manipulation Commands”, ACS/IEEE Intl. Conference on Computer Systems and Applications, Cairo, Egypt, 3-6 January, 2005.

Maldonado, J. C.; Chaim, M. L., Jino, M. “Seleção de Casos de Testes Baseada nos Critérios Potenciais Usos”, II SBES, Canela, RS, Brasil, Outubro, 1988, pp.24-35.

Maldonado, J. C., “Critérios Potenciais Usos: Uma Contribuição ao Teste Estrutural de Software”, Tese de Doutorado, DCA/FEEC/UNICAMP, Campinas, SP, Brasil, Julho, 1991.

Rapps, S., Weyuker, E.J., “Data Flow Analysis Techniques for Test Data Selection”, in Intl. Conf. on Soft. Eng., pp. 272-278, Tokio, Japan, Setembro., 1982.

Rapps, S., Weyuker, E.J., “Selection of Software Test Data Using Data Flow Information”, IEEE TSE, SE-11(4), Abril, 1985.

Spoto, E. S., Jino, M., Maldonado, J. C. “Teste Estrutural de Software: Uma abordagem para Aplicação de Banco de Dados Relacional”, SBES’00, XIV SBES, João Pessoa – PB, pp. 243-258, Outubro, 2000.

Spoto, E. S., “Teste Estrutural de Programas de Aplicação de Banco de Dados Relacional”, Tese de Doutorado, DCA/FEEC/UNICAMP, Campinas, SP, Brasil, Dezembro, 2000.

Wu, X., Wang,Y., Zheng, Y. “Privacy Preserving Database Application Testing”, ACM – WPES ́03, October, 2003 – Washington – USA.