Mathematical Model of the Mechanism for Generating SQL-questions in the ORM Layer of the Hibernate Framework
( Pp. 89-96)

Problem statement. Modern ORM frameworks, such as Hibernate, automate the process of interaction with databases, which significantly simplifies development. However, their performance, in particular the speed of generating SQL queries, can significantly depend on the structure of the input data, its volume, and caching settings. Insufficient understanding of these factors can lead to unreasonable delays in application operation. Goal. To study the influence of the structure and size of the input data on the process of generating SQL queries in the ORM layer of the Hibernate framework, and to evaluate the role of caching in optimizing execution time. Results. The study identified the key components involved in generating SQL queries. A mathematical model was developed that describes the query generation time depending on the input data and caching settings. The model allows predicting the performance of the ORM layer for various configurations. Practical significance. The results can be used to optimize the operation of applications using Hibernate, as well as to select optimal caching parameters and data organization. This is especially important for highly loaded systems where performance is critical.

Goryachkin B.S., Svetasheva Yu.V. Mathematical Model of the Mechanism for Generating SQL-questions in the ORM Layer of the Hibernate Framework. Computational Nanotechnology. 2025. Vol. 12. No. 1. Pp. 89–96. (In Rus.). DOI: 10.33693/2313-223X-2025-12-1-89-96. EDN: MKTEUZ

Goryachkin B.S., Hanmurzin T.I. Improving the efficiency of working with a web resource due to the tools of a system programmer. Dynamics of Complex Systems – 21st Century. 2022. Vol. 16. No. 3. Pp. 26–39. DOI: 10.18127/j19997493-202203-03.
Grigoriev Yu.A. Estimation of execution time of SQL queries to databases. Mechanical Engineering and Computer Technologies. 2012. No. 01.
Gudilin D.S., Zvonarev A.E., Goryachkin B.S., Lychagin D.A. Relational database performance comparation. In: 5th International Youth Conference on Radio Electronics, Electrical and Power Engineering (REEPE). IEEE, 2023. Vol. 5. Pp. 1–5.
Eliseeva E.A., Goryachkin B.S., Vinogradova M.V. Research of DBMS performance when working with cluster databases based on ergonomic analysis. StudNet. 2022. Vol. 5. No. 4. Pp. 2888–2910.

SQL, ORM, Hibernate, Java, SQL, ORM, Hibernate, caching, Java, generation, analysis, time.