2014•Open Computer ScienceOpen access

Complex time management in databases

Michal Kvet, Michal Kvet, Karol Matiaško, Marek Kvet, Marek Kvet

Open full text 17 citations

Abstract

Abstract Temporal database is an extension of the concept of standard databases which process only current valid data. Temporal structure is not based only on managing historical data, but it should also model the data, the validity of which will be in the future in special structures. This paper deals with the temporal structure on object level in comparison with the column level temporal data. It describes the principles, required methods, procedures, functions and triggers to provide the functionality of this system. It also defines the possible implementations and offers the solution to get the snapshot of the database or the object whenever during the existence. The reason for column level solution development is based on the heterogeneity of the attributes time. Some attributes, however, do not change their values over the time or are updated very rarely, and therefore it is not necessary to record the new values for these attributes.

Open-access reader

About this research paper

What this paper is about

Abstract Temporal database is an extension of the concept of standard databases which process only current valid data. Temporal structure is not based only on managing historical data, but it should also model the data, the validity of which will be in the future in special structures. This paper deals with the temporal structure on object level in comparison with the column level temporal data. It describes the principles, required methods, procedures, functions and triggers to provide the functionality of this system. It also defines the possible implementations and offers the solution to get the snapshot of the database or the object whenever during the existence. The reason for column level solution development is based on the heterogeneity of the attributes time. Some attributes, however, do not change their values over the time or are updated very rarely, and therefore it is not necessary to record the new values for these attributes.

Why it matters

OpenAlex reports 17 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Abstract Temporal database is an extension of the concept of standard databases which process only current valid data. Temporal structure is not based only on managing historical data, but it should also model the data, the validity of which will be in the future in special structures. This paper deals with the temporal structure on object level in comparison with the column level temporal data. It describes the principles, required methods, procedures, functions and triggers to provide the functionality of this system. It also defines the possible implementations and offers the solution to get the snapshot of the database or the object whenever during the existence. The reason for column level solution development is based on the heterogeneity of the attributes time. Some attributes, however, do not change their values over the time or are updated very rarely, and therefore it is not necessary to record the new values for these attributes.

Key concepts: Snapshot (computer storage), Computer science, Temporal database, Implementation, Database, Database model, Database design, Data mining

Related papers

Back to paper searchBrowse research topicsOriginal source
Complex time management in databases — Research Paper | ScholarLens