Extending ER model clustering by relationship clustering

  • Peter Jaeschke
  • Andreas Oberweis
  • Wolffried Stucky
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 823)


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.


Entity Type Relationship Type Business Function Aggregation Type Entity Relationship 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [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
  2. [Chen76]
    Chen, P. P.: The entity-relationship model: Toward a unified view of data, ACM Transactions on Database Systems 1 (1976), No.1, 166–192CrossRefGoogle Scholar
  3. [FeMi86]
    Feldman, P.; Miller, D.: Entity model clustering: Structuring a data model by abstraction, The Computer Journal 29 (1986), No. 4, 348–360CrossRefGoogle Scholar
  4. [Mart89]
    Martin, J.: Information Engineering, Book I: Introduction, Prentice Hall, Englewood Cliffs, New Jersey, 1989Google Scholar
  5. [Mist91]
    Mistelbauer, H.: Datenmodellverdichtung: Vom Projektdatenmodell zur Unternehmensarchitektur, Wirtschaftsinformatik 33 (1991), No. 4, 289–299 (in German)Google Scholar
  6. [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
  7. [ScSt83]
    Schlageter, G.; Stucky, W.: Datenbanksysteme: Konzepte und Modelle, 2. Auflage, B. G. Teubner, Stuttgart, 1983 (in German)Google Scholar
  8. [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
  9. [TeYF86]
    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–222CrossRefGoogle Scholar
  10. [TWBK89]
    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–987CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1994

Authors and Affiliations

  • Peter Jaeschke
    • 1
  • Andreas Oberweis
    • 1
  • Wolffried Stucky
    • 1
  1. 1.Institut für Angewandte Informatik und Formale BeschreibungsverfahrenUniversität Karlsruhe(TH)KarlsruheGermany

Personalised recommendations