Column Level Uni -Temporal Data
The basic paradigm of conventional database systems is based on the current valid data processing. However, today's database systems should provide also management for historical and future valid data. Standard temporal model, using object level, stores the whole object data after the insert or...
Main Authors: | , |
---|---|
Format: | Article |
Language: | English |
Published: |
University of Žilina
2014-02-01
|
Series: | Communications |
Subjects: | |
Online Access: | https://komunikacie.uniza.sk/artkey/csl-201401-0017_column-level-uni-temporal-data.php |
_version_ | 1797846886452822016 |
---|---|
author | Michal Kvet Karol Matiasko |
author_facet | Michal Kvet Karol Matiasko |
author_sort | Michal Kvet |
collection | DOAJ |
description | The basic paradigm of conventional database systems is based on the current valid data processing. However, today's database systems should provide also management for historical and future valid data. Standard temporal model, using object level, stores the whole object data after the insert or update operation, although only some attributes changed their values. This paper deals with the principle of temporal data modelling based on the column level, not the whole object, describes the structure and principles of required methods, procedures, functions and triggers to provide functionality of the system. All designed and implemented solutions are compared with the existing solutions. |
first_indexed | 2024-04-09T18:02:12Z |
format | Article |
id | doaj.art-5336bb4900454c9491710ec5fd9068cd |
institution | Directory Open Access Journal |
issn | 1335-4205 2585-7878 |
language | English |
last_indexed | 2024-04-09T18:02:12Z |
publishDate | 2014-02-01 |
publisher | University of Žilina |
record_format | Article |
series | Communications |
spelling | doaj.art-5336bb4900454c9491710ec5fd9068cd2023-04-14T06:31:09ZengUniversity of ŽilinaCommunications1335-42052585-78782014-02-011619710410.26552/com.C.2014.1.97-104csl-201401-0017Column Level Uni -Temporal DataMichal Kvet0Karol Matiasko1Department of Informatics, Faculty of Management Science and Informatics, University of Zilina, SlovakiaDepartment of Informatics, Faculty of Management Science and Informatics, University of Zilina, SlovakiaThe basic paradigm of conventional database systems is based on the current valid data processing. However, today's database systems should provide also management for historical and future valid data. Standard temporal model, using object level, stores the whole object data after the insert or update operation, although only some attributes changed their values. This paper deals with the principle of temporal data modelling based on the column level, not the whole object, describes the structure and principles of required methods, procedures, functions and triggers to provide functionality of the system. All designed and implemented solutions are compared with the existing solutions.https://komunikacie.uniza.sk/artkey/csl-201401-0017_column-level-uni-temporal-data.phpconventional databasetemporal databasecolumn level temporal datafully temporal model |
spellingShingle | Michal Kvet Karol Matiasko Column Level Uni -Temporal Data Communications conventional database temporal database column level temporal data fully temporal model |
title | Column Level Uni -Temporal Data |
title_full | Column Level Uni -Temporal Data |
title_fullStr | Column Level Uni -Temporal Data |
title_full_unstemmed | Column Level Uni -Temporal Data |
title_short | Column Level Uni -Temporal Data |
title_sort | column level uni temporal data |
topic | conventional database temporal database column level temporal data fully temporal model |
url | https://komunikacie.uniza.sk/artkey/csl-201401-0017_column-level-uni-temporal-data.php |
work_keys_str_mv | AT michalkvet columnlevelunitemporaldata AT karolmatiasko columnlevelunitemporaldata |