Regression Test Case Selection for Testing Database Applications
Vandana Sharma1, Arun Prakash Agrawal2
1Vandana Sharma, Department of Computer Science and Engineering, ASET, Amity University, Noida (U.P), India.
2Arun Prakash Agrawal, Assistant Professor, Department of Computer Science and Engineering, ASET, Amity University, Noida (U.P), India.
Manuscript received on 11 June 2013 | Revised Manuscript received on 17 June 2013 | Manuscript Published on 30 June 2013 | PP: 212-216 | Volume-3 Issue-1, June 2013 | Retrieval Number: A0963063113/13©BEIESP
Open Access | Editorial and Publishing Policies | Cite | Mendeley | Indexing and Abstracting
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC-BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: Regression testing is a part of software maintenance and it consumes about two-third of the overall software life cycle cost. It is the process of executing the full or partial test cases from the original test suite after any modifications to the original program. It tests both the modified code and other parts of the program that may be adversely affected by changes introduced in the program or a part of it. It is an expensive activity that is done whenever there are some changes in software. Regression testing tests both the modified code and other parts of the program that may be adversely affected by changes introduced in the program or a part of it. Test case selection selects the test cases to test the modified as well as unmodified part of the program from the original test suite. The regression testing of database applications concerns with the state of the database as it contributes too many components that increase the complexity of the applications because in case of database the test cases are not independent of each other and the database requires to be reset every time. The database applications are frequently modified due to the need of different requirements like, increase in number of users, components and data. Therefore regression testing of database applications is an essential activity as it requires maintaining the state of the database. It may be conducted either manually by re-executing a subset of all test cases of the original test suite or using automated tools. These tools enable the software testers to capture test cases and results for subsequent playback and comparison. In this paper, we have shown a study of the time taken in resets made to a database that is done manually or automatically with the help of various tools. We have also proposed the way in which the reset time of database state is reduced to a large extent. The database always requires to be reset after executing every query that too is done manually by the tester or with the help of some automated tool. In our work after reducing the reset time of database state we have presented the test cases with the details of the time taken in execution and code coverage of database application. Then the resulted test cases are selected from the original test cases that achieves the selection of maximum number of fault revealing test cases.
Keywords: Database Applications, Database Testing, Regression Testing, Regression Test case Selection, Software Testing.
Scope of the Article: Regression and Prediction