Entity tree clustering — A method for simplifying ER designs

  • Otto Rauh
  • Eberhard Stickel
Invited Papers (1) Database Design Aspects
Part of the Lecture Notes in Computer Science book series (LNCS, volume 645)


Entity Tree Clustering (ETC) is a method for clustering entity sets in large ER designs in order to improve the clarity of these designs. The procedure is stepwise so that clustered designs on different levels are achieved. Parenthood connections are used to build increasingly complex entity sets out of primitive ones. No semantical extensions of the original ER model are necessary because these connections are identified by their cardinalities alone.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. Booch, G. [1991]. Object oriented design with applications, Redwood City, California: Benjamin/CummingsGoogle Scholar
  2. Chen, P.P. [1976]. “The Entity-Relationship Model: Toward a Unified View of Data”, ACM Trans. on Database Systems, March 1976Google Scholar
  3. Codd, E.F. [1979]. “Extending the database relational model to capture more meaning”, ACM Trans. on Database Systems, Dec. 1979Google Scholar
  4. Feldman, P., Miller, D. [1986]. “Entity Model Clustering: A Data Model By Abstraction”, Computer Journal 29/4, 1986Google Scholar
  5. Hammer, M. and McLead, D. [1981]. “Database description with SDM: a semantic database model”, ACM Trans. on Database Systems, Sept. 1981Google Scholar
  6. Katz, R.H. [1985]. Information Management for Engineering Design, Springer-VerlagGoogle Scholar
  7. Lorie, R., and Plouffe, W. [1983]. “Complex Objects and Their Use in Design Transactions”, Proc. ACM International Conference on Management of Data, Database Week, San Jose, Calif., May 1983Google Scholar
  8. Mistelbauer, H. [1991]. “Datenmodellverdichtung: Vom Projektdatenmodell zur Unternehmens-Datenarchitektur”, Wirtschaftsinformatik 4/91 Google Scholar
  9. Rauh, O. [1992]. “Die Unterscheidung von originären und ableitbaren Daten im Entity-Relationship-Modell”. In Rau, K.-H. and Stickel, E. (eds), Daten-und Funktionsmodellierung, Wiesbaden: Gabler, 1992Google Scholar
  10. Rauh, O. [1992a]. “Some Rules for Handling Derivable Data in Conceptual Data Modeling”. Proc. International Conference on Database and Expert Systems Applications (DEXA 92), to appear Sept. 1992Google Scholar
  11. Smith, J., and Smith, D. [1977]. “Database Abstractions: Aggregation and Generalization”, ACM Trans. on Database Systems, July 1977Google Scholar
  12. Teory, T.J., Wei, G., Bolton, D.L., Koenig, J.A. [1989]. “ER Model Clustering as an Aid for User Communication and Documentation in Database Design”, Communications of The ACM, 32/8, 1989Google Scholar
  13. Vermeir, D. [1983]. “Semantic hierarchies and abstractions in conceptual schemata”, Inform. Systems 8/2, 1983Google Scholar
  14. Wiborny, W. [1991]. Datenmodellierung — CASE — Datenmanagement, Bonn u.a.: Addison-WesleyGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1992

Authors and Affiliations

  • Otto Rauh
    • 1
  • Eberhard Stickel
    • 2
  1. 1.Berufsakademie MosbachMosbach
  2. 2.Berufsakademie StuttgartStuttgart 1

Personalised recommendations