Extending ER model clustering by relationship clustering
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.
KeywordsEntity Type Relationship Type Business Function Aggregation Type Entity Relationship
Unable to display preview. Download preview PDF.
- [CaJA89]Carlson, C. R.; Ji, W.; Arora, A. K.: The nested entity-relationship model — A pragmatic approach to E-R comprehension and design layout, in Lochovsky, F.H. (Ed.): Proc. of the 8th Intern. Conf. on Entity-Relationship Approach, Toronto, Canada 1989, North-Holland 1990, 43–58Google Scholar
- [Mart89]Martin, J.: Information Engineering, Book I: Introduction, Prentice Hall, Englewood Cliffs, New Jersey, 1989Google Scholar
- [Mist91]Mistelbauer, H.: Datenmodellverdichtung: Vom Projektdatenmodell zur Unternehmensarchitektur, Wirtschaftsinformatik 33 (1991), No. 4, 289–299 (in German)Google Scholar
- [RaSt92]Rauh, O.; Stickel, E.: Entity tree clustering — A method for simplifying ER design, in Pernul, G.; Tjoa A. M. (Eds.): Proc. of the 11th Intern. Conf. on Entity-Relationship Approach, Karlsruhe, Germany 1992, Springer-Verlag 1992, 62–78Google Scholar
- [ScSt83]Schlageter, G.; Stucky, W.: Datenbanksysteme: Konzepte und Modelle, 2. Auflage, B. G. Teubner, Stuttgart, 1983 (in German)Google Scholar
- [ScSW79]Scheuermann, P.; Schiffner, G.; Weber, H.: Abstraction capabilities and invariant properties modelling within the entity-relationship approach, in Chen, P.P. (Ed.): Proc. of the Intern. Conf. on Entity-Relationship Approach, Los Angeles, California, USA 1979, North-Holland 1980, 121–140Google Scholar