Evaluation of the performance and advantages of SQL and NoSQL approaches for data storage and analysis in CRM

Author(s) Collection number Pages Download abstract Download full text
Tymchenko O. V., Чорняк В. О. № 2 (69) 45-54 Image Image

The occurrence of crisis situations and conflicts often leads to emergencies that require a quick response and effective decision-making. In such conditions, the study of mental and intellectual stability, which ensures the ability of systems and subjects to act within the limits of certain goals and powers, is relevant. This resilience becomes a key factor in ensuring functional effectiveness when countering threats and attacks of various nature.

An important aspect of the problem of functional stability is the analysis of the logic of decision-making aimed at achieving systemic goal-oriented results. Such decisions are based on the principles of consistency, multi-level analysis and risk assessment. Identifying the structure of this logic allows us to develop effective algorithms for countering crisis situations, which can be used in various fields – from security management to socio-economic systems.

The study emphasizes the importance of integrating human psychophysical capabilities with technological means of data analysis, which allows for high adaptability in decision-making. This includes the use of modern modeling techniques, artificial intelligence, and analytical tools to predict the consequences of actions taken.

Considerable attention is paid to the development of approaches to the formation of the stability of systems, which take into account the factors of external influences, uncertainty and limited resources. The paper proposes ways to optimize decision-making processes through the integration of system analysis methods, which allows to increase the efficiency and sustainability of actions in emergency situations. The results of the study can be useful for specialists in the field of crisis management, security, psychology and complex systems management. They provide new tools for developing strategies that minimize risks and provide stability in challenging environments.

Keywords: cognitive psychology, target solutions, intellectual agent, technogenic infrastructure.

doi: 10.32403/1998-6912-2024-2-69-29-45


  • 1. Sikora L. S. (1998). Systemology of Decision Making in Complex Technological Structures. Lviv: Kamenyar – 453 p. (in Ukrainian).
  • 2. Tkachuk R. L. & Sikora L. S. (2010). Logical-cognitive models of formation of managerial decisions by integrated systems in extreme conditions: [manual]. Lviv: Liga-Press. – 404 p.: schemes, tables, illus. (in Ukrainian).
  • 3. Ostapenko G.A.(2007). Information operations and attack in sociological systems: K. Telecom., 134 p. (in Ukrainian).
  • 4. Mykytyn G.V., Dudykevych V.B. & Bobalo Y.Y. (2019). Strategic Security of the «Object – Information Technology» System. – Lviv: NU»LP.,580 p. (in Ukrainian).
  • 5. Khoroshchko V.O., Bobalo B.Ya. & Dudykevych V.B. (2020)/ Projection of complex infor­ma­tion security systems. Lviv: NU»LP»2020. 320 p. (in Ukrainian).
  • 6. Durnyak B. V., Sikora L. S., Lysa N. K., Tkachuk R. L. & Yavorskyi B. I. (2017). Information and Laser Technologies of Data Stream Selection and Their Cognitive Interpretation in Automated Control Systems: Monograph. Lviv: Ukrainian Academy of Printing. 648 p. (in Ukrainian).
  • 7. Durnyak B. V., Sikora L. S., Antonik M. S. & Tkachuk R. L. (2013). Cognitive Models of Formation of Strategies for Operational Management of Integrated Hierarchical Structures in the Conditions of Risks . p.449. (in Ukrainian).
  • 8. Yurynets E.V. & Yurynets R.V. (2012). Automated Information Systems and Technologies. – Lviv. View of LNU. Iv. Franko., 698 p. (in Ukrainian).
  • 9. Tattam, D.: A Short Guide to Operational Risk. Routledge, 1st edn. (2011). https://doi.org/ 10.4324/9781315263649.
  • 10. S. Orel & M. Maliovanyi. (2008). Risk, Lviv, National University “LP”, h252. (in Ukrainian).
  • 11. Sikora L. S., Lysa N. K., Tkachuk R. L., Fedevich O. Yu., Fedyna B. I. (2022). Information and Intellectual Components in the Process of Operator’s Thinking at the Target Formation and Decision Making // Computer Technologies of Printing UAD Ukraine. -№1 (47). – P. 146-159. (in Ukrainian).
  • 12. Sikora L., Lysa N., Martsyshyn R., Miyushkovych Y. (2023). Cognitive and information deci­sion support technologies for operational management of energy-active objects in boundary mo­des // Lecture Notes on Data Engineering and Communications Technologies. – Vol. 149 : Lecture notes in data engineering, computational intelligence, and decision making. Procee­dings of 2022 International scientific conference “Intellectual systems of decision-making and prob­lems of computational intelligence”.P. 353–366. (in Ukrainian).doi: 10.1007/978-3-031-16203-9_21.