Analysis of temporal data storage redundancy by means of RDBMS
Authors: Baldin A.V., Tonoyan S.A., Eliseev D.V.
Published in issue: #4(28)/2014
DOI: 10.18698/2308-6033-2014-4-1273
Category: Information technology
Real-world objects change with time, and this factor sets the database from one state to another, replacing the current values new data. In such systems is that all stored in the data is up to date at the time of execution of the corresponding requests. The majority 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 identify constraints that are contained in several of the States in the database, using the nontemporal data models and query languages. The conversion of the non-temporal database 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, which leads to redundancy of information. The article provides an analysis and assessment of redundancy of information in the temporal relational databases.
References
[1] Steiner A. A generalisation approach to temporal data models and their implementations. 1998. Available at: http://www.timeconsult.com/Publications/diss.pdf (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 "Elektronnyi universitet": kontseptsiia i realizatsiia [Information management system of BMSTU "Electronic University": the concept and realization]. S.A. Tonoian, 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 informatsionnoi podderzhki upravleniia kadrami ["Personnel" - adaptive functional developing system of personnel management information suppport]. Available at: http://www.personal.bravosoft.ru/doc/doc002.htm (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: http://citforum.ru/database/articles/temporal/4.shtml (accessed at: 14 August 2011).
[6] Safonov V.S. Elec. journal. Problemy razvitiia territorii [Problems of the territory development]. 2009. Available at: http://pdt.vscc.ac.ru/?module=Articles&action=view&aid=436 (accessed at: 30 September 2011).
[7] Issledovanie i razrabotka temporal’noi modeli dannykh v ramkakh MIS Interin PROMIS [Research and development of the temporal data model IIA Interin PROMIS]. Bazarkin A. N., 2009. Available at: https://edu.botik.ru/proceedings/psta2009/v2/037-Bazarkin.Research_and.pdf (accessed at: 14 August 2011).