Alternative modeling of the load of a monitoring database with a variable structure

by

Y.V. Doronina, V.Y. Gusev

Sevastopol State University,

RF, Sevastopol, Universitetskaya St., 33

E-mail: e.15.15@mail.ru

DOI: 10.33075/2220-5861-2024-2-84-94

UDC 004.942

EDN: https://elibrary.ru/lgbkbt

Abstract:

The article considers the task of analyzing the load of a monitoring database with a variable structure based on alternative modeling. The paper substantiates technical solutions that can be used to optimize work with databases; two tools are used Matlab (Matrix Laboratory) and Python, which made it possible to verify models. The results obtained using the PID controller model are used to clarify decision-making to improve data processing efficiency and system stability, and test data and developed models have improved these indicators by 25% and 30%, respectively. The work substantiates technical solutions that can be used to optimize work with databases; the principles of constructing a model for analyzing and managing the database load during the monitoring process are outlined. The results of the study can be applied in areas where effective management of large amounts of data based on database technology is required.

Keywords: database with variable structure, modeling tools, simulation modeling.

Full text in PDF(RUS)

REFERENCES

  1. Gruzlikov A.M., Kolesov N.V., Skorodumov Yu.M., and Tolmacheva M.V. Nestatsionarnyye dinamicheskiye modeli v zadachakh diagnostirovaniya vychislitel’nykh sistem real’nogo vremeni (Nonstationary dynamic models in the tasks of diagnosing real-time computing systems). Izvestiya Rossiyskoy akademii nauk. Teoriya i sistemy upravleniya, 2014, No. 6, pp. 94. DOI: 10.7868/S0002338814060079
  2. Shtessel Y., Edwards C., Fridman L., and Levant A. Sliding Mode Control and Observation, Series: Control Engineering, Birkhauser: Basel, 2014. ISBN: 978-0-81764-8923
  3. Kirillov A.N. Dinamicheskiye sistemy s peremennvoy strukturoy i razmernost’yu (Dynamic systems with variable structure and dimension). Izvestiya vysshikh uchebnykh zavedeniy. Priborostroyeniye, 2009, Vol. 52, No. 3, pp. 23–28.
  4. Mildenberger T.K., Berg C.W., Pedersen M.W., Kokkalis A., and Nielsen J.R. Time-variant productivity in biomass dynamic models on seasonal and long-term scales. ICES Journal of Marine Science, 2020, Vol. 77, pp. 174–187.
  5. Bondarev A.Ye. Issledovaniye nestatsionarnykh prostranstvenno-vremennykh struktur s pomoshch’yu resheniya optimizatsionnoy zadachi i metodov vizualizatsii (Investigation of nonstationary space-time structures by solving optimization problems and visualization methods). Preprint IPM im. M.V. Keldysha, 2011, No. 37, 14 p.
  6. Shipilov D.S. Obzor tekhnicheskikh resheniy dlya avtomatizatsii nablyudeniy za parametrami morskoy sredy (Overview of technical solutions for automating observations of marine environment parameters). Astrakhanskiy vestnik ekologicheskogo obrazovaniya, 2020, No. 6 (60), pp. 36–42. DOI 10.36698/2304-5957-2020-19-6-36-42
  7. Bell Ch., Kindal M., and Talmann L. Obespecheniye vysokoy dostupnosti sistem na osnove MySQL (Ensuring high availability of MySQL-based systems). Saint-Petersburg: Russkaya redaktsiya, BKhV, 2012, 624 p.
  8. Shchiptsova A.V. and Kaznacheeva M.Yu. Poisk, analiz i optimizatsiya dolgikh zaprosov k baze dannykh (Search, analysis and optimization of long-term database queries). Sostoyanie i perspektivy razvitiya IT-obrazovaniya: sbornik dokladov i nauch. statej Vseros. nauch.-prakt. konf. (The State and Prospects of IT Education Development), Collection of Reports and Research Articles of the All-Russian Scientific and Practical Conference), Cheboksary, November 16–18, 2017, Cheboksary: Chuvash State University named after I.N. Ulyanov, 2018, pp. 277–285.
  9. Orlov Yu.N. Kineticheskiye metody issledovaniya nestatsionarnykh vremennykh ryadov (Kinetic methods for studying nonstationary time series). Moscow: Moskovskiy fiziko-tekhnicheskiy institut (gosudarstvennyy universitet), 2014, 277 p. ISBN 978-5-7417-0521-6
  10. Matveyev M.G. and Sirota Ye.A. Kombinirovannyye modeli nestatsionarnykh vremennykh ryadov s izmenyayushchimisya sostoyaniyami (Combined models of nonstationary time series with changing states). Vestnik Voronezhskogo gosudarstvennogo universiteta. Seriya: Sistemnyy analiz i informatsionnyye tekhnologii, 2016, No. 3, pp. 50–61.

Loading