Metrics for database systems: an empirical study

aut.researcherMacDonell, Stephen Gerard
dc.contributor.authorMacDonell, SG
dc.contributor.authorShepperd, MJ
dc.contributor.authorSallis, PJ
dc.date.accessioned2012-04-04T07:47:07Z
dc.date.available2012-04-04T07:47:07Z
dc.date.copyright1997
dc.date.issued1997
dc.description.abstractAn important task for any software project manager is to be able to predict and control project size and development effort. Unfortunately, there is comparatively little work, other than function points, that tackles the problem of building prediction systems for software that is dominated by data considerations, in particular systems developed using 4GLs. We describe an empirical investigation of 70 such systems. Various easily obtainable counts were extracted from data models (e.g. number of entities) and from specifications (e.g. number of screens). Using simple regression analysis, a prediction system of implementation size with accuracy of MMRE=21% was constructed. This approach offers several advantages. First there tend to be fewer counting problems than with function points since the metrics we used were based upon simple counts. Second, the prediction systems were calibrated to specific local environments rather than being based upon industry weights. We believe this enhanced their accuracy. Our work shows that it is possible to develop simple and useful local prediction systems based upon metrics easily derived from functional specifications and data models, without recourse to overly complex metrics or analysis techniques. We conclude that this type of use of metrics can provide valuable support for the management and control of 4GL and database projects
dc.identifier.citationProceedings of the Fourth International Software Metrics Symposium, (pp 99 - 107)
dc.identifier.doi10.1109/METRIC.1997.637170
dc.identifier.urihttps://hdl.handle.net/10292/3595
dc.publisherIEEE Computer Society Press
dc.rightsCopyright © 1997 IEEE. Personal use of this material is permitted. Permission from IEEE must be obtained for all other uses, in any current or future media, including reprinting/republishing this material for advertising or promotional purposes, creating new collective works, for resale or redistribution to servers or lists, or reuse of any copyrighted component of this work in other works.
dc.rights.accessrightsOpenAccess
dc.subjectMetrics
dc.subjectEntity-relationship models
dc.subject4GL
dc.subjectEmpirical analysis
dc.subjectPrediction systems
dc.titleMetrics for database systems: an empirical study
dc.typeConference Contribution
pubs.organisational-data/AUT
pubs.organisational-data/AUT/Design & Creative Technologies
pubs.organisational-data/AUT/Design & Creative Technologies/School of Computing & Mathematical Science
pubs.organisational-data/AUT/PBRF Researchers
pubs.organisational-data/AUT/PBRF Researchers/Design & Creative Technologies PBRF Researchers
pubs.organisational-data/AUT/PBRF Researchers/Design & Creative Technologies PBRF Researchers/DCT C & M Computing
Files
Original bundle
Now showing 1 - 1 of 1
Loading...
Thumbnail Image
Name:
MacDonell, Shepperd and Sallis (1997) Metrics.pdf
Size:
126.62 KB
Format:
Adobe Portable Document Format
Description:
License bundle
Now showing 1 - 1 of 1
Loading...
Thumbnail Image
Name:
licence.htm
Size:
29.98 KB
Format:
Unknown data format
Description: