Technical gazette, Vol. 24 No. 5, 2017.
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
Publication date:
25.10.2017.
Visits: 3.452 *