Open Access Open Access  Restricted Access Subscription or Fee Access

Database Test Management Made Effective through Metrics

P. Prameela, A. Askarunisa, Dr. N. Ramaraj

Abstract


In majority of software applications, Database systems play an important role. They are becoming increasingly complex and are subject to constant change. Test management of such a database application is a very complex task. The increase in both application complexity and reliability expectation has contributed to great demands on database testing activities.This paper, deals with managing the process of testing a Database, through automated testing which will ensure that test management time is not wasted and aids in better decision-making. We have proposed an effective automated test framework that manages testing of database applications thereby reducing the various resource attributes such as people, cost, time during the test process. This framework also ensures quality in the test management process by reducing the manual work. We have measured the effectiveness of the test process through various metrices that enhances the quality of the process. We have implemented the test process for six different database applications and their effectiveness computed through metrices.

Keywords


Test Management, Database Testing, Test Cases, Coverage Tree Metrics, Command Form Metrics.

Full Text:

PDF

References


M. Y. Chan and S.C.Cheung, Testing Database Applications with SQL Semantics, In the Proceedings of 2nd International Symposium on Cooperative Database Systems for Advanced Applications(codas’99), Wollongong, Australia, March 1999,pp. 363-374.

D. Chays, P. Frankl, et al. “A Framework for Testing Database Application” ACM International Symposium on Software Testing and Analysis, Portland, Oregon, 2000.

Edward Hung, Testing of Database Applications, the University of Maryland, college park.2001.

David Chays, Yuetang Deng. Demonstration of AGENDA Tool set for testing relational database applications. Proceedings of the 25th International Conference on Software Engineering (ICSE’03)2003 IEEE.

Yuetang Deng Phyllis Frankl Zhongqiang Chen. Testing Database Transaction Concurrency. Proceedings of the 18th IEEE International Conference on Automated Software Engineering (ASE’03) 2003 IEEE.

Xintao Wu, Chintan Sanghvi, Yongge Wang, Yuliang Zheng.Privacy Preserving Database Application Testing. WPES’03, October 30, 2003, Washington, DC, USA.2003 ACM.

Ramkrishna Chatterjee, Gopalan Arun, Sanjay Agarwal, Ben Speckhard, and Ramesh Vasudevan. Using Applications of Data Versioning in Database Application Development. Proceedings of the 26th International Conference on Software Engineering (ICSE’04)2004 IEEE.

S. K. Gardikiotis, N. Malevris, T. Konstantinou. A Structural Approach Towards the Maintenance of Database Applications. Proceedings of the International Database Engineering and Applications Symposium (IDEAS’04)2004 IEEE.

Yuetang Deng, Phyllis Frankl, David Chays. Testing Database Transactions with AGENDA. ICSE'05, May 15-21, 2005, St. Louis, Missouri, USA.2005 ACM

W.K. Chan, S.C. Cheung and T.H. Tse,“Fault-Based Testing of Database Application Programs with Conceptual Data Model”, to appear in the Proceedings of the 5th International Conference on Quality Software, 2005.IEEE Computer SocietyPress.

www.dbunit.org.

Gregory M. Kapfhammer, Mary Lou Soffa. A Family of Test Adequacy Criteria for Database-Driven Applications. ESEC/FSE’03, September 1–5, 2003, Helsinki, Finland.2003 ACM

Howden, "Weak Mutation Testing and Completeness of Test Sets", IEEE Trans. Software Eng., Vol.SE-8, No.4, July 1982, pp.371-379.

William G.J. Halfond and Alessandro Orso. Command-Form Coverage for Testing Database Applications. 21st IEEE International Conference on Automated Software Engineering (ASE'06) 2006 IEEE.

María José, Suárez-Cabal and Javier Tuya, Using an SQL coverage measurement for testing database applications, ACM SIGSOFT Software Engineering Notes, Volume 29, Issue 6, Pages: 253 262, November 2004.

Norman E Fenton, Martin Neil, “Software Metrics: Roadmap”.

Qaiser Durrani, " Role of Software Metrics in Software Engineering and Requirements Analysis ", 2005 IEEE.

Grady, R.B, Practical Software Metrics for ProjectManagement and Process Improvement, Prentice-Hall, 1992.

Roger S. Pressman, Software Engineering: A Practitioner's Approach

Dekkers, C. Demystifying function points: Let's understand some terminology. IT Metrics Strategies, Oct. 1998.

Chidamber, S. R. and Kemerer, R. F. A metrics suite for object-oriented design. IEEE Trans. Software Eng. 20, 6 (June 1994), 476-493.

John Joseph Chilenski and Steven P. Miller, "Applicability of Modified Condition/Decision Coverage to Software Testing", Software Engineering Journal, September 1994, Vol. 9, No. 5, pp.193-2000.


Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 License.