Title: MANAGEMENT OF TEMPORAL SYSTEM – COLUMN LEVEL

Issue Number: Vol. 3, No. 3
Year of Publication: 2013
Page Numbers: 70-80
Authors: Michal Kvet, Karol Matiaško
Journal Name: International Journal of New Computer Architectures and their Applications (IJNCAA)
- Hong Kong

Abstract:


Database systems used nowadays must allow not only current valid data processing, but also managing historical data, respectively data, which will be valid in the future. Moreover, it must be able to provide automated change of the values of the attributes. At present, database systems defined for managing temporal data are based on the principle of a new image of the object creation. Some attribute values, 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. This paper deals with the principle of temporal data modelling based on column level, not the whole object. 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.