Temporal data modelling
Michal Kvet, Anton Lieskovsky, Karol Matiaško · 2013
The need of today is to have not only actual data - data that are valid in this moment, but also historical data, by which the progress and frequency of changes can be monitored. It offers creating future prognoses. Temporal tables (mostly modelled using uni-temporal and bi-temporal tables) in comparison with conventional tables can process and retain the information in the past. Using procedures and functions, snapshot of the database at any point in past can be reconstructed easily. Thus, each database object is not represented by only one row, but by the set of rows with limited validity.