Extending ER model clustering by relationship clustering

0
107

Authors: Andreas Oberweis, Peter Jaeschke, Wolffried Stucky

Tags: 1993, conceptual modeling

The entity relationship approach is a widely accepted method for conceptual database design. However, some problems arise if ER modelling is applied to the design of really large databases concerning whole enterprises. There is, e.g., no way to obtain a general view nor to perceive the global context of a detailed enterprise scheme with hundreds of entities and relationships. Different approaches use ER model clustering to overcome these problems. All approaches are based on an already existing detailed ER diagram. Based on this, the abstraction layers are built bottom-up. The approach proposed in this paper refines and extends the approaches mentioned above. It also takes into account the Nested Entity Relationship Model in order to refine relationship types. It can be used in a top-down database design process as well as in a bottom-up approach.

Read the full paper here: https://link.springer.com/chapter/10.1007/BFb0024387