Maintainability Predictors for Relational Database-Driven Software Applications: Extended Results from a Survey

Software maintainability is a very important quality attribute. Its prediction for relational database-driven software applications can help organizations improve the maintainability of these applications. The research presented herein adopts a survey-based approach where a survey was conducted with 40 software professionals aimed at identifying and ranking the important maintainability predictors for relational database-driven software applications. The survey results were analyzed using frequency analysis. The results suggest that maintainability prediction for relational database-driven applications is not the same as that of traditional software applications in terms of the importance of the predictors used for this purpose. The results also provide a baseline for creating maintainability prediction models for relational database-driven software applications.

[1]  A. Maule,et al.  Impact analysis of database schema changes , 2008, 2008 ACM/IEEE 30th International Conference on Software Engineering.

[2]  Margo I. Seltzer,et al.  Beyond Relational Databases , 2005, ACM Queue.

[3]  Margo I. Seltzer.  Beyond relational databases , 2008, CACM.

[4]  Emilia Mendes,et al.  Investigating Web size metrics for early Web cost estimation , 2005, J. Syst. Softw..

[5]  Mario Piattini,et al.  Using Metrics to Predict OO Information Systems Maintainability , 2001, CAiSE.

[6]  Ewan D. Tempero,et al.  Maintainability Prediction for Database-driven Software Applications - Preliminary Results from Interviews with Software Professionals , 2010, SEDE.

[7]  Tom Mens,et al.  Data-Intensive System Evolution , 2010, Computer.

[8]  Yuetang Deng,et al.  Testing database transactions with AGENDA , 2005, Proceedings. 27th International Conference on Software Engineering, 2005. ICSE 2005..

[9]  T. Konstantinou,et al.  A structural approach towards the maintenance of database applications , 2004, Proceedings. International Database Engineering and Applications Symposium, 2004. IDEAS '04..

[10]  Stephen R. Schach,et al.  An empirical investigation of the impact of the object-oriented paradigm on the maintainability of real-world mission-critical software , 2005, J. Syst. Softw..

[11]  Ewan D. Tempero,et al.  Towards Maintainability Prediction for Relational Database-Driven Software Applications: Evidence from Software Practitioners , 2010, FGIT-ASEA.

[12]  Ewan D. Tempero,et al.  Maintainability Predictors for Relational Database-Driven Software Applications: Results from a Survey , 2011, SEKE.

[13]  Russell R. Barton,et al.  Implementing a relational database for an accelerated-life-test facility , 1994 .

[14]  Gautam Shroff,et al.  Influencing factors in outsourced software maintenance , 2006, SOEN.

[15]  Phyllis G. Frankl,et al.  Testing database transactions with AGENDA , 2005, Proceedings. 27th International Conference on Software Engineering, 2005. ICSE 2005..

[16]  Mehwish Riaz,et al.  A systematic review of software maintainability prediction and metrics , 2009, ESEM 2009.

[17]  Paul W. Oman,et al.  Construction and testing of polynomials predicting software maintainability , 1994, J. Syst. Softw..

[18]  Timothy J. Heintz.  Object-oriented databases and their impact on future business database applications , 1991, Inf. Manag..

[19]  Mehwish Riaz,et al.  Maintainability prediction for relational database-driven software applications , 2012 .

[20]  E. F. CODD,et al.  A relational model of data for large shared data banks , 1970, CACM.

[21]  Elaine Ferneley.  Design metrics as an aid to software maintenance: an empirical study , 1999 .