Abstract.

This article presents three different approaches to the representation of static models in the implementation of database applications. In order to compare solutions based on selected criteria of optimality was created a unified model for testing of tools development of object-oriented applications, presented in the form of a class diagram language UML. As one of the implementations of the classical object-relational mapping patterns which proposers of static models in the environment of a relational DBMS. An alternative solution, a widely used one of the authors, is the object-attributive approach. The paper presents the main components of this approach and example of the unified model testing. The paper also presents a solution based on a matrix universal object-relational database, the main components of which implementation issues are presented in the following sections. This paper is the result of years of research and is based on numerous reports published in the Proceedings of the International Scientific and Practical Conference "Object Systems" (objectsystems.ru).

Keywords:

Database, Object Models, UML, Object-Relational Mapping Patterns, Object-Attribute Approach, Matrix Universal Object-relational Database.

PP. 12-31.

REFERENCES

1.  Oleynik P.P. Unifitsirovannaya model testirovaniya instrumentov razrabotki obektno-orientirovannykh prilozheniy // Obektnye sistemy – 2014 (Zimnyaya sessiya): materialy IX Mezhdunarodnoy nauchno-prakticheskoy konferentsii (Rostov-na-Donu, 10-12 dekabrya 2014 g.) / Pod obshch. red. P.P. Oleynika. – Rostov-na-Donu:  ShI  (f)  YuRGPU  (NPI)  im.  M.I.  Platova,2014. - S. 25 - 35, http://objectsystems.ru/files/2014ws/Object_Systems_2014_Winter_session_Proceedings.pdf
2.   Gamma E. i dr. Priemy obektno-orientirovannogo proektirovaniya.  Patterny  proektirovaniya,  SPb:  Piter, 2001. – 368 s.: il. (Seriya «Biblioteka programmista»).
3.   Oleynik P.P. Unifitsirovannaya model dlya testirovaniya instrumentov obektno-relyatsionnogo otobrazheniya // Obektnye sistemy - 2011: materialy III Mezhdunarodnoy nauchno-prakticheskoy konferentsii (Rostov-na-Donu, 10-12 maya 2011 g.) / Pod obshch. red. P.P. Oleynika. - Rostov-na-Donu, 2011. - S. 65-69., http://objectsystems.ru/files/Object_Systems_2011_Procee dings.pdf
4.   Oleynik P.P. Testovaya model dlya obucheniya proektirovaniyu  obektno-orientirovannykh  baz  dannykh  // Obektnye sistemy – 2014: materialy VIII Mezhdunarodnoy nauchno-prakticheskoy konferentsii (Rostov-na-Donu, 10-12 maya 2014 g.) / Pod obshch. red. P.P. Oleynika. – Rostov-na-Donu: ShI (f) YuRGPU(NPI) im. M.I. Platova, 2014. - S. 86-89., http://objectsystems.ru/files/2014/Object_Systems_2014_Proceedings.pdf
5.   Oleynik P.P. Elementy sredy razrabotki programmnykh kompleksov na osnove organizatsii metamodeli obektnoy   sistemy // Biznes-informatika.   2013. №4(26). – S. 69-76.
6.   Oleynik P.P., programma dlya EVM "Unifitsirovannaya sreda bystroy razrabotki korporativnykh informatsionnykh sistem SharpArchitect RAD Studio", svidetelstvo o gosudarstvennoy registratsii № 2013618212 ot 04 sentyabrya 2013 g.
7.   Deyt, K. Dzh. Vvedenie v sistemy baz dannykh, 8-e izdanie.: Per. s angl. — M.: Izdatelskiy dom "Vilyame", 2005.
8.  Leonid Chernyak. Smutnoe vremya SUBD // Otkrytye sistemy, №2, 2012 URL: http://www.osp.ru/os/2012/02/13014107/
9.   Gabriel,  R.  Objects  Have  Failed:  Notes  for  a  Debate. (retrieved 17 May 2009). http://www.dreamsongs.com/Files/ObjectsHaveFailed.pdf
10. Salibekyan S.M, Panfilov P.B. OA-arkhitektura postroeniya i modelirovaniya raspredelennykh sistem avtomatizatsii // Avtomatizatsiya v promyshlennosti. №11, 2011.
11. Sayt, posvyashchennyy rabotam v oblasti OA-arkhitektury. URL: dataflow.miem.edu.ru
12. Novikov F.A., Ivanov D.Yu. Modelirovanie na UML. Teoriya, praktika, videokurs. – SPb.: Professionalnaya literatura, Nauka i Tekhnika, 2010. – 640 s.: il. + tsv. Vkleyki (+ 2 DVD).
13. Salibekyan  S.M.,  Khalkina  S.B.,  Tinovitskiy  K.D. Obektno-atributnyy podkhod dlya semanticheskogo analiza estestvennogo yazyka // Obektnye sistemy - 2014: material VI Mezhdunarodnoy nauchno-prakticheskoy konferentsii (Rostov-na-Donu, 10-12 maya 2014 g.) / Pod obshch. red. P.P. Oleynika. - Rostov-na-Donu: ShI YuRGTU (NPI), 2014 - C. 80-86, http://objectsystems.ru/files/2014/Object_Systems_2014_Proceedings.pdf
14. Jurij Silk, Borut Robic and Theo Ungerer «Asynchrony in parallel computing: From dataflow to multithreading» Institut Jozef Stefan, Technical Report CDS-97-4, September 1997.
15. Miklyaev   I.A.,   Matrichnaya   universalnaya   obektno-relyatsionnaya baza dannykh // Obektnye sistemy - 2010: Materialy I Mezhdunarodnoy nauchno-prakticheskoy konferentsii. Rossiya, Rostov-na-Donu, 10-12 maya 2010 g / pod obshch. red. P.P. Oleynika. - Rostov-na-Donu, 2010. C. 34-39,  http://objectsystems.ru/files/Sertificates/Object_Systems_2010_Proceedings.pdf
16. Miklyaev  I.A., Kontseptsiya razrabotki matrichnoy universalnoy bazy dannykh s podderzhkoy drevovidnoy struktury edinitsy informatsii i ee universalnogo prilozheniya // Vestnik Voronezhskogo gosudarstvennogo universiteta. Seriya: Sistemnyy analiz i informatsionnye tekhnologii. 2010. № 2., Voronezh, S. 101-108.
17. Miklyaev  I.A.  Matrichnaya  universalnaya  obektno-relyatsionnaya baza dannykh na relyatsionnoy platforme: monografiya/ Sev.(Arktich.) feder. Un-t im. M.V. Lomonosova. – Arkhangelsk: ID SAFU, 2014. – 226 s.
18. Miklyaev  I.A.,  Chertkova  O.V.  Sinergeticheskoe  informatsionnoe prostranstvo MUORBD, // Obektnye sistemy – 2011 (Zimnyaya sessiya): materialy V Mezhdu- narodnoy nauchno-prakticheskoy konferentsii (Rostov-na-Donu, 10-12 dekabrya 2011 g.) / Pod obshch. red. P.P. Oleynika.  –  Rostov-na-Donu:  ShI  YuRGTU  (NPI),2011. C. 67-72, http://objectsystems.ru/files/2011WS/Object_Systems_2011_Win-ter_Session_Proceedings.pdf
19. Miklyaev I.A., Chertkova O.V. Instrumentariy   optimizatsii    raboty    sistemy    upravleniya    obektno-relyatsionnoy  bazy  dannykh  //  Obektnye  sistemy  – 2011 (Zimnyaya sessiya): materialy V Mezhdunarodnoy nauchno-prakticheskoy  konferentsii  (Rostov-na-Donu, 10-12 dekabrya 2011 g.) / Pod obshch. red. P.P. Oleynika.– Rostov-na-Donu: ShI YuRGTU (NPI), 2011. C. 72-76, http://objectsystems.ru/files/2011WS/Object_Systems_2011_Win-ter_Session_Proceedings.pdf
20. Miklyaev   I.A.,   Svidetelstvo   OFYeRNiO   №15405 (Obedinennogo fonda  elektronnykh resursov «Nauka i obrazovanie») "Universalnyy tip dannykh baz dannykh", 2010.
21. Miklyaev  I.A.,  Svidetelstvo  OFYeRNiO  №  14246 (Obedinennogo fonda elektronnykh resursov «Nauka i obrazovanie») Universalno prilozhenie dlya matrichnoy universalnoy obektno-relyatsionnoy bazy dannykh", 2010.
22. Zhirnova M.A., Miklyaev I.A., Sintezirovanie metainformatsii i dannykh Sbornik dokladov po materialam nauchno-prakticheskoy konferentsii v ramkakh XLII Lomonosovskikh chteniy / sektsiya «Informatsionnye sistemy  i  tekhnologii  v  ekonomike  i  upravlenii» /Sbornik dokladov. – Federalnoe gosudarstvennoe avtonomnoe obrazovatelnoe uchrezhdenie vysshego professionalnogo obrazovaniya «Severnyy (Arkticheskiy) federalnyy universitet imeni M.V. Lomonosova» filial v g. Severodvinske Arkhangelskoy oblasti institut sudostroeniya i morskoy arkticheskoy tekhniki, 2013. - s., str. 38-43.