A framework for efficient regression tests on database applications

Abstract

Regression testing is an important software maintenance activity to ensure the integrity of a software after modification. However, most methods and tools developed for software testing today do not work well for database applications; these tools only work well if applications are stateless or tests can be designed in such a way that they do not alter the state. To execute tests for database applications efficiently, the challenge is to control the state of the database during testing and to order the test runs such that expensive database reset operations that bring the database into the right state need to be executed as seldom as possible. This work devises a regression testing framework for database applications so that test runs can be executed in parallel. The goal is to achieve linear speed-up and/or exploit the available resources as well as possible. This problem is challenging because parallel testing needs to consider both load balancing and controlling the state of the database. Experimental results show that test run execution can achieve linear speed-up by using the proposed framework.

Efficient regression testing of ontology-driven systems

“…Because nodes labeled "8" exist in both G and G , they are matched nodes. However, P ropOut(8) = P ropOut(8 ) (line 12): P ropOut (8) in G is { 8, 10, p2 } whereas P ropOut(8 ) in G is { 8, 9, p2 }. Thus, lines 13-15 are invoked.…”

“…We eliminated redundant queries that used the same ontology terms and logical operators, which resulted in 1331 unique test queries that we used as our test suite for the studies. We also measured the coverage achieved by this test suite in terms of the ontology classes that it exercises, directly and indirectly, 8 and found that it covers 99.99% of the i2b2 ontology entities, as reported in Table 3. Our collaborators within the AIW project confirmed that these public test queries are structurally similar to those used during the development of the AIW project.…”

“…9 GO is updated daily in the BioPortal. We used version 1.1.2132 as our base ontology, v0, and selected five versions that were updated at various intervals after v0 (from 1 day to 1.5 months): va to ve.…”

“…Haftmann and colleagues [9] introduced an efficient regression-test-selection technique for database applications. They investigated executing tests in parallel and reducing database resets for database applications with improved running time of tests and reduced resources.…”

“…They investigated executing tests in parallel and reducing database resets for database applications with improved running time of tests and reduced resources. Another technique of Haftmann and colleagues [8] is an efficient regressiontesting technique that controls the order of test execution to address the limitation of the existing test tools not designed for database applications. Our work is related to theirs in that the goal of the research is to reduce the time required for regression testing.…”