Performance Verification of IDL Architecture for Partitioned Database

Abstract

With the growing popularity of ORM Frameworks and the need to efficiently manage large datasets, the deployment of various optimizations of this approach is increasingly being explored. In this paper, we focus on investigating the impact of partitioning on IDL performance, which was introduced in a previous study in the publication Design of Data Access Architecture Using ORM Framework. This IDL enables the implementation of ORM Frameworks with loaded data prediction and overall improves and speeds up database data access through ORM Frameworks. This paper extends this work and focuses on further optimizing the IDL in the form of partitioning database tables. At the same time, we have tried to analyze the effect of partitioning on the behavior and performance of IDL. Finally, it will be evaluated whether this optimization technique is applicable in a practical environment and whether an improvement in IDL performance has been achieved.

Keywords

• database application architecture
• orm
• database
• data layer
• optimization
• entity joining
• partitioning
• performance test
• idl (intelligent data layer)