Database Reference
In-Depth Information
Figure 10: Call Graph example
3
and
W
is the component composed of
(2, 4)
,
(3, 4)
and
(5, 7),
for which every test case
passing through these pairs must be retested.
EMPIRICAL RESULTS
Support System
We have implemented a database applications maintenance tool as a support system
for the empirical work. The tool helps database application maintainers understand these
applications, identify code changes, support software updates, and enhance and detect
change effects. It mainly helps create a test environment and select regression test cases to
be rerun when a change is made to the application using our two-phase regression testing
methodology. The system is implemented for Oracle database applications programmed
using PL/SQL language. Our maintenance tool is composed of fi ve parts: module analysis,
database analysis, test environment setup, Impact Analysis and regression test selection, and
test case reduction. Test case reduction simply refers to including phase 2 algorithms.
Module Analysis
Module analysis involves building syntax trees for a module and then using these syntax
trees to gather control fl ow information and database components usage information. The
module information gathered is displayed to help in understanding the module's functional-
ity. Performing all these tasks requires a mechanism of storing the results in one step and
