А.В. Балдин, С.А. Тоноян, Д.В. Елисеев
8
Analysis of temporal data storage redundancy
by means of RDBMS
A.V. Baldin, S.A. Tonoyan, D.V. Eliseev
Bauman Moscow State Technical University, Moscow, 105005, Russia
Real-world objects change with time, and this factor sets the database from one state to
another, replacing the current values by new data. We show that in such systems all
stored data is up-t- date at the time of execution of the corresponding requests. The ma-
jority of modern database management systems (DBMS) hold the only current domain
objects. However, there are many subject areas in which you need to keep a history of
changes to the database and data. The challenge is to query time-varying data and iden-
tify constraints that are contained in several of the states in the database, using the non-
temporal data models and query languages. The conversion of the non-temporal data-
base model for the temporal can be done by adding periods of time to the data to store
their history. This is accomplished by adding the DB, new tuples, which can change only
the value of one attribute, and this leads to redundancy of information.
The article provides an analysis and assessment of redundancy of information in the tem-
poral relational databases.
Key words:
data structure, modification operations, integrity constraints, temporal data,
temporal model DBMS, not temporal model DBMS, relational database, tuple, multidi-
mensional space, redundancy of data storage.
REFERENCES
[1] Steiner A.
A generalisation approach to temporal data models and their imple-
mentations.
1998. Available at:
(accessed 14 August 2011).
[2]
Informatsionnye tekhnologii v inzhenernom obrazovanii
[Information technology
in engineering education]. Ed. S.V. Korshunov, V.N. Guznenkov. Moscow,
BMSTU Publ., 2007, 432 p.
[3]
Informatsionnaia upravliaiushchaia sistema MGTU im. N.E. Baumana «El-
ektronnyi universitet»: kontseptsiia i realizatsiia
[Information management sys-
tem of BMSTU "Electronic University": the concept and realization]. S.A. Tonoi-
an, A.V. Baldin, V.A. Baryshnikov et al. Ed. I.B. Fedorov, V.M. Chernen'ky.
Moscow, BMSTU Publ., 2009, 376 p.
[4]
«Personal – Kadry» – adaptivnaia funktsional'no-razvivaemaia sistema infor-
matsionnoi podderzhki upravleniia kadrami
["Personnel" - adaptive functional-
developing system of personnel management information suppport]. Available
at:
(accessed at: 14 August
2011).
[5] Kostenko B.B., Kuznetsov S.D.
Istoriia i aktual'nye problemy temporal'nykh baz
dannykh
[History and Challenges of temporal databases]. 2007. Available at:
(accessed at: 14 August
2011).
[6] Safonov V.S. Elec. journal.
Problemy razvitiia territorii
[Problems of the territo-
ry development]. 2009. Available at:
(accessed at: 30 Sep-
tember 2011).
