Design of Data Access Architecture Using ORM Framework

Nowadays, various Object–relational mapping frameworks are becoming a key part of computer system architecture. These frameworks provide developers with relatively easy manipulation of data stored in various database systems, even without knowledge of complex database systems. In this article, we have focused on leveraging the benefits of implementing an ORM framework while minimizing the impact on software performance. The design of an intelligent data intermediate layer is described within this paper. This provides optimized communication between the application layer and subsequently the ORM Framework. At the same time, attempts have been made to extend the layer with an additional caching layer, which however proved to be unhelpful for simple SQL queries.