Experimental Comparisons of Entity-Relationship and Object Oriented Data Models
AbstractThe extended entity-relationship (EER) model is being "threatened" by the object-oriented (OO) approach, which penetrates into the areas of system analysis and data modeling. The issue of which of the two data models is better for data modeling is still an open question. We address the question by conducting experimental comparisons between the models. The results of our experiments reveal that: a) schema comprehension: ternary relationships are significantly easier to comprehend in the EER model than in the OO model; b) the EER model supasses the OO model for designing unary and ternary relationships; c) time: it takes less time to design EER schemas; d) preferences: the EER model is preferred by designers. We conclude that even if the objective is to implement an OO database schema, the following procedure is still recommended: 1) create an EER conceptual schema, 2) map it to an OO schema, and c) augment the OO schema with behavioral constructs that are unique to the OO approach.
Copyright (c) 1969 Peretz Shoval
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
AJIS publishes open-access articles distributed under the terms of a Creative Commons Non-Commercial and Attribution License which permits non-commercial use, distribution, and reproduction in any medium, provided the original author and AJIS are credited. All other rights including granting permissions beyond those in the above license remain the property of the author(s).