Defining and validating metrics for assessing the understandability of entity-relationship diagrams

Data and Knowledge Engineering

Volumn 64, Issue 3, 2008, Pages 534-557

  Genero, Marcela ^a   Poels, Geert ^b   Piattini, Mario ^a  

^a UNIVERSITY OF CASTILLA LA MANCHA   (Spain)

^b GHENT UNIVERSITY   (Belgium)

Author keywords

Conceptual data modelling; ER diagram; Experimental validation; Measurement theory; Metrics; Structural properties; Understandability

Indexed keywords

COMPUTER SIMULATION; DATA STRUCTURES; MATHEMATICAL MODELS; MEASUREMENT THEORY;

CONCEPTUAL DATA MODELING; ENTITY-RELATIONSHIP (ER) DIAGRAMS; EXPERIMENTAL VALIDATION;

DATABASE SYSTEMS;

EID: 38649103513     PISSN: 0169023X     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.datak.2007.09.011     Document Type: Article

References (65)

1. Abrial J. Data Semantics. IFIP TC2 Conference (1974), North Holland, Amsterdam
2. Bandi R., Vaishnavi V., and Turk D. Predicting maintenance performance using object-oriented design complexity metrics. IEEE Transactions on Software Engineering 29 1 (2003) 77-87
3. Basili V., and Rombach H. The TAME project: towards improvement-oriented software environments. IEEE Transactions on Software Engineering 14 6 (1988) 728-738
4. Basili V., and Weiss D. A methodology for collecting valid software engineering data. IEEE Transactions on Software Engineering 10 (1984) 728-738
5. Basili V., Shull F., and Lanubile F. Building knowledge through families of experiments. IEEE Transactions on Software Engineering 25 4 (1999) 435-437
6. S. Benlarbi, K. El-Emam, N. Goel, S. Rai, Thresholds for object-oriented measures, NRC/ERB 1073, 2000.
7. Bodart F., Patel A., Sim M., and Weber R. Should optional properties be used in conceptual modelling? A theory and three empirical tests. Information System Research 12 4 (2001) 384-405
8. Boehm B. Software Engineering Economics (1981), Prentice-Hall
9. Briand L., Bunse C., and Daly J. A controlled experiment for evaluating quality guidelines on the maintainability of object-oriented designs. IEEE Transactions on Software Engineering 27 6 (2001) 513-530
10. Briand L., and Wüst J. Empirical studies of quality models in object-oriented systems. In: Zelkowitz M. (Ed). Advances in Computers vol. 59 (2002), Academic Press 97-166
11. L. Briand, J. Wüst, S. Ikonomovski, H. Lounis, Investigating quality factors in object-oriented designs: An industrial case-study, in: 21st International Conference on Software Engineering, Los Angeles, CA, 1999, pp. 345-354.
12. Briand L., Wüst J., and Lounis H. Replicated case studies for investigating quality factors in object-oriented designs. Empirical Software Engineering 6 1 (2001) 11-58
13. A. Burton-Jones, R. Weber, Understanding relationships with attributes in entity-relationship diagrams, in: 20th Annual International Conference on Information Systems (ICIS'99), Charlotte, NC, USA, 1999, pp. 214-228.
14. Chen P. The entity-relationship model: toward a unified view of data. ACM Transactions on Database Systems 1 1 (1976) 9-37
15. Davies I., Green P., Rosemann M., Indulska M., and Gallo S. How do practitioners use conceptual modeling in practice?. Data and Knowledge Engineering 58 (2006) 358-380
16. De Miguel A., and Piattini M. Fundamentos y modelos de bases de datos. second ed. (1999), Ra-Ma, Madrid
17. De Miguel A., Piattini M., and Marcos E. Diseño de bases de datos relacionales (1999), Ra-Ma, Madrid
18. C. Eick, Lockermann, Acquisition of terminological knowledge using database design techniques, in: ACM-SIGMOD Conference on Management of Data, 1985, pp. 84-94.
19. Eick C., and Raupp T. Towards a formal semantics and inference rules for conceptual data models. Data and Knowledge Engineering 6 (1991) 297-317
20. C. Eick, A methodology for the design and transformation of conceptual schemas, in: 17th International Conference on Very Large Data Bases, 1991, pp. 25-34.
21. K. El-Emam, The prediction of faulty classes using object-oriented design metrics, NRC/ERB1064, National Research Council Canada, 1999.
22. K. El-Emam, Object-oriented metrics: a review on theory and practice, NRC/ERB 1085, National Research Council Canada, 2001.
23. El-Emam K., Benlarbi S., Goel N., and Rai S. The confounding effect of class size on the validity of object-oriented metrics. IEEE Transactions on Software Engineering 27 7 (2001) 630-650
24. Elmasri R., and Navathe S. Fundamentals of Database Systems. second ed. (1994), Addison-Wesley, Massachussets
25. Enders A., and Rombach H.D. A handbook of Software and Systems Engineering: Empirical Observations, Laws and Theories (2003), Addison-Wesley
26. J. Erickson, K. Siau, Theoretical and practical complexity of UML, in: Tenth Americas Conference on Information Systems, New York, USA, 2004, pp. 1669-1674.
27. Fenton N. Software measurement: a necessary scientific basis. IEEE Transactions on Software Engineering 20 3 (1994) 199-206
28. Fenton N., and Pfleeger S. Software Metrics: A Rigorous Approach. second ed. (1997), Chapman & Hall, London
29. Fioravanti F., and Nesi P. Estimation and prediction metrics for adaptive maintenance effort of object-oriented systems. IEEE Transactions on Software Engineering 27 12 (2001) 1062-1083
30. V. French, Establishing software metric thresholds, International Workshop on Software Measurement (IWSM'99), 1999.
31. Gemino A., and Wand Y. Complexity and clarity in conceptual modeling: comparison of mandatory and optional properties. Data and Knowledge Engineering 55 (2005) 301-326
32. M. Genero, Defining and validating measures for conceptual models, Ph.D. Thesis, Department of Computer Science, University of Castilla-La Mancha, Spain, 2002.
33. Genero M., Manso MaE., Visaggio A., Canfora G., and Piattini M. Building a metric-based prediction model for UML class diagram maintainability. Empirical Software Engineering 12 5 (2007) 517-549
34. Gray R., Carey B., McGlynn N., and Pengelly A. Design metrics for database systems. BT Technology 9 4 (1991)
35. Hammer M., and McLeod D. Database description with SDM: a semantic database model. ACM TODS 6 3 (1981) 351-386
36. Harrison R., Counsell S., and Nithi R. Experimental assessment of the effect of inheritance on the maintainability of object-oriented systems. The Journal of Systems and Software 52 (2000) 173-179
37. D. Ince, M. Shepperd, Algebraic validation of software metrics, ESEC 1991, 1991.
38. ISO 9126, Software product evaluation-quality characteristics and guidelines for their use, ISO/IEC Standard 9126, Geneva, 2001.
39. Kesh S. Evaluating the quality of entity relationship models. Information and Software Technology 37 12 (1995) 681-689
40. Krantz D., Luce R., Suppes P., and Tversky A. Foundations of Measurement vol. 1 (1971), Academic Press, New York
41. J. Krogstie, O. Lindland, G. Sindre, Towards a deeper understanding of quality in requirements engineering, in: Proceedings of the Seventh International Conference on Advanced Information Systems Engineering (CAISE 1995), Jyvaskyla, Finland, 1995, pp. 82-95.
42. Li W., and Henry S. Object-oriented metrics that predict maintainability. Journal of Systems and Software 23 2 (1993) 111-122
43. Lindland O., Sindre A., and Solvberg A. Understanding quality in conceptual modeling. IEEE Software 11 2 (1994) 42-49
44. Maes A., and Poels G. Evaluating quality of conceptual modelling scripts based on user perceptions. Data and knowledge Engineering (2007) 10.1016/j.datak.2007.04.008
45. aE. Manso, M. Genero, M. Piattini, No-redundant metrics for UML class diagrams structural complexity, in: J. Eder, M. Missikoff, (Eds.), CAISE 2003, Lecture Notes in Computer Science, vol. 2681, Springer-Verlag, 2003, pp. 127-142.
46. D. Moody, Metrics for evaluating the quality of entity relationship models, in: Seventeenth International Conference on Conceptual Modelling (E/R'98), Singapore, 1998, pp. 213-225.
47. Moody D., and Shanks G. Improving the quality of data models, information systems. Empirical Validation of a Quality Management Framework 28 6 (2003) 619-650
48. D. Moody, G. Shanks, P. Darke, Improving the quality of entity relationship models - experience in research and practice, in: Seventeenth International Conference on Conceptual Modelling (ER'98), Singapore, 1998, pp. 255-276.
49. Moody D.L. Theoretical and practical issues in evaluating the quality of conceptual models: current state and future directions. Data and Knowledge Engineering 55 3 (2005) 243-276
50. Muller R. Database Design for Smarties. Using UML for Data Modelling (1999), Morgan Kaufman, San Francisco
51. Nelson J., Poels G., Genero M., and Piattini M. Quality in conceptual modeling - five examples of the state of art. Data and Knowledge Engineering 55 3 (2005) 237-242
52. A. Olivé, Specific relationship types in conceptual modeling: the cases of generic and with common participants, unpublished keynote lecture, in: Fourth International Conference on Enterprise Information Systems (ICEIS'02), Ciudad Real, Spain, 2002, .
53. OMG (Object Management Group), Unified Modeling Language (UML) Specification, Version 1.4. Object Management Group (OMG), 2001.
54. Pippinger N. Complexity theory. Scientific American 238 6 (1978) 1-15
55. G. Poels, On the formal aspects of the measurement of object-oriented software specifications, Ph.D. Thesis, Faculty of Economics and Business Administration. Katholieke Universiteit Leuven, Belgium, 1999.
56. Poels G., and Dedene G. Distance-based software measurement: necessary and sufficient properties for software measures. Information and Software Technology 42 1 (2000) 35-46
57. G. Poels, G. Dedene, Evaluating the effect of inheritance on the modifiability of object-oriented business domain models, in: Fifth European Conference on Software Maintenance and Reengineering (CSMR 2001), Lisbon, Portugal, 2001, pp. 20-28.
58. Poels G., Gailly F., Maes A., and Paemeleire R. Object class or association class? Testing the user effect on cardinality interpretation. Lecture Notes in Computer Science 3770 (2005) 33-42
59. R. Schuette, T. Rotthowe, The guidelines of modeling - an approach to enhance the quality in information models, in: Seventh International Conference on Conceptual Modelling (ER'98), 1998, pp. 240-254.
60. Shaft T., and Vessey I. The role of cognitive fit in the relationship between software comprehension and modification. MIS Quarterly 30 1 (2006) 29-55
61. Shanks G., Tansley E., and Weber R. Using ontology to validate conceptual models. Communications of the ACM 46 (2003) 85-89
62. Si-Said Cherfi, J. Akoka, I. Comyn-Wattiau, Conceptual modelling quality - from EER to UML schemas evaluation, in: 21st International Conference on Conceptual Modeling (ER 2002), Tampere, Finland, 2002, pp. 499-512.
63. Suppes P., Krantz D., Luce R., and Tversky A. Foundations of measurement: geometrical. Threshold and Probabilistic Representations vol. 2 (1989), Academic Press, San Diego
64. Wand Y., and Weber R. An ontological model of an information system. IEEE Transactions on Software Engineering 16 11 (1990) 1282-1292
65. Wohlin C., Runeson P., Höst M., Ohlson M., Regnell B., and Wesslén A. Experimentation in Software Engineering: An Introduction (2000), Kluwer Academic Publishers