Metaschemas for ER, ORM and UML data models: A comparison

0
96

Authors: Terry Halpin

Tags: 2002, conceptual modeling

This paper provides metaschemas for some of the main database modeling notations used in industry. Two entity relationship (ER) notations are examined in detail, as well as object role modeling conceptual schema diagrams. The discussion of optionality, cardinality and multiplicity is widened to include unified modeling language (UML) class diagrams. Issues addressed in the metamodel analysis include the normalization impact of non-derived constraints on derived associations, the influence of orthogonality on language transparency, and trade-offs between simplicity and expressibility. To facilitate comparison, the same modeling notation is used to display each metaschema. For this purpose, ORM is used because of its greater expressibility and clarity.

Read the full paper here: https://www.igi-global.com/journal/journal-database-management