hrcak mascot   Srce   HID

Izvorni znanstveni članak
https://doi.org/10.17559/TV-20160425214024

Relational model of temporal data based on 6th normal form

Darko Golec   ORCID icon orcid.org/0000-0003-0469-4815 ; Faculty of Computer and Information Science (PhD Student), Večna pot 113, 1000 Ljubljana, Slovenia
Viljan Mahnič   ORCID icon 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

Puni tekst: engleski, pdf (901 KB) str. 1479-1489 preuzimanja: 610* citiraj
APA 6th Edition
Golec, D., Mahnič, V. i Kovač, T. (2017). Relational model of temporal data based on 6th normal form. Tehnički vjesnik, 24 (5), 1479-1489. https://doi.org/10.17559/TV-20160425214024
MLA 8th Edition
Golec, Darko, et al. "Relational model of temporal data based on 6th normal form." Tehnički vjesnik, vol. 24, br. 5, 2017, str. 1479-1489. https://doi.org/10.17559/TV-20160425214024. Citirano 13.12.2019.
Chicago 17th Edition
Golec, Darko, Viljan Mahnič i Tatjana Kovač. "Relational model of temporal data based on 6th normal form." Tehnički vjesnik 24, br. 5 (2017): 1479-1489. https://doi.org/10.17559/TV-20160425214024
Harvard
Golec, D., Mahnič, V., i Kovač, T. (2017). 'Relational model of temporal data based on 6th normal form', Tehnički vjesnik, 24(5), str. 1479-1489. https://doi.org/10.17559/TV-20160425214024
Vancouver
Golec D, Mahnič V, Kovač T. Relational model of temporal data based on 6th normal form. Tehnički vjesnik [Internet]. 2017 [pristupljeno 13.12.2019.];24(5):1479-1489. https://doi.org/10.17559/TV-20160425214024
IEEE
D. Golec, V. Mahnič i T. Kovač, "Relational model of temporal data based on 6th normal form", Tehnički vjesnik, vol.24, br. 5, str. 1479-1489, 2017. [Online]. https://doi.org/10.17559/TV-20160425214024
Puni tekst: hrvatski, pdf (901 KB) str. 1479-1489 preuzimanja: 87* citiraj
APA 6th Edition
Golec, D., Mahnič, V. i Kovač, T. (2017). Relacijski model vremenskih podataka zasnovan na 6. normalnoj formi. Tehnički vjesnik, 24 (5), 1479-1489. https://doi.org/10.17559/TV-20160425214024
MLA 8th Edition
Golec, Darko, et al. "Relacijski model vremenskih podataka zasnovan na 6. normalnoj formi." Tehnički vjesnik, vol. 24, br. 5, 2017, str. 1479-1489. https://doi.org/10.17559/TV-20160425214024. Citirano 13.12.2019.
Chicago 17th Edition
Golec, Darko, Viljan Mahnič i Tatjana Kovač. "Relacijski model vremenskih podataka zasnovan na 6. normalnoj formi." Tehnički vjesnik 24, br. 5 (2017): 1479-1489. https://doi.org/10.17559/TV-20160425214024
Harvard
Golec, D., Mahnič, V., i Kovač, T. (2017). 'Relacijski model vremenskih podataka zasnovan na 6. normalnoj formi', Tehnički vjesnik, 24(5), str. 1479-1489. https://doi.org/10.17559/TV-20160425214024
Vancouver
Golec D, Mahnič V, Kovač T. Relacijski model vremenskih podataka zasnovan na 6. normalnoj formi. Tehnički vjesnik [Internet]. 2017 [pristupljeno 13.12.2019.];24(5):1479-1489. https://doi.org/10.17559/TV-20160425214024
IEEE
D. Golec, V. Mahnič i T. Kovač, "Relacijski model vremenskih podataka zasnovan na 6. normalnoj formi", Tehnički vjesnik, vol.24, br. 5, str. 1479-1489, 2017. [Online]. https://doi.org/10.17559/TV-20160425214024

Sažetak
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.

Ključne riječi
logical model; relation; relational modelling; 6th Normal Form; temporal data

Hrčak ID: 188245

URI
https://hrcak.srce.hr/188245

[hrvatski]

Posjeta: 831 *