EXPLORING OBJECT-RELATIONAL MAPPING (ORM) SYSTEMS AND HOW TO EFFECTIVELY PROGRAM A DATA ACCESS MODEL

Abstract

The most common problem when using ORM libraries is a decrease in application performance compared to access to the database by executing manually written SQL queries. Several studies by Russian and foreign authors indicate a significant drop in speed when working with databases through ORM, sometimes by 5 or more times. Since existing studies show a significant variation in the results, and there are no studies conducted using the latest version of Entity Framework 6. This study is dedicated to solving the problem of the joint use of two basic technologies for designing information systems - object-oriented programming and relational database management systems. The paper discusses two ways of interacting with an RDBMS - through ORM in the form of its specific implementation of Entity Framework 6.2, or through SQL queries written without using ORM - and assesses the effect of an additional layer of abstraction in the form of ORM on the speed of interaction with the database, and also considers ORM performance optimization methods. The paper presents the results of the optimization and final testing of the use of the ORM system, draws conclusions about the effectiveness of using such systems in the development of software applications.