Skip to main content
Springer Nature Link
Log in

Measuring for Database Programs Maintainability

  • Conference paper
  • First Online:
Database and Expert Systems Applications (DEXA 2000)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1873))

Included in the following conference series:

  • 1796 Accesses

Abstract

Nowadays, relational databases are introduced in most of the Information Systems, becoming their essential core. The relational database language, SQL, is being increasingly used for application development. Software engineers have been putting forward huge quantities of measures for software products, processes and resources. Unfortunately, almost all the measures proposed until now, have focused on 3GL program characteristics disregarding databases and their associated languages. Only a few author have proposed some metrics for 4GL effort estimation. In this article we describe three simple measures for assessing SQL code maintainability. Both an experiment with students and a real case in a state owned organization have empirically validated these measures as maintainability indicators.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. Eisenberg, A. and Melton, J.: SQL: 1999, formerly know as SQL3. SIGMOD Record, 28(1) (1999) 131–138.

    Article  Google Scholar 

  2. Card, D.N. and Glass, R.L.: Measuring Software Design Quality. Eglewood Cliffs. USA (1990).

    Google Scholar 

  3. Pigoski, T.M.: Practical Software Maintenance. Wley Computer Publishing. New York, USA (1997).

    Google Scholar 

  4. Briand, L.C., Morasca, S. and Basili, V.: Property-based software engineering measurement. IEEE Transactions on Software Engineering, 22(1) (1996) 68–85.

    Article  Google Scholar 

  5. Fenton, N. and Pfleeger, S. L.: Software Measures: A Rigorous Approach 2nd edition. Cpman&Hall. London (1997).

    Google Scholar 

  6. Melton, A. (ed.).: Software Measurement. Iternational Thomson Computer Press. London (1996).

    MATH  Google Scholar 

  7. Sneed, H.M. and Foshag, O.: Measuring Legacy Database Structures. Proc of The European Software Measurement Conference FESMA 98, Antwerp, May 6–8, Coombes, Van Huysduynen and Peeters (eds.), (1998) 199–211.

    Google Scholar 

  8. Henderson-Sellers, B.: Object-Oriented Measures-Measures of complexity. Prentice-Hall, Upper Saddle River, New Jersey(1996).

    Google Scholar 

  9. Bourque, P. and Côté, V.: An experiment in software sizing with structured analysis measures. Journal of Systems and Software15 (1991) 159–172.

    Article  Google Scholar 

  10. Dolado, J.J.: A Study of the Relationships among Albrecht and Mark II Function Points, Lines of Code 4GL and Effort. J. Systems Software, 37 (1990) 161–173.

    Article  Google Scholar 

  11. Verner J. and Tate G.: Estimating Size and Effort in Fourth-Generation Development. IEEE Trans. on Software Engineering(1988) 15–22.

    Google Scholar 

  12. ISO/IEC 9126: Information Technology-Software Product Evaluation-Quality characteristics and guidelines for their use, International Organization for standardisation (1994).

    Google Scholar 

  13. Li, H.F. and Cheng, W.K. An empirical study of software measures. IEEE Trans. on Software Engineering, 13(6) (1987) 679–708.

    Google Scholar 

  14. Cant, S. N., Jeffery, D.R., and Henderson-Sellers, B.: A concept model of cognitive complexity of element of the programming process. Information and Software Technology. 37(7) (1995) 351–362.

    Article  Google Scholar 

  15. Pfleeger, S. L.: Experimental Design and Analysis in Software Engineering. Annals of Software Engineering. JC. Baltzer AG, Science Publishers 1 (1995) 219–253.

    Article  Google Scholar 

  16. Briand, L., Bunse, D., Daly, J. and Differding, C: An experimental comparison of the Maintainability of Object-Oriented and Structured Design Documents, Proc. Int. Conference on Software Maintenance, Harold, M.J. Visaggio, G. (eds), Bari, 13 (1997) 130–138.

    Google Scholar 

  17. MacDonell, G., Shepperd, J. and Sallis, J.: Measures for Database Systems: An Empirical Study. IEEE Software(1997) 99–107

    Google Scholar 

  18. Neil, M.: Measurement as an Alternative to Bureaucracy for the Achievement of Software Quality. Software Quality Journal3(2), (1994) 65–78.

    Article  Google Scholar 

  19. Glass, R.: The Relationship Between Theory and Practice in Sotfware Engineering. IEEE Software, November, 39(11) (1996) 11–13.

    Google Scholar 

  20. Zuse, H.: A framework of software measurement. Walter De Gruyter (1998).

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Research Group ALARCOS Departamento de Informática, University of Castilla-La Mancha, Ronda de Calatrava, 5, 13071, Ciudad Real, Spain

    Mario Piattini & Antonio Martinez

  2. EXCMA. Diputacion de Ciudad Real, Calle Toledo, 17, 13001, Ciudad Real, Spain

    Antonio Martinez

Authors
  1. Mario Piattini
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Antonio Martinez
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computing and Mathematical Sciences, Maritime Greenwich University Campus, 30 Park Row, London, SE10 9LS, UK

    Mohamed Ibrahim

  2. University of Linz, FAW, Altenbergerstr. 69, 4040, Linz, Austria

    Josef Küng

  3. Middlesex University, Bounds Green, London, UK

    Norman Revell

Rights and permissions

Reprints and permissions

Copyright information

© 2000 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Piattini, M., Martinez, A. (2000). Measuring for Database Programs Maintainability. In: Ibrahim, M., Küng, J., Revell, N. (eds) Database and Expert Systems Applications. DEXA 2000. Lecture Notes in Computer Science, vol 1873. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-44469-6_7

Download citation

  • DOI: https://doi.org/10.1007/3-540-44469-6_7

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-67978-3

  • Online ISBN: 978-3-540-44469-5

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics