Modeling of temporal data in the relational data model Cover Image

Modelowanie danych temporalnych w relacyjnym modelu danych
Modeling of temporal data in the relational data model

Author(s): Sebastian Łacheciński
Subject(s): Economy
Published by: Wydawnictwo Uniwersytetu Ekonomicznego we Wrocławiu
Keywords: data modeling; time modeling; temporal data model; relational data model;

Summary/Abstract: This article presents a problem of changes modeling which occurs over time, in mapping to relational data model. This issue is particularly important wherever not only always current data, but also historical data should be stored in the database. Solutions are presented that take into account the temporality of the attributes of entity, temporality of the relationships of the entity, and of entire entities, as well as temporality of entire entity and relationships belonging to entity. The issues of time representation, types of attributes and relationships from the point of view of their variability over time are also described in a condensed manner. In addition, the division of temporal databases is described. The aim of this article is a comparison of the ways of modeling changes of selected features of logical entities over time.

  • Issue Year: 46/2017
  • Issue No: 4
  • Page Range: 90-107
  • Page Count: 18
  • Language: Polish