Home // ICCGI 2013, The Eighth International Multi-Conference on Computing in the Global Information Technology // View article
Authors:
Michal Kvet
Anton Lieskovsky
Keywords: conventional table; temporal table; uni-temporal model; valid time;
Abstract:
Today, it is necessary to store not only actual data – data that are valid at this moment, but also historical data, by which the progress and frequency of changes can be monitored. Managing historical data offers creating future prognoses and analyses. Temporal tables (mostly modelled using uni-temporal and bi-temporal tables) in comparison with conventional tables can process and retain the information of the validity in the past. Using procedures, functions, triggers, cursors – snapshot of the database object or whole database at any time point can be reconstructed easily. Thus, each database object is not represented by only one row, but by the set of rows representing the same object during a different period of time. This paper deals with the principles of temporal data modelling and offers the solution based on uni-temporal table model. It contains the implementation methods based on changes monitoring and deals with the problem of managing undefined states of the objects. Operations implemented in temporal system is compared with the conventional model.
Pages: 145 to 151
Copyright: Copyright (c) IARIA, 2013
Publication date: July 21, 2013
Published in: conference
ISSN: 2308-4529
ISBN: 978-1-61208-283-7
Location: Nice, France
Dates: from July 21, 2013 to July 26, 2013