Abstract
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.
Preview
Unable to display preview. Download preview PDF.
Bibliography
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–58
Chen, P. P.: The entity-relationship model: Toward a unified view of data, ACM Transactions on Database Systems 1 (1976), No.1, 166–192
Feldman, P.; Miller, D.: Entity model clustering: Structuring a data model by abstraction, The Computer Journal 29 (1986), No. 4, 348–360
Martin, J.: Information Engineering, Book I: Introduction, Prentice Hall, Englewood Cliffs, New Jersey, 1989
Mistelbauer, H.: Datenmodellverdichtung: Vom Projektdatenmodell zur Unternehmensarchitektur, Wirtschaftsinformatik 33 (1991), No. 4, 289–299 (in German)
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–78
Schlageter, G.; Stucky, W.: Datenbanksysteme: Konzepte und Modelle, 2. Auflage, B. G. Teubner, Stuttgart, 1983 (in German)
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–140
Teorey, T. J.; Yang, D.; Fry, P. J.: A logical design methodology for relational database using the extended entity-relationship model, ACM Computing Surveys 18 (1986), No. 2, 197–222
Teorey, T. J.; Guangping, W.; Bolton, D. L.; Koenig, J. A.: ER model clustering as an aid for user communication and documentation in database design, Communications of the ACM 32 (1989), No. 8, 975–987
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Jaeschke, P., Oberweis, A., Stucky, W. (1994). Extending ER model clustering by relationship clustering. In: Elmasri, R.A., Kouramajian, V., Thalheim, B. (eds) Entity-Relationship Approach — ER '93. ER 1993. Lecture Notes in Computer Science, vol 823. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0024387
Download citation
DOI: https://doi.org/10.1007/BFb0024387
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-58217-5
Online ISBN: 978-3-540-48575-9
eBook Packages: Springer Book Archive