Academic
Publications
Entity-Relationship and Object-Oriented Data Modeling-an Experimental Comparison of Design Quality

Entity-Relationship and Object-Oriented Data Modeling-an Experimental Comparison of Design Quality,10.1016/S0169-023X(97)88935-5,Data & Knowledge Engi

Entity-Relationship and Object-Oriented Data Modeling-an Experimental Comparison of Design Quality   (Citations: 40)
BibTex | RIS | RefWorks Download
We compare EER and OO data models from the point of view of design quality. Quality is measured in terms of (a) correctness of the conceptual schemas being designed, (b) time to complete the design task, and (c) designers' preferences of the models. Result of an experimental comparison of the two models reveal that the EER model surpasses the OO model for designing unary and ternary relationships, it takes less time to design EER schemas, and the EER model is preferred by designers. We conclude that even if the objective is to implement an OO database schema, the recommended procedure is to: (1) create an EER conceptual scheme, (2) map it to an OO schema, and augment the target schema with behavioral constructs that are unique to the OO approach.
Journal: Data & Knowledge Engineering - DKE , vol. 21, no. 3, pp. 297-315, 1997
Cumulative Annual
View Publication
The following links allow you to view full publications. These links are maintained by other sources not affiliated with Microsoft Academic Search.
    • ...Among these are data modeling [4, 43], knowledge modeling [10, 32], business process modeling [3, 48], or – in its broadest sense – enterprise modeling [17, 47]...

    Jan vom Brockeet al. Neuroscience in Design-Oriented Research: Exploring New Potentials

    • ...The major problem is to create a good conceptual schema that is semantically correct and comprehensible (Shoval and Shiran 1997)...
    • ...In the last decades several controlled experiments have been carried out to compare the ER and OO notations from a designer perspective (Shoval and Shiran 1997; Shoval and Frumermann 1994; Bock and Ryan 1993; Palvia et al. 1992)...
    • ...Finally, the size of the data models is small compared to industrial cases, but it is comparable with the size of models used in other related experimentations (see, for instance, Shoval and Shiran 1997 ;B riand et al.2005; Ricca et al. 2007)...
    • ...This is also confirmed by the fact that previous empirical studies also used similar approaches to measure the same attributes (see for instance Shoval and Shiran 1997; Shoval and Frumermann 1994 ;B ock and Ryan1993; Palvia et al. 1992; Ricca et al. 2007)...
    • ...To the best of our knowledge only four papers analyse and compare Entity-Relationship (ER), or its extensions, and Objected-Oriented (OO) models (Shoval and Shiran 1997; Shoval and Frumermann 1994; Bock and Ryan 1993; Palvia et al. 1992)...
    • ...Shoval and Shiran (1997) compare Extended ER (EER) and OO data models from the point of view of design quality, where quality is measured in terms of correctness of the produced models, time to completely perform the design task, and designers’ opinions...
    • ...Shoval and Shiran (1997) Design quality Designer No difference EER better than UML considering ternary and unary relationships...

    Andrea De Luciaet al. An experimental comparison of ER and UML class diagrams for data model...

    • ...Entity-Relationship (ER) model has long been the most popular medium to express conceptual requirements [9]...

    Ravi Ramdoyalet al. Reverse Engineering User Interfaces for Interactive Database Conceptua...

    • ...The related studies are summarized in Table 1. Many studies addressed structural [19], [20], [21], [22], [23] and behavioral [18], [24] system models and database conceptual models [25]...

    Dizza Beimelet al. The Context and the SitBAC Models for Privacy Preservation—An Experime...

    • ...Although several empirical studies [5], [21], [27], [28] have been carried out to compare the ER and OO notations during database design, actual benefits given by the ER diagrams have not been highlighted to justify the real need of preferring this notation for data modelling...
    • ...Among them, to the best of our knowledge only four analyse and compare Entity-Relationship (ER), or its extensions, and Objected-Oriented (OO) models [5], [21], [28], [27]...
    • ...Shoval and Shiran [28] compare Extended ER (EER) and OO data models from the point of view of design quality, where quality is measured in terms of correctness of the produced models, time to perform completely the design task, and designers’ opinions...

    Andrea De Luciaet al. Data Model Comprehension: An Empirical Comparison of ER and UML Class ...

Sort by: