Original scientific paper

https://doi.org/10.17559/TV-20160425214024

Relational model of temporal data based on 6th normal form

Darko Golec orcid.org/0000-0003-0469-4815 ; Faculty of Computer and Information Science (PhD Student), Večna pot 113, 1000 Ljubljana, Slovenia
Viljan Mahnič orcid.org/0000-0002-4196-2084 ; Faculty of Computer and Information Science, Večna pot 113, 1000 Ljubljana, Slovenia
Tatjana Kovač ; Faculty of Commercial and Business Sciences Celje, Lava 7a, 3000 Celje, Slovenia

Abstract

This paper brings together two different research areas, i.e. Temporal Data and Relational Modelling. Temporal data is data that represents a state in time while temporal database is a database with built-in support for handling data involving time. Most of temporal systems provide sufficient temporal features, but the relational models are improperly normalized, and modelling approaches are missing or unconvincing. This proposal offers advantages for a temporal database modelling, primarily used in analytics and reporting, where typical queries involve a small subset of attributes and a big amount of records. The paper defines a distinctive logical model, which supports temporal data and consistency, based on vertical decomposition and sixth normal form (6NF). The use of 6NF allows attribute values to change independently of each other, thus preventing redundancy and anomalies. Our proposal is evaluated against other temporal models and super-fast querying is demonstrated, achieved by database join elimination. The paper is intended to help database professionals in practice of temporal modelling.

Keywords

logical model; relation; relational modelling; 6th Normal Form; temporal data

Hrčak ID:

188245

URI

https://hrcak.srce.hr/188245

Publication date:

25.10.2017.

Article data in other languages: croatian

Visits: 3.409 *