Problems of the practical implementation of a DBMS as the main component of an intelligent decision support system for the identification of cultural values

Authors

  • A. Martynenko

DOI:

https://doi.org/10.34185/1562-9945-1-138-2022-01

Keywords:

intelligent decision support system, DBMS, MySQL, identification of cultural values, queuing system

Abstract

The article considers the issue of choosing the architecture of the data storage system of the decision support system and its technological schemes of operation. The main advantages and disadvantages of different options for organizing data storage of this system are presented. The issues of solving the problems of practical use of database management systems as the main component of the intelligent decision support system for the identification of cultural values are also considered. The requirements to the components of the intelligent decision support system are defined and given, namely to the subsystem of data storage on objects of cultural values. This paper offers a view of the system, in terms of queuing system, and take into account not only information but also users and processes that will deal with the system, taking into account such criteria as: service time, queue length, number of service channels and their load, bandwidth, serviced/rejected applications, etc. The article presents an analysis of existing tools and modern tools for solving the problem of organizing data storage in the system. Popular modern database management systems, their advantages and disadvantages are analyzed. As a result of the analysis the decision of a choice of system of management of databases which satisfies the criteria established by the author in work is offered. To solve the problem of creating and using a storage subsystem in the system, the author proposes to use the architecture of the system with physical data storage based on MySQL. The main advantages of this approach are given. The convenience of using the phpMyAdmin system as a tool for developing and administering the relevant database is noted. Convenient scaling of the database with this approach allows with minimal costs, to expand the capabilities of the system in the future. The paper notes the complexity and complexity of the problem of solving the problem. Prospects and ways of further research and development of this subject area are determined. The conclusions indicate a number of important organizational and engineering issues in other areas of knowledge that must be solved to successfully solve the problem.

References

MartynenkoА., MorozВ., НulinаI., & SyrotkinaО. (2020). Conceptual model of an intelligent decision support system to identify cultural values. COMPUTER-INTEGRATED TECHNOLOGIES: EDUCATION, SCIENCE, PRODUCTION, (40), P. 51-57. URL: http://cit-journal.com.ua/index.php/cit/article/view/156

А.А. Martynenko, BI Moroz, IG Gulina DATA STORAGE SYSTEMS FOR DECISION-MAKING SUPPORT SYSTEMS IDENTIFICATION OF CULTURAL VALUES. XIV International Conference: Problems of Information Technology in Education, Science and Industry. Dnipro, November 28-29, 2019, P. 35-39.

Martynenko A., Moroz V., & Nulina I. (2020). An intelligent decision support system for cultural property identification. COMPUTER-INTEGRATED TECHNOLOGIES: EDUCATION, SCIENCE, PRODUCTION, (39), P. 78-82. URL: http://cit-journal.com.ua/index.php/cit/article/view/126

MartynenkoА., Moroz, B., & НulinаІ. (2020). Building tools of an intelligent decision support system to identify cultural values . COMPUTER-INTEGRATED TECHNOLOGIES: EDUCATION, SCIENCE, PRODUCTION, (41), P. 71-75. URL: http://cit-journal.com.ua/index.php/cit/article/view/189

А.А. Anosov. Criteria for selecting a database when creating information systems. - URL: http://citforum.ck.ua/database/articles/criteria/

L.V. Palamarchuk. CRITERIA FOR EVALUATION OF STATE ARCHIVE DATABASE MANAGEMENT SYSTEMS. –

URL: https://archives.gov.ua/wp-content/uploads/04-8.pdf.

N.E. Mamaliga, AI Kataeva. DATABASE MANAGEMENT SYSTEM IN MODERN CONDITIONS OF THE IT INDUSTRY –

URL: https://jvestnik-sss.donnu.edu.ua/article/view/10004/9931

K. Seleznev. Features of the choice of modern DBMS. –

URL: https://www.osp.ru/os/2017/03/13052702

TOP-10 database management systems in 2019 –

URL: https://proglib.io/p/databases-2019

TOP 5 popular database management systems (DBMS) in 2020 –

URL: https://info-comp.ru/top-popular-database-management-systems

DB-Engines Ranking. - URL: https://db-engines.com/en/ranking

The Most Popular Databases - 2006/2021 –

URL: https://statisticsanddata.org/data/the-most-popular-databases-2006-2021/

L. Kleinrock Theory of queuing / L. Kleinrock - M.:Book on Demand, 2013. -429p.

Gnedenko B.V., Kovalenko I.N. Introduction to the theory of queuing M .: Nauka, 1966. - 432 p.

Ivchenko G.I., Kashtanov V.A., Kovalenko I.N. Theory of queuing. A textbook for universities. - М .: Graduate School, 1982. - 256 p.

Saati T.L. Elements of queuing theory and its applications. M .: Soviet radio, 1965. - 510 p.

Kleinrock L. Computing systems with queues. Mir Publishing House, 1979.

Features and benefits of MySQL Workbench –

URL: https://biblprog.org.ua/ua/mysql-workbench/

Bringing MySQL to the web - URL: https://www.phpmyadmin.net/

Features phpMyAdmin - URL: https://php-myadmin.ru/doc/ability/

Published

2022-03-30