A Generic Entity-Relationship Model

Research output: Contribution in Book/Catalog/Report/Conference proceedingChapter

Abstract

The paper describes a general framework allowing the specification, comparison and conversion of most information and data models proposed in Information System design, be they conceptual or at the DBMS level. That framework is based on an extended N1NF relational model that includes the concept of entity domain. The analysis of the constructs available in current information and data models, and particularly ER models, demonstrates the ability of the proposed framework to express these constructs without loss of semantics. The GER is a large subset of this extended relational model that can uniquely represent the concept of most current entity-based and object-based models, while being more regular, less complex and more powerful than their union. By further augmenting the GER with two simple logical implementation constructs, we extend it to the expression of DBMS-dependent models. The GER model has been used as the basis of database design methodologies and tools.
Original languageEnglish
Title of host publicationInformation System Concepts: an in-depth analysis
Subtitle of host publicationProc. of the IFIP WG 8.1 Conf. on Information System Concepts
PublisherNorth-Holland
Pages109-138
Number of pages30
Publication statusPublished - 1989

Keywords

  • schema equivalence
  • Information modeling
  • formal semantics
  • model equivalence
  • ER model

Fingerprint Dive into the research topics of 'A Generic Entity-Relationship Model'. Together they form a unique fingerprint.

  • Cite this

    Hainaut, J-L. (1989). A Generic Entity-Relationship Model. In Information System Concepts: an in-depth analysis: Proc. of the IFIP WG 8.1 Conf. on Information System Concepts (pp. 109-138). North-Holland. http://www.info.fundp.ac.be/cgi-bin/pub-spec-paper?RP-89-001