Entity-relationship and object-oriented data modeling - An experimental comparison of design quality

Peretz Shoval, Sagit Shiran

Research output: Contribution to journalArticlepeer-review

64 Scopus citations


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.

Original languageEnglish
Pages (from-to)297-315
Number of pages19
JournalData and Knowledge Engineering
Issue number3
StatePublished - 1 Jan 1997


  • Conceptual schema
  • Data modeling
  • Database design
  • Entity relationship model
  • Experimentation
  • Object oriented model
  • Quality of design
  • Schema transformation

ASJC Scopus subject areas

  • Information Systems and Management


Dive into the research topics of 'Entity-relationship and object-oriented data modeling - An experimental comparison of design quality'. Together they form a unique fingerprint.

Cite this