A.V. Baldin - Dr.Sc. (Eng.), Professor, Department of Information Processing and Control Systems, Bauman Moscow State Technical University S.A. Tonojan - Ph.D. (Eng.), Department of Information Processing and Control Systems, Associate Professor, Bauman Moscow State Technical University D.V. Eliseev - Ph.D. (Eng.), Department of Information Processing and Control Systems, Bauman Moscow State Technical University

Common not temporal object-relational models store only the current status of the domain objects, which makes their use limited. The article deals with the temporal object-relational model, which process and store state history of domain objects. А definition of the temporal data and temporal databases is described in the report. Also, methods of representation and processing of temporal data with object-relational DBMS are reviewed. The volume of information stored in the temporal object-relational database, is highly dependent on the temporality data level and frequency changing information. Temporality data levels were described from the level of the entire database and ending with the level of individual attributes. It is shown that if the scheme of such databases is often changed the redundancy in the temporal storage system increases. In addition, the use of standard temporal models based on relational one eventually leads to the widening of the database schema, making difficult its maintenance and upgrading. To remove these deficiencies, in the report it is offered to convert the temporal database in a multidimensional mivar representation. As a result of this conversion it becomes possible to extend temporal property not only to data, but also to their structure. Thus, in mivar describing the temporality is a property of the whole object-relational database, and isn\'t achieved through the use of object-relational constructs to describe stored information temporality. As a result, a new technique for working with temporal object-relational database is proposed, that consists of three stages: a single database conversion into a multidimensional mivar representation, transactional changes this temporal multidimensional model and performing search queries for the temporal database in the mivar space. For all of these stages the special operations and operators have been developed and implemented, that are described in other works related to this subject. The report has reference to this works. The size of the table of object-relational database reduced on average 32% and the adaptation time of information system reduced on average 53% when the proposed technique was testing in the university personnel management system.

 

1. Ageeva T.I., Baldin A.V., Tonojan S.A. i dr. Informacionnaja upravljajushhaja sistema MGTU im. N.EH. Baumana «EHlektronnyjj universitet»: koncepcija i realizacija / Pod red. I.B. Fedorova, V.M. CHernenkogo. M.: Izd-vo MGTU im. N.EH. Baumana. 2009. 376 s.
2. Tonojan S.A., Saraev D.V. Temporalnye modeli bazy dannykh i ikh svojjstva. Inzhenernyjj zhurnal: nauka i innovacii. 2014. № 12 (36). S. 15.03.
3. Eliseev D.V. Baldin A.V., Tonojan S.A. JAzyk zaprosov k mivarnomu predstavleniju reljacionnykh baz dannykh, soderzhashhikh arkhiv informacii iz predydushhikh kadrovykh sistem // Inzhenernyjj zhurnal: nauka i innovacii. 2013. № 11 (23). S. 20.
4. Developing Time-Oriented Database Applications in SQL, Richard T. Snodgrass, Morgan Kaufmann Publishers, Inc., San Francisco, July. 1999. 504 p.
5. Eliseev D.V., Baldin A.V., Tonojan S.A. Analiz izbytochnosti khranenija temporalnykh dannykh sredstvami reljacionnojj SUBD // Inzhenernyjj zhurnal: nauka i innovacii. 2014. № 4 (28). S. 1.
6. Kostenko B.B., Kuznecov S.D. Istorija i aktualnye problemy temporalnykh baz dannykh [EHlektronnyjj resurs]. 2007 - Rezhim dostupa: http://citforum.ru/database/articles/temporal/4.shtml, (Data obrashhenija: 18.03.2015).
7. Andreas Steiner. A generalisation approach to temporal data models and their Implementations [EHlektronnyjj resurs]. 1998. Rezhim dostupa: http://www.timeconsult.com/Publications/diss.pdf, (Data obrashhenija: 18.03.2015).
8. CHernenkijj V.M., Semkin P.S. Metod opisanija processov vypolnenija zadanijj v multiprogrammnykh i multiprocessornykh sistemakh // Vestnik MGTU im. N.EH. Baumana. Ser. Priborostroenie. 2014. № 1 (94). S. 121-132.
9. Dejjt K. Vvedenie v sistemy baz dannykh. Izd. 8-e. M.: Izd. dom «Viljams». 2006. 1328 c.
10. Grigorev JU.A. Ocenka vremeni vypolnenija SQL zaprosa k bazam dannykh. Nauka i obrazovanie: ehlektronnoe nauchno-tekhnicheskoe izdanie. 2012. № 1. S. 30.
11. Eliseev D.V. Metodika obrabotki temporalnojj reljacionnojj bazy dannykh v mivarnom prostranstve: Avtoref. dis. ... kand. tekhn. nauk. M.: MGTU im. N.EH. Baumana. 2011. 16 c.
12. CHernenkijj V.M., Gapanjuk JU.E., Mavzjutov A.A. Razrabotka kompleksnykh biomedicinskikh informacionnykh sistem na osnove adaptivnykh obektov // Inzhenernyjj zhurnal: nauka i innovacii. 2012. № 3 (3). S. 10.
13. Vinogradova M.V., Ingushev EH.G. Principy organizacii struktury dannykh s proizvolnym dostupom i bystrojj operaciejj vstavki ili udalenija // Inzhenernyjj zhurnal: nauka i innovacii. 2012. № 3 (3).
14. Varlamov O.O. Osnovy mnogomernogo informacionnogo razvivajushhegosja (mivarnogo) prostranstva predstavlenija dannykh i pravil // Informacionnye tekhnologii. 2003. № 5. S. 42-47.