Preliminary Study on Effects of Object-Relational Mapping on the Efficiency of Monolithic and Distributed Relational Database Systems

Preliminary Study on Effects of Object-Relational Mapping on the Efficiency of Monolithic and Distributed Relational Database Systems

연구 분야: Databases

학회: 2024 47th MIPRO ICT and Electronics Convention (MIPRO)

As there is a growing need to store and process large amounts of data for the correct operation of many applications, traditional monolithic relational databases, due to their architecture, are becoming insufficient for such applications. Distributed databases are presented as a potential solution. Distributed databases store data on multiple instances, which enables greater scalability, flexibility, database availability, and potentially better performance in data processing.Furthermore, object-relational mapping (ORM) is a programming technique that facilitates the interaction between a database and a program written in an object-oriented language. It allows writing database queries in an object-oriented paradigm instead of using the SQL programming language. Although ORMs make it much easier to write programming code, they are also known to affect database performance negatively.This paper aims to determine the impact of ORM on the performance of monolithic and distributed relational databases and to compare whether it has a greater effect on monolithic or distributed databases. We will use the TPC (Transaction Processing Performance Council)-C benchmark. MySQL will be used for the monolithic database, TiDB for the distributed database, and SQLAlchemy for ORM.