<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE article PUBLIC "-//NLM//DTD JATS (Z39.96) Journal Publishing DTD v1.3 20210610//EN" "JATS-journalpublishing1-3.dtd">
<article article-type="research-article" dtd-version="1.3" xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xml:lang="ru"><front><journal-meta><journal-id journal-id-type="publisher-id">mireabulletin</journal-id><journal-title-group><journal-title xml:lang="ru">Russian Technological Journal</journal-title><trans-title-group xml:lang="en"><trans-title>Russian Technological Journal</trans-title></trans-title-group></journal-title-group><issn pub-type="ppub">2782-3210</issn><issn pub-type="epub">2500-316X</issn><publisher><publisher-name>RTU MIREA</publisher-name></publisher></journal-meta><article-meta><article-id pub-id-type="doi">10.32362/2500-316X-2019-7-4-7-20</article-id><article-id custom-type="elpub" pub-id-type="custom">mireabulletin-159</article-id><article-categories><subj-group subj-group-type="heading"><subject>Research Article</subject></subj-group><subj-group subj-group-type="section-heading" xml:lang="ru"><subject>ИНФОРМАЦИОННЫЕ СИСТЕМЫ. ИНФОРМАТИКА. ПРОБЛЕМЫ ИНФОРМАЦИОННОЙ БЕЗОПАСНОСТИ</subject></subj-group><subj-group subj-group-type="section-heading" xml:lang="en"><subject>INFORMATION SYSTEMS. COMPUTER SCIENCES. ISSUES OF INFORMATION SECURITY</subject></subj-group></article-categories><title-group><article-title>Определение кратчайших гамильтоновых путей в произвольных графах распределенных баз данных</article-title><trans-title-group xml:lang="en"><trans-title>Determination of the Shortest Hamiltonian Paths in an Arbitrary Graph of Distributed Databases</trans-title></trans-title-group></title-group><contrib-group><contrib contrib-type="author" corresp="yes"><contrib-id contrib-id-type="orcid">https://orcid.org/0000-0001-6418-6797</contrib-id><name-alternatives><name name-style="eastern" xml:lang="ru"><surname>Андрианова</surname><given-names>Е. Г.</given-names></name><name name-style="western" xml:lang="en"><surname>Andrianova</surname><given-names>E. G.</given-names></name></name-alternatives><bio xml:lang="ru"><p>кандидат технических наук, доцент кафедры корпоративных информационных систем Института информационных технологий</p><p>Scopus author ID 57200555430ResearcherIDS T-7908-2018</p><p>Россия, 119454, Москва, пр. Вернадского, д. 78 </p><p> </p></bio><bio xml:lang="en"><p>Cand. of Sci. (Engineering), Associate Professor of the Chair of Corporate Information Systems, Institute of Information Technology,</p><p>78, Vernadskogo pr., Moscow 119454, Russia</p><p>Scopus author ID 57200555430</p><p>ResearcherID T-7908-2018,</p></bio><xref ref-type="aff" rid="aff-1"/></contrib><contrib contrib-type="author" corresp="yes"><name-alternatives><name name-style="eastern" xml:lang="ru"><surname>Раев</surname><given-names>В. К.</given-names></name><name name-style="western" xml:lang="en"><surname>Raev</surname><given-names>V. K.</given-names></name></name-alternatives><bio xml:lang="ru"><p>доктор технических наук, профессор кафедры инструментального и прикладного программного обеспечения Института информационных технологий</p><p>Россия, 119454, Москва, пр. Вернадского, д. 78 </p></bio><bio xml:lang="en"><p>Dr. of Sci. (Engineering), Professor of the Chair of Instrumental and Applied Software, Institute of Information Technology</p><p>78, Vernadskogo pr., Moscow 119454, Russia</p></bio><xref ref-type="aff" rid="aff-1"/></contrib><contrib contrib-type="author" corresp="yes"><contrib-id contrib-id-type="orcid">https://orcid.org/0000-0001-6984-2933</contrib-id><name-alternatives><name name-style="eastern" xml:lang="ru"><surname>Фильгус</surname><given-names>Д. И.</given-names></name><name name-style="western" xml:lang="en"><surname>Filgus</surname><given-names>D. I.</given-names></name></name-alternatives><bio xml:lang="ru"><p>аспирант кафедры инструментального и прикладного программного обеспечения Института информационных технологий</p><p>Россия, 119454, Москва, пр. Вернадского, д. 78 </p></bio><bio xml:lang="en"><p>Postgraduate Student of the Chair of Instrumental and Applied Software, Institute of Information Technology</p><p>78, Vernadskogo pr., Moscow 119454, Russia</p></bio><email xlink:type="simple">dmif42@ya.ru</email><xref ref-type="aff" rid="aff-1"/></contrib></contrib-group><aff-alternatives id="aff-1"><aff xml:lang="ru">ФГБОУ ВО «МИРЭА – Российский технологический университет»<country>Россия</country></aff><aff xml:lang="en">MIREA – Russian Technological University<country>Russian Federation</country></aff></aff-alternatives><pub-date pub-type="collection"><year>2019</year></pub-date><pub-date pub-type="epub"><day>09</day><month>08</month><year>2019</year></pub-date><volume>7</volume><issue>4</issue><fpage>7</fpage><lpage>20</lpage><permissions><copyright-statement>Copyright &amp;#x00A9; Андрианова Е.Г., Раев В.К., Фильгус Д.И., 2019</copyright-statement><copyright-year>2019</copyright-year><copyright-holder xml:lang="ru">Андрианова Е.Г., Раев В.К., Фильгус Д.И.</copyright-holder><copyright-holder xml:lang="en">Andrianova E.G., Raev V.K., Filgus D.I.</copyright-holder><license license-type="creative-commons-attribution" xlink:href="https://creativecommons.org/licenses/by/4.0/" xlink:type="simple"><license-p>This work is licensed under a Creative Commons Attribution 4.0 License.</license-p></license></permissions><self-uri xlink:href="https://www.rtj-mirea.ru/jour/article/view/159">https://www.rtj-mirea.ru/jour/article/view/159</self-uri><abstract><p>Разработан метод поиска кратчайшего гамильтонова пути в произвольном графе на основе рангового подхода, который обеспечивает высокую оперативность и существенное уменьшение погрешности решения задачи организации процесса управления множеством транзакций и запросов при их реализации в сетевых базах данных. Во многих случаях существующие решения не обеспечивают необходимых результатов по времени доступа и точности найденного решения. Использование разработанного метода позволяет минимизировать время простоя вычислительных устройств, сократить объемы и время передачи данных от одних исполнительных устройств к другим, повысить общую масштабируемость, минимизировать время доступа к данным и пр. Важным достоинством предлагаемого метода является уменьшения числа элементарных операций и числа обрабатываемых векторов в процедуре формирования очереди выполнения операций запроса, что приводит к существенному уменьшению времени на реализацию этих процедур. В работе используются методы теории графов. Оценка эффективности решения задачи выполнена с использованием системного подхода, системного анализа и теории исследования операций. Обработка экспериментальных данных, полученных в ходе работы, проведена в соответствии с положениями математической статистики.</p></abstract><trans-abstract xml:lang="en"><p>A method has been developed for finding the shortest Hamiltonian path in an arbitrary graph based on the rank approach, which provides high efficiency and a significant reduction in the error in solving the problem of organizing the process of managing multiple transactions and queries when they are implemented in network databases. In many cases, existing solutions do not provide the necessary results in terms of access time and accuracy of the found solution. Using the developed method allows minimizing the idle time of computing devices, reducing the volume and time of data transfer from one device to another, increases overall scalability, minimizes data access time, etc. An important advantage of the proposed method is to reduce the number of elementary operations and the number of vectors being processed the queue of the operations of the request, which leads to a significant reduction in time to implement the procedures for the formation of echer di operations in the requests. Methods of graph theory were used in this paper. The effectiveness of the task solution was evaluated using a systems approach, system analysis and the theory of operations research. Processing of experimental data obtained during the work was carried out in accordance with the provisions of mathematical statistics.</p></trans-abstract><kwd-group xml:lang="ru"><kwd>проблема</kwd><kwd>классификация</kwd><kwd>системная инженерия</kwd><kwd>требования</kwd><kwd>валидация</kwd><kwd>верификация</kwd></kwd-group><kwd-group xml:lang="en"><kwd>graph</kwd><kwd>Hamiltonian path</kwd><kwd>query</kwd><kwd>rank approach</kwd><kwd>short tree of paths</kwd><kwd>transaction</kwd><kwd>rank</kwd><kwd>distributed database</kwd></kwd-group></article-meta></front><back><ref-list><title>References</title><ref id="cit1"><label>1</label><citation-alternatives><mixed-citation xml:lang="ru">Аббасов М.Э. Методы оптимизации: Учеб. пособие. СПб.: Изд-во «ВВМ», 2014. 64 с.</mixed-citation><mixed-citation xml:lang="en">Abbasov M. Optimization Methods. St. Petersburg: «VVM» Publ., 2014. 64 p., (in Russ.).</mixed-citation></citation-alternatives></ref><ref id="cit2"><label>2</label><citation-alternatives><mixed-citation xml:lang="ru">Буй Д.Б., Скобелев В.Г. Модели, методы и алгоритмы оптимизации запросов в базах данных (обзор) // Радиоэлектронные и компьютерные системы. 2014. № 2 (66). C. 43–58. http://nbuv.gov.ua/UJRN/recs_2014_2_8</mixed-citation><mixed-citation xml:lang="en">Buy D.B., Skobelev V.G. Models, methods and algorithms for query optimization in databases (a survey). Радіоелектронні і комп’ютерні системи [Radioelectronic and Computer Systems]. 2014; 2 (66):43-58 (in Russ.). http://nbuv.gov.ua/UJRN/recs_2014_2_8</mixed-citation></citation-alternatives></ref><ref id="cit3"><label>3</label><citation-alternatives><mixed-citation xml:lang="ru">Бердников В.П. Модифицированный алгоритм определения полных областей устойчивости нестационарных нелинейных систем // Российский технологический журнал. 2018. Т. 6. № 3. С. 39–53. https://doi.org/10.32362/2500-316X-2018-6-3-39-53</mixed-citation><mixed-citation xml:lang="en">Berdnikov V.P. Modified algorithm for determination of full stability areas in nonstationary nonlinear systems. Rossiiskii tekhnologicheskii zhurnal = Russian Technological Journal. 2018; 6(3):39-53, (in Russ.). https://doi.org/10.32362/2500-316X-2018-6-3-39-53</mixed-citation></citation-alternatives></ref><ref id="cit4"><label>4</label><citation-alternatives><mixed-citation xml:lang="ru">Пастушков А.А., Батоврин В.К. Выбор решений при проектировании сложных систем на основе анализа вариантов со случайными весами // Российский технологический журнал. 2018. Т. 6. № 4. С. 78–88. https://doi.org/10.32362/2500-316X-2018-6-4-78-88</mixed-citation><mixed-citation xml:lang="en">Pastushkov A.A., Batovrin V.K. Selection of solutions for designing open systems based on analysis of variants with random weights. Rossiiskii tekhnologicheskii zhurnal = Russian Technological Journal. 2018; 6(4):78-88, (in Russ.). https://doi.org/10.32362/2500-316X-2018-6-4-78-88/</mixed-citation></citation-alternatives></ref><ref id="cit5"><label>5</label><citation-alternatives><mixed-citation xml:lang="ru">Горобец В.В. Облачная модель транзакционной системы // Вестник компьютерных и информационных технологий. 2013. № 4. С. 19–24.</mixed-citation><mixed-citation xml:lang="en">Gorobets V.V. Cloud model of on-line transaction processing system. Vestnik kompʼiuternykh i informatsionnykh tekhnologii [Herald of Computer and Information Technologies]. 2013; 4:19-24, (in Russ.).</mixed-citation></citation-alternatives></ref><ref id="cit6"><label>6</label><citation-alternatives><mixed-citation xml:lang="ru">Мендкович Н.А., Кузнецов С.Д. Обзор развития методов лексической оптимизации запросов // Труды Института системного программирования РАН. 2012. Т. 23. С. 195–214. https://doi.org/10.15514/ISPRAS-2012-23-12</mixed-citation><mixed-citation xml:lang="en">Mendkovich N.A., Kuznetsov S.D. Overview of evolution of lexical query optimization techniques. Trudy Instituta sistemnogo programmirovaniya RAN [Proceedings of the Institute for System Programming RAS]. 2012; 23: 195-214, (in Russ.) https://doi.org/10.15514/ISPRAS-2012-23-12</mixed-citation></citation-alternatives></ref><ref id="cit7"><label>7</label><citation-alternatives><mixed-citation xml:lang="ru">Листровой С.В., Минухин С.В., Листровая Е.С. Разработка метода мониторинга распределенной вычислительной системы на основе определения кратчайших путей и кратчайших гамильтоновых циклов в графе // Восточно-Европейский журнал передовых технологий. 2015. Т. 6. № 4 (78). С. 32–45. https://doi.org/10.15587/1729-4061.2015.56247</mixed-citation><mixed-citation xml:lang="en">Listrovoy S.V., Minukhin S.V., Listrovaya E.S. Monitoring distributed computing systems on the basis of the determined shortest paths and shortest Hamiltonian cycles in a graph. Eastern-European Journal of Enterprise technologies. 2015; 6/4(78):32-4,. (in Russ.). https://doi.org/10.15587/1729-4061.2015.56247</mixed-citation></citation-alternatives></ref><ref id="cit8"><label>8</label><citation-alternatives><mixed-citation xml:lang="ru">Замбицкий Д.К., Лозовану Д.Д. Алгоритмы решения оптимизационных задач на сетях. Кишинев: Штиница, 1983. 116 с.</mixed-citation><mixed-citation xml:lang="en">Zambitsky D.K., Lozovanu D.D. Algorithms for solving optimization problems on networks. Chisinau:</mixed-citation></citation-alternatives></ref><ref id="cit9"><label>9</label><citation-alternatives><mixed-citation xml:lang="ru">Фильгус Д.И., Андрианова Е.Г., Раев В.К. Развитие методов параллельных вычислений для фрагментации данных сетевой базы данных на основе рангового подхода // Cloud of Science. 2018. Т. 5. № 3. С. 532–550. URL: https://cloudofscience.ru/sites/default/files/pdf/CoS_5_532.pdf</mixed-citation><mixed-citation xml:lang="en">Shtinitsa Publ., 1983. 116 p., (in Russ.).</mixed-citation></citation-alternatives></ref><ref id="cit10"><label>10</label><citation-alternatives><mixed-citation xml:lang="ru">Listrovoy S.V., Golubnichiy D.Y., Listrovaya E.S. Solutiоn method on the basis of rank approach for integer linear programming problems with Boolean variables // Engineering Simulation. 1999. V. 16. № 6. P. 707–725.</mixed-citation><mixed-citation xml:lang="en">Filgus D.I., Andrianova E.G., Raev V.K. Development of parallel computing methods for fragmentation of network database data based on the rank approach. Cloud of Science. 2018; 5(3):532-559, (in Russ.). URL: https://cloudofscience.ru/sites/default/files/pdf/CoS_5_532.pdf</mixed-citation></citation-alternatives></ref><ref id="cit11"><label>11</label><citation-alternatives><mixed-citation xml:lang="ru">Listrovoy S.V., Tretiak V.F., Listrovaya E.S. Parallel algorithms of calculation process optimization for the boolean programming problems // Engineering Simulation. 1999. V. 16. № 5. Р. 569–579.</mixed-citation><mixed-citation xml:lang="en">Filgus D.I., Andrianova E.G., Raev V.K. Development of parallel computing methods for fragmentation of network database data based on the rank approach. Cloud of Science. 2018; 5(3):532-559, (in Russ.). URL: https://cloudofscience.ru/sites/default/files/pdf/CoS_5_532.pdf</mixed-citation></citation-alternatives></ref><ref id="cit12"><label>12</label><citation-alternatives><mixed-citation xml:lang="ru">Федорин А.Н. Многокритериальные задачи ранцевого типа: разработка и сравнительный анализ алгоритмов: дис. ... канд. техн. наук. Нижний Новгород: Нижегородский государственный университет им. Н.И. Лобачевского, 2010. 132 с.</mixed-citation><mixed-citation xml:lang="en">Listrovoy S.V., Golubnichiy D.Y, Listrovaya E.S. Solutioon Method for the linear programming problems with boolean variables. Engineering Simulation. 1999; 16(6): 707-725.</mixed-citation></citation-alternatives></ref><ref id="cit13"><label>13</label><citation-alternatives><mixed-citation xml:lang="ru">Лыфарь Д.А. Параллельные алгоритмы обработки реляционных баз данных // Вестник НГУ. Серия: Информационные технологии. 2010. Т. 8. Вып. 4. С. 72–80. URI: http://www.nsu.ru/xmlui/handle/nsu/307</mixed-citation><mixed-citation xml:lang="en">Listrovoy S.V., Golubnichiy D.Y, Listrovaya E.S. Solutioon Method for the linear programming problems with boolean variables. Engineering Simulation. 1999; 16(6): 707-725.</mixed-citation></citation-alternatives></ref><ref id="cit14"><label>14</label><citation-alternatives><mixed-citation xml:lang="ru">Фраленко В.П., Агроник А.Ю. Средства, методы и алгоритмы эффективного распараллеливания вычислительной нагрузки в гетерогенных средах // Программные системы: теория и приложения. 2015. T. 6. № 3(26). C. 73–92. https://doi.org/10.25209/2079-3316-2015-6-3-73-92</mixed-citation><mixed-citation xml:lang="en">Listrovoy S.V., Tretiak V.F., Listrovaya E.S. Parallel algorithms of calculation process optimization for the boolean programming problems. Engineering Simulation. 1999; 16(5):569-579.</mixed-citation></citation-alternatives></ref><ref id="cit15"><label>15</label><citation-alternatives><mixed-citation xml:lang="ru">Жуков В.С. Исследование методов оптимального размещения базы данных по узлам вычислительной сети // Siberian Journal of Life Sciences and Agriculture. 2010. № 4 (10). С. 75–76.</mixed-citation><mixed-citation xml:lang="en">Listrovoy S.V., Tretiak V.F., Listrovaya E.S. Parallel algorithms of calculation process optimization for the boolean programming problems. Engineering Simulation. 1999; 16(5):569-579.</mixed-citation></citation-alternatives></ref><ref id="cit16"><label>16</label><citation-alternatives><mixed-citation xml:lang="ru">Fedorin A.N. Multi-criteria tasks of the backpack type: development and comparative analysis of algorithms: dis. ... Cand. of Sci. (Engineering). N.I. Lobachevsky Nizhny Novgorod: Nizhny Novgorod State University, 2010. 132 p., (in Russ.).</mixed-citation><mixed-citation xml:lang="en">Fedorin A.N. Multi-criteria tasks of the backpack type: development and comparative analysis of algorithms: dis. ... Cand. of Sci. (Engineering). N.I. Lobachevsky Nizhny Novgorod: Nizhny Novgorod State University, 2010. 132 p., (in Russ.).</mixed-citation></citation-alternatives></ref><ref id="cit17"><label>17</label><citation-alternatives><mixed-citation xml:lang="ru">Fedorin A.N. Multi-criteria tasks of the backpack type: development and comparative analysis of algorithms: dis. ... Cand. of Sci. (Engineering). N.I. Lobachevsky Nizhny Novgorod: Nizhny Novgorod State University, 2010. 132 p., (in Russ.).</mixed-citation><mixed-citation xml:lang="en">Fedorin A.N. Multi-criteria tasks of the backpack type: development and comparative analysis of algorithms: dis. ... Cand. of Sci. (Engineering). N.I. Lobachevsky Nizhny Novgorod: Nizhny Novgorod State University, 2010. 132 p., (in Russ.).</mixed-citation></citation-alternatives></ref><ref id="cit18"><label>18</label><citation-alternatives><mixed-citation xml:lang="ru">Lyfar D.A. Parallel GPU algorithms of relational databases processing. Vestnik NGU. Seriya: Informatsionnye tekhnologii [Herald of NSU. Series: Information Technologies]. 2010; 8(4):72-80, (in Russ.). URI: http://www.nsu.ru/xmlui/handle/nsu/307</mixed-citation><mixed-citation xml:lang="en">Lyfar D.A. Parallel GPU algorithms of relational databases processing. Vestnik NGU. Seriya: Informatsionnye tekhnologii [Herald of NSU. Series: Information Technologies]. 2010; 8(4):72-80, (in Russ.). URI: http://www.nsu.ru/xmlui/handle/nsu/307</mixed-citation></citation-alternatives></ref><ref id="cit19"><label>19</label><citation-alternatives><mixed-citation xml:lang="ru">Lyfar D.A. Parallel GPU algorithms of relational databases processing. Vestnik NGU. Seriya: Informatsionnye tekhnologii [Herald of NSU. Series: Information Technologies]. 2010; 8(4):72-80, (in Russ.). URI: http://www.nsu.ru/xmlui/handle/nsu/307</mixed-citation><mixed-citation xml:lang="en">Lyfar D.A. Parallel GPU algorithms of relational databases processing. Vestnik NGU. Seriya: Informatsionnye tekhnologii [Herald of NSU. Series: Information Technologies]. 2010; 8(4):72-80, (in Russ.). URI: http://www.nsu.ru/xmlui/handle/nsu/307</mixed-citation></citation-alternatives></ref><ref id="cit20"><label>20</label><citation-alternatives><mixed-citation xml:lang="ru">Fralenko V.P., Agronik A.Yu. Tools, methods and algorithms for efficient parallelization of computational loading in heterogeneous environments. Programmnye sistemy: teoriya i primenenie [Program Systems: Theory and Applications]. 2015; 6(3(26)):73-92, (in Russ.). https://doi.org/10.25209/2079-3316-2015-6-3-73-92</mixed-citation><mixed-citation xml:lang="en">Fralenko V.P., Agronik A.Yu. Tools, methods and algorithms for efficient parallelization of computational loading in heterogeneous environments. Programmnye sistemy: teoriya i primenenie [Program Systems: Theory and Applications]. 2015; 6(3(26)):73-92, (in Russ.). https://doi.org/10.25209/2079-3316-2015-6-3-73-92</mixed-citation></citation-alternatives></ref><ref id="cit21"><label>21</label><citation-alternatives><mixed-citation xml:lang="ru">Fralenko V.P., Agronik A.Yu. Tools, methods and algorithms for efficient parallelization of computational loading in heterogeneous environments. Programmnye sistemy: teoriya i primenenie [Program Systems: Theory and Applications]. 2015; 6(3(26)):73-92, (in Russ.). https://doi.org/10.25209/2079-3316-2015-6-3-73-92</mixed-citation><mixed-citation xml:lang="en">Fralenko V.P., Agronik A.Yu. Tools, methods and algorithms for efficient parallelization of computational loading in heterogeneous environments. Programmnye sistemy: teoriya i primenenie [Program Systems: Theory and Applications]. 2015; 6(3(26)):73-92, (in Russ.). https://doi.org/10.25209/2079-3316-2015-6-3-73-92</mixed-citation></citation-alternatives></ref><ref id="cit22"><label>22</label><citation-alternatives><mixed-citation xml:lang="ru">Zhukov V.S. Study of methods for optimal placement of a database on nodes of a computer network. Siberian Journal of Life Sciences and Agriculture. 2010; 4(10):75-76, (in Russ.).</mixed-citation><mixed-citation xml:lang="en">Zhukov V.S. Study of methods for optimal placement of a database on nodes of a computer network. Siberian Journal of Life Sciences and Agriculture. 2010; 4(10):75-76, (in Russ.).</mixed-citation></citation-alternatives></ref><ref id="cit23"><label>23</label><citation-alternatives><mixed-citation xml:lang="ru">Zhukov V.S. Study of methods for optimal placement of a database on nodes of a computer network. Siberian Journal of Life Sciences and Agriculture. 2010; 4(10):75-76, (in Russ.).</mixed-citation><mixed-citation xml:lang="en">Zhukov V.S. Study of methods for optimal placement of a database on nodes of a computer network. Siberian Journal of Life Sciences and Agriculture. 2010; 4(10):75-76, (in Russ.).</mixed-citation></citation-alternatives></ref></ref-list><fn-group><fn fn-type="conflict"><p>The authors declare that there are no conflicts of interest present.</p></fn></fn-group></back></article>
