Teste estrutural de programas de aplicação de banco de dados relacional

Abstract

An approach is proposed for structural testing of programs of Relational Database Applications (RDA) with embedded SQL.An application is regarded as a set of programs and each program as a set of units.Due to the nature of RDA two data-flow models are proposed: intra-modular and inter-modular.The intra-modular data flow model addresses the unit testing and the integration testing of each program.The inter-modular data flow model addresses the integration testing of RDA's programs.Unit testing can be supported by any structural unit testing criterion of procedural programs.Two approaches are proposed for the intra-modular integration testing: testing based on the call-graph and testing based on data dependence.Criteria based on the intra-modular and inter-modular data flow models are presented and discussed with examples of their application; results from experiments are also presented and discussed.Analyses of the complexity of those vi criteria show them to be of exponential order, in the worst case.However, results from their application indicate that they demand a small number of test cases.