ENTITY-RELATIONSHIP AND OBJECT-ORIENTED DATA MODELING - AN EXPERIMENTAL COMPARISON OF DESIGN QUALITY

We compare EER and OO data models from the point of view of design qua lity. Quality is measured in terms of (a) correctness of the conceptua l schemas being designed, (b) time to complete the design task, and (c ) designers' preferences of the models. Result of an experimental comp arison of the two models reveal that the EER model surpasses the OO mo del 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 sc hema, the recommended procedure is to: (1) create an EER conceptual sc heme, (2) map it to an OO schema, and augment the target schema with b ehavioral constructs that are unique to the 00 approach.