Abstract
Completeness is one of the important measures for semantic quality of a conceptual model, an ER model in our case. In this paper, a complete methodology is presented to measure completeness quantitatively. This methodology identifies existence of functional dependencies in the given conceptual model and transforms it into a multi-graph using the transformation rules proposed in this paper. This conversion can be helpful in implementing and automating computation of quality metrics for a given conceptual model. The new Fuzzy Completeness Index (FCI) introduced in this paper adopts an improved approach over Completeness Index proposed by authors in the previous research. FCI takes into account the extent a functional dependency has its representation in the conceptual model even when it is not fully represented. This partial representation of a functional dependency is measured using the fuzzy membership values and fuzzy hedges. The value of FCI varies between 0 and 1, where 1 represents a model that incorporates all the functional dependencies associated with it. Computation of FCI is demonstrated for a number of conceptual models. It is illustrated that the quality in terms of completeness can effectively be measured and compared through the FCI based approach.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Lindland, O., Sindre, G., Solvberg, A.: Understanding Quality in Conceptual Modeling. IEEE Software 11(2), 42–49 (1994)
Moody, D.L., Shanks, G.G.: What Makes a Good Data Model? Evaluating the Quality of Entity Relationship Models. In: Proceedings of the 13th Int’l Conf. on the Entity Relationship Approach, pp. 94–111 (1994)
Moody, D.L., Shanks, G.G., Darke, P.: Improving the Quality of Entity Relationship Models – Experience in Research and Practice. In: Ling, T.-W., Ram, S., Li Lee, M. (eds.) ER 1998. LNCS, vol. 1507, pp. 255–276. Springer, Heidelberg (1998)
Kesh, S.: Evaluating the Quality of Entity Relationship Models. Information and Software Technology 37(12), 681–689 (1995)
Schuette, R., Rotthowe: The Guidelines of Modeling – An Approach to Enhance the Quality in Information Models. In: Ling, T.-W., Ram, S., Li Lee, M. (eds.) ER 1998. LNCS, vol. 1507, pp. 255–276. Springer, Heidelberg (1998)
Assenova, P., Johannesson, P.: Improving Quality in Conceptual Modelling by the Use of Schema Transformations. In: ACM SIGMOD 15th Int’l Conf. On Conceptual Modeling 1996, pp. 277–291 (1996)
Thalheim, B.: Entity-Relationship Modeling: Foundations of Database Technology. Springer, Heidelberg (2000)
Krogstie, J., Lindland, O., Sindre, G.: Towards a Deeper Understanding of Quality in Requirements Engineering. In: Proceedings of the 17th Int’l Conf. on Advanced Information Systems Engineering (CAISE) 1995, pp. 82–95 (1995)
Gray, R., Carey, B., McGlynn, N., Pengelly, A.: 1991) Design metrics for database systems. BT Technology 9(4), 69–76 (1991)
Moody, D.L.: Metrics for Evaluating the Quality of Entity Relationship Models. In: Ling, T.-W., Ram, S., Li Lee, M. (eds.) ER 1998. LNCS, vol. 1507, pp. 213–225. Springer, Heidelberg (1998)
Piattini, M., Genero, M., Jimenez: A Metric-Based Approach For Predicting Conceptual Data Models Maintainability. Int’l Journal of Software Engineering & Knowledge Engineering 11(6), 703–729 (2001)
Hussain, T., Shamail, S., Awais, M.: Schema Transformations – A Quality Perspective. In: Proceedings of 8th Int’l Multi-Topic Conf., IEEE INMIC 2004, pp. 645–649 (2004)
Ross, T.J.: Fuzzy Logic with Engineering Applications. McGraw-Hill, New York (1995)
Cormen, T., Leiserson, C., Rivest, R., Stein, C.: Introduction to Algorithms, 2nd edn. MIT Press, Cambridge (2001)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Hussain, T., Awais, M.M., Shamail, S. (2005). A Fuzzy Based Approach to Measure Completeness of an Entity-Relationship Model. In: Akoka, J., et al. Perspectives in Conceptual Modeling. ER 2005. Lecture Notes in Computer Science, vol 3770. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11568346_44
Download citation
DOI: https://doi.org/10.1007/11568346_44
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-29395-8
Online ISBN: 978-3-540-32239-9
eBook Packages: Computer ScienceComputer Science (R0)