OO and EER Conceptual Schemas: A Comparison of User Comprehension

OO and EER Conceptual Schemas: A Comparison of User Comprehension

Peretz Shoval, Israel Frumermann
Copyright: © 1994 |Pages: 11
DOI: 10.4018/jdm.1994100103
OnDemand:
(Individual Articles)
Available
$37.50
Current Special Offers
No Current Special Offers
TOTAL SAVINGS: $37.50

Abstract

A database conceptual schema serves as a communication medium between professional analysts/designers and users who wish to comprehend and validate the conceptual schema. The conceptual schema is usually presented in a diagrammatic form that follows a specific semantic data model. The extended entity-relationship (EER) model is one of the most commonly used models, but being “threatened” by the objectoriented (OO) approach, which penetrates into the areas of systems analysis and design, as well as data modeling. The issue of which of the two data models is better for modeling reality and is easier to comprehend is still an open question. Our response to this question was to conduct a controlled experiment in which two groups of users, each trained to use one of the models, were tested for the comprehension of equivalent schema diagrams. Comprehension was measured by the number of correct answers to questions that addressed different constructs of the models. The results of the experiment reveal that there is no significant difference in comprehension of facts dealing with attributes of entities or objects, binary-relationships and two relationships, but those dealing with ternary-relationships are significantly easier to comprehend with the EER model. Comprehension of other, unclassified facts, however, is easier with the OO model. We propose a special symbol for objects representing ternary and higher order relationships in order to overcome the weakness of OO diagrams.

Complete Article List

Search this Journal:
Reset
Volume 35: 1 Issue (2024)
Volume 34: 3 Issues (2023)
Volume 33: 5 Issues (2022): 4 Released, 1 Forthcoming
Volume 32: 4 Issues (2021)
Volume 31: 4 Issues (2020)
Volume 30: 4 Issues (2019)
Volume 29: 4 Issues (2018)
Volume 28: 4 Issues (2017)
Volume 27: 4 Issues (2016)
Volume 26: 4 Issues (2015)
Volume 25: 4 Issues (2014)
Volume 24: 4 Issues (2013)
Volume 23: 4 Issues (2012)
Volume 22: 4 Issues (2011)
Volume 21: 4 Issues (2010)
Volume 20: 4 Issues (2009)
Volume 19: 4 Issues (2008)
Volume 18: 4 Issues (2007)
Volume 17: 4 Issues (2006)
Volume 16: 4 Issues (2005)
Volume 15: 4 Issues (2004)
Volume 14: 4 Issues (2003)
Volume 13: 4 Issues (2002)
Volume 12: 4 Issues (2001)
Volume 11: 4 Issues (2000)
Volume 10: 4 Issues (1999)
Volume 9: 4 Issues (1998)
Volume 8: 4 Issues (1997)
Volume 7: 4 Issues (1996)
Volume 6: 4 Issues (1995)
Volume 5: 4 Issues (1994)
Volume 4: 4 Issues (1993)
Volume 3: 4 Issues (1992)
Volume 2: 4 Issues (1991)
Volume 1: 2 Issues (1990)
View Complete Journal Contents Listing