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

Fingerprint

Data structures
Information systems
Semantics
Systems analysis
Specifications

Keywords

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

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.
Hainaut, Jean-Luc. / A Generic Entity-Relationship Model. Information System Concepts: an in-depth analysis: Proc. of the IFIP WG 8.1 Conf. on Information System Concepts. North-Holland, 1989. pp. 109-138
@inbook{29464a529d6a43d997de021a80efa1e9,
title = "A Generic Entity-Relationship Model",
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.",
keywords = "schema equivalence, Information modeling, formal semantics, model equivalence, ER model",
author = "Jean-Luc Hainaut",
year = "1989",
language = "English",
pages = "109--138",
booktitle = "Information System Concepts: an in-depth analysis",
publisher = "North-Holland",

}

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. North-Holland, pp. 109-138.

A Generic Entity-Relationship Model. / Hainaut, Jean-Luc.

Information System Concepts: an in-depth analysis: Proc. of the IFIP WG 8.1 Conf. on Information System Concepts. North-Holland, 1989. p. 109-138.

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

TY - CHAP

T1 - A Generic Entity-Relationship Model

AU - Hainaut, Jean-Luc

PY - 1989

Y1 - 1989

N2 - 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.

AB - 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.

KW - schema equivalence

KW - Information modeling

KW - formal semantics

KW - model equivalence

KW - ER model

M3 - Chapter

SP - 109

EP - 138

BT - Information System Concepts: an in-depth analysis

PB - North-Holland

ER -

Hainaut J-L. 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. North-Holland. 1989. p. 109-138