maisМоделирование и анализ информационных системModeling and Analysis of Information Systems1818-10152313-5417Yaroslavl State University10.18255/1818-1015-2015-2-158-175mais-238Research ArticleОригинальные статьиArticlesЭффективность доступа к данным в СУБД DIMAccess Efficiency to Data in DIM DBMSАнтоновДмитрий ВладимировичAntonovD. V.

выпускник аспирантуры, 150000 Россия, г. Ярославль, ул. Советская, 14

выпускник аспирантуры, Sovetskaya str., 14, Yaroslavl, 150000, Russia

dmitrii.antonov@gmail.comРублевВ. С.RoublevV. S.

анд. физ.-мат. наук, профессор, 150000 Россия, г. Ярославль, ул. Советская, 14

канд. физ.-мат. наук, профессор, Sovetskaya str., 14, Yaroslavl, 150000, Russia

roublev@mail.ruЯрославский государственный университет им. П. Г. ДемидоваРоссияP.G. Demidov Yaroslavl State UniversityRussian Federation201520042015222158175Copyright © Антонов Д.В., Рублев В.С., 20152015Антонов Д.В., Рублев В.С.Antonov D.V., Roublev V.S.Данная работа распространяется под лицензией Creative Commons Attribution 4.0.This work is licensed under a Creative Commons Attribution 4.0 License.https://www.mais-journal.ru/jour/article/view/238

В статье приводится обзор средств, используемых в объектной СУБД нового типа для повышения эффективности доступа к данным. Описываются особенности объектной СУБД DIM, основанные на использовании отношений классов объектов (как множеств объектов): наследования, включения, взаимодействия и истории – и отношений объектов: наследования, внутреннего наследования, включения, внутреннего включения, взаимодействия и истории. Вводится описание предметной области при помощи объектно-динамической модели данных (OD-модели) и обосновывается полнота СУБД DIM для произвольной OD-модели. Описывается объектный язык запросов ODQL, позволяющий совместить сложность точного описания с простотой использования за счет введения двух уровней запросов. В целях выяснения наиболее эффективного способа обращения к СУБД DIM проводится исследование различных запросных технологий для этой среды, а также разрабатываются и реализуются механизмы для работы пользователей с ней. Для этого разрабатывается комплекс программных средств, необходимых для работы с СУБД DIM. Приводится описание основных концепций разработки ПО «Навигатор DIM», необходимо- го для возможности манипулирования данными в имеющейся БД посредством графиче- ского интерфейса. Рассматривается разработка ПО «Генератор ODQL-запросов», который нужен для упрощения построения запросов к СУБД DIM без необходимости для пользо- вателя в обязательном порядке знать синтаксис нового языка запросов. Рассматриваются пути решения проблемы конвертации данных из существующих СУБД в СУБД DIM. Статья публикуется в авторской редакции.

In the article is provided the review of tools used in new type object DBMS for increasing the efficiency of access to data. Described object DIM DBMS features based on the use of the classes of objects relations as objects sets (inheritance, inclusion, interaction and history) and objects relations (inheritance, internal inheritance, inclusion, internal inclusion, interaction and history). The description of subject domain is entered by means of an object and dynamic data model (OD-model), and DIM DBMS completeness for any OD-model is justified. ODQL object query language allowing to combine the exact description complexity with the simplicity of use due to two query levels introduction is described. For the elucidation of the most effective way of the appeal to DIM DBMS the study of various query technologies for this environment is conducted, and mechanisms for users work with it are developed and realized. For this purpose a software complex necessary for work with DIM DBMS is developed. The description of the "DIM Navigator" main software development concepts, necessary for data manipulation opportunity in the available DB by means of the graphic interface is provided. Software development "The Generator of ODQL-queries" is considered which is necessary for simplification of query creation to DIM DBMS, needlessly for the user to know the syntax of a modern query language. Problems of converting data from the existing DBMS in DIM DBMS are considered.

The article is published in the author’s wording

СУБДРСУБДООСУБДDIMдискретные детерминированные моделиOD-модельзапросные технологииODQL-запросыконвертирование БДDBMSRDBMSOODBMSDIMdiscrete determined modelsOD-modelquery technologiesODQL-queriesDB convertingReferencesGray J., Liu D. T., Nieto-Santisteban M., Szalay A., Dewitt D. J., Heber G., “Scientific Data Management in the Coming Deacade”, SIGMOD Recjrd, 34, 2005.Gray J., Liu D. T., Nieto-Santisteban M., Szalay A., Dewitt D. J., Heber G., “Scientific Data Management in the Coming Deacade”, SIGMOD Recjrd, 34, 2005.Sivtsov A., “Shest komponentov uspeshnykh proektov na primere DW/BV. Korporativnye bazy dannykh-2011”, Materialy 16-y ezhegodnoy tekhnicheskoy konferentsii, 2011, (in Russian).Sivtsov A., “Shest komponentov uspeshnykh proektov na primere DW/BV. Korporativnye bazy dannykh-2011”, Materialy 16-y ezhegodnoy tekhnicheskoy konferentsii, 2011, (in Russian).Codd E. F., “A relational model for large shared data banks”, Comm. ACM, 13:6 (1970), 377–387.Codd E. F., “A relational model for large shared data banks”, Comm. ACM, 13:6 (1970), 377–387.Codd E. F., Further normalization of the database relational model, in Database Systems, ed. R. Rustin, Prentice Hall, Englewood Cliffs, NJ, 1972.Codd E. F., Further normalization of the database relational model, in Database Systems, ed. R. Rustin, Prentice Hall, Englewood Cliffs, NJ, 1972.Atkinson M. i dr., Manifest sistem obektno-orientirovannykh baz dannykh. SUBD, 1995, (in Russian).Atkinson M. i dr., Manifest sistem obektno-orientirovannykh baz dannykh. SUBD, 1995, (in Russian).Garsia-Molina G. et al., Sistemy baz dannykh. Polny kurs, Vilyams, 2003, (in Russian).Garsia-Molina G. et al., Sistemy baz dannykh. Polny kurs, Vilyams, 2003, (in Russian).Robert Greene, “OODBMS ARCHITECTURES. An examination of implementations”, http://www.odbms.org/wp-content/uploads/2006/10/028.01-Greene-OODBMSArchitectures-September-2006.pdf.Robert Greene, “OODBMS ARCHITECTURES. An examination of implementations”, http://www.odbms.org/wp-content/uploads/2006/10/028.01-Greene-OODBMSArchitectures-September-2006.pdf.Kostenko B. B., Kuznetsov S. D., “Istoriya i aktualnye problemy temporalnykh baz dannykh”, 2007, http://www.citforum.ru/database/articles/temporal, (in Russian).Kostenko B. B., Kuznetsov S. D., “Istoriya i aktualnye problemy temporalnykh baz dannykh”, 2007, http://www.citforum.ru/database/articles/temporal, (in Russian).Pisarenko D. S., Roublev V. S., “Object DBMS DIM and its main concepts”, Modeling and analysis of information systems, 16:1 (2009), 60–87, (in Russian).Pisarenko D. S., Roublev V. S., “Object DBMS DIM and its main concepts”, Modeling and analysis of information systems, 16:1 (2009), 60–87, (in Russian).Roublev V. S., “The Object Query Language of the Dynamic Information Model DIM”, Modeling and analysis of information systems, 17:3 (2010), 144–161, (in Russian).Roublev V. S., “The Object Query Language of the Dynamic Information Model DIM”, Modeling and analysis of information systems, 17:3 (2010), 144–161, (in Russian).Rublev V. S., “Zaprosnaya polnota yazyka ODQL dinamicheskoy informatsionnoy modeli DIM”, Yaroslavsky pedagogichesky vestnik, Fiziko-matematicheskie i estestvennye nauki, 1, Yaroslavl, 2011, 69–75, (in Russian).Rublev V. S., “Zaprosnaya polnota yazyka ODQL dinamicheskoy informatsionnoy modeli DIM”, Yaroslavsky pedagogichesky vestnik, Fiziko-matematicheskie i estestvennye nauki, 1, Yaroslavl, 2011, 69–75, (in Russian).Roublev V. S., “Object Query Computing Optimization in the Dynamic Information Model DIM”, Modeling and analysis of information systems, 18:2 (2011), 39–51, (in Russian).Roublev V. S., “Object Query Computing Optimization in the Dynamic Information Model DIM”, Modeling and analysis of information systems, 18:2 (2011), 39–51, (in Russian).Deyt K. Dzh, Khyu Darven, “Osnovy budushchikh sistem baz dannykh: trety manifest”, 2004, (in Russian).Deyt K. Dzh, Khyu Darven, “Osnovy budushchikh sistem baz dannykh: trety manifest”, 2004, (in Russian).Rublev V. S., Kaybyshev A. Sh., “Organizatsiya khraneniya dannykh i vypolneniya zaprosov v dinamicheskoy informatsionnoy modeli DIM”, Yaroslavsky pedagogichesky vestnik: Estestvennye nauki, III, YaGPU, Yaroslavl, 2012, 70, (in Russian).Rublev V. S., Kaybyshev A. Sh., “Organizatsiya khraneniya dannykh i vypolneniya zaprosov v dinamicheskoy informatsionnoy modeli DIM”, Yaroslavsky pedagogichesky vestnik: Estestvennye nauki, III, YaGPU, Yaroslavl, 2012, 70, (in Russian).Jarke M., Koch J., “Query Optimization in Database Systems”, Computing Surveys, 16:2 (1984).Jarke M., Koch J., “Query Optimization in Database Systems”, Computing Surveys, 16:2 (1984).Darvin Kh., Deyt K., “Trety manifest”, SUBD, 1996, № 1, 110–123, (in Russian).Darvin Kh., Deyt K., “Trety manifest”, SUBD, 1996, № 1, 110–123, (in Russian).Yusupov A. R., “Yazyki obektno-dinamicheskikh zaprosov i reshenie problem dostupa k informatsii v Dinamicheskoy informatsionnoy modeli DIM”, Sovremennye problemy matematiki i informatiki, 6 (2004), 157–163, (in Russian).Yusupov A. R., “Yazyki obektno-dinamicheskikh zaprosov i reshenie problem dostupa k informatsii v Dinamicheskoy informatsionnoy modeli DIM”, Sovremennye problemy matematiki i informatiki, 6 (2004), 157–163, (in Russian).Yusupov A. R., “Interfeys polzovatelya dinamicheskoy informatsionnoy modeli DIM i navigator obektov”, Diskretnye modeli v teorii upravlyayushchikh sistem. Tezisy dokladov V nauchnoy konferentsii, MGU, M., 2003, 92–93, (in Russian).Yusupov A. R., “Interfeys polzovatelya dinamicheskoy informatsionnoy modeli DIM i navigator obektov”, Diskretnye modeli v teorii upravlyayushchikh sistem. Tezisy dokladov V nauchnoy konferentsii, MGU, M., 2003, 92–93, (in Russian).Lobachev D. I., “Realizatsiya prav dostupa k obektam dinamicheskoy informatsionnoy modeli”, Sovremennye problemy matematiki i informatiki: Sbornik nauchnykh trudov molodykh uchenykh, aspirantov i studentov, 5, Yarosl. gos. un-t, Yaroslavl, 2002, (in Russian).Lobachev D. I., “Realizatsiya prav dostupa k obektam dinamicheskoy informatsionnoy modeli”, Sovremennye problemy matematiki i informatiki: Sbornik nauchnykh trudov molodykh uchenykh, aspirantov i studentov, 5, Yarosl. gos. un-t, Yaroslavl, 2002, (in Russian).Lobachev D. I., “Organizatsiya dostupa k dannym dinamicheskoy informatsionnoy modeli”, Problemy teoreticheskoy kibernetiki: Tezisy dokladov XIII Mezhdunarodnoy konferentsii, Moskva, 2002, 111, (in Russian).Lobachev D. I., “Organizatsiya dostupa k dannym dinamicheskoy informatsionnoy modeli”, Problemy teoreticheskoy kibernetiki: Tezisy dokladov XIII Mezhdunarodnoy konferentsii, Moskva, 2002, 111, (in Russian).Antonov D. V., “Generatsiya ODQL-zaprosov dlya SUBD DIM”, Sbornik dokladov Mezhdunarodnoy konferentsii «II vesennie nauchnye chteniya» (17 maya 2014), Nauchnoinformatsionny tsentr «Znanie», Donetsk, Ukraina, 2014, ISSN 6827–0151 (in Russian).Antonov D. V., “Generatsiya ODQL-zaprosov dlya SUBD DIM”, Sbornik dokladov Mezhdunarodnoy konferentsii «II vesennie nauchnye chteniya» (17 maya 2014), Nauchnoinformatsionny tsentr «Znanie», Donetsk, Ukraina, 2014, ISSN 6827–0151 (in Russian).Antonov D. V., “Zaprosy SUBD DIM i ikh generatsiya”, Shestdesyat sedmaya regionalnaya nauchno-tekhnicheskaya konferentsiya studentov, magistrantov i aspirantov vysshikh uchebnykh zavedeniy s mezhdunarodnym uchastiem, 2 (2014), 284, (in Russian).Antonov D. V., “Zaprosy SUBD DIM i ikh generatsiya”, Shestdesyat sedmaya regionalnaya nauchno-tekhnicheskaya konferentsiya studentov, magistrantov i aspirantov vysshikh uchebnykh zavedeniy s mezhdunarodnym uchastiem, 2 (2014), 284, (in Russian).Antonov D. V., Rublev V. S., “Sravnitelny analiz zaprosnykh tekhnology dlya skhem baz dannykh SUBD DIM”, Materialy XI mezhdunarodnogo seminara «Diskretnaya matematika i ee prilozheniya», posvyashchennogo 80-letiyu so dnya rozhdeniya akademika O.B.Lupanova (Moskva, MGU, 23 iyunya 2012 g.), MGU, Moskva, 2012, 321–323, (in Russian).Antonov D. V., Rublev V. S., “Sravnitelny analiz zaprosnykh tekhnology dlya skhem baz dannykh SUBD DIM”, Materialy XI mezhdunarodnogo seminara «Diskretnaya matematika i ee prilozheniya», posvyashchennogo 80-letiyu so dnya rozhdeniya akademika O.B.Lupanova (Moskva, MGU, 23 iyunya 2012 g.), MGU, Moskva, 2012, 321–323, (in Russian).Antonov D. V., Rublev V. S., “Sravnenie modeley zaprosov dlya skhem baz dannykh SUBD DIM”, Zametki po informatike i matematike: Sbornik nauchnykh statey, 4, Yaroslavl, 2012, 25, (in Russian).Antonov D. V., Rublev V. S., “Sravnenie modeley zaprosov dlya skhem baz dannykh SUBD DIM”, Zametki po informatike i matematike: Sbornik nauchnykh statey, 4, Yaroslavl, 2012, 25, (in Russian).Antonov D. V., Rublev V. S., “Analiz tekhnologiy vychisleniya ODQL-zaprosov SUBD DIM”, Yaroslavsky pedagogichesky vestnik, 3, 2013, 93–97, (in Russian).Antonov D. V., Rublev V. S., “Analiz tekhnologiy vychisleniya ODQL-zaprosov SUBD DIM”, Yaroslavsky pedagogichesky vestnik, 3, 2013, 93–97, (in Russian).Antonov D. V., Rublev V. S., “Comparison of query models for schemes of the DIM DBMS databases”, Science Drive-2012, YarGU, Yaroslavl, 2013.Antonov D. V., Rublev V. S., “Comparison of query models for schemes of the DIM DBMS databases”, Science Drive-2012, YarGU, Yaroslavl, 2013.Antonov D. V., “Navigator of the DIM DBMS databases”, Science Drive-2013, YarGU, Yaroslavl, 2013.Antonov D. V., “Navigator of the DIM DBMS databases”, Science Drive-2013, YarGU, Yaroslavl, 2013.Antonov D. V., “Navigator DIM”, Zametki po informatike i matematike: Sbornik nauchnykh statey, 5, Yaroslavl, 2013, 10, (in Russian).Antonov D. V., “Navigator DIM”, Zametki po informatike i matematike: Sbornik nauchnykh statey, 5, Yaroslavl, 2013, 10, (in Russian).Antonov D. V., “Generatsiya ODQL-zaprosov dlya SUBD DIM”, Molodaya nauka v klassicheskom universitete: Tezisy dokladov nauchnykh konferentsy festivalya studentov, aspirantov i molodykh uchenykh, Ivanovo, 2014, Chast I (in Russian).Antonov D. V., “Generatsiya ODQL-zaprosov dlya SUBD DIM”, Molodaya nauka v klassicheskom universitete: Tezisy dokladov nauchnykh konferentsy festivalya studentov, aspirantov i molodykh uchenykh, Ivanovo, 2014, Chast I (in Russian).Rublev V. S., “Teorema o staticheskoy polnote SUBD DIM”, Problemy teoreticheskoy kibernetiki. Materialy XVII mezhdunarodnoy konferentsii (Kazan, 16–20 iyunya 2014g.), Otechestvo, Kazan, 2014, 242–245, (in Russian).Rublev V. S., “Teorema o staticheskoy polnote SUBD DIM”, Problemy teoreticheskoy kibernetiki. Materialy XVII mezhdunarodnoy konferentsii (Kazan, 16–20 iyunya 2014g.), Otechestvo, Kazan, 2014, 242–245, (in Russian).Antonov D. V., “Navigator dlya SUBD DIM”, Svidetelstvo o gosudarstvennoy registratsii programmy dlya EVM № 2014618475, (in Russian).Antonov D. V., “Navigator dlya SUBD DIM”, Svidetelstvo o gosudarstvennoy registratsii programmy dlya EVM № 2014618475, (in Russian).

The authors declare that there are no conflicts of interest present.