Innovation Series: Advanced Science (ISSN 2938-9933, CNKI Indexed)

ORM-X: A Light-Weight Object-Relational Mapping Framework for MySQL

Sichen Tao

The Communication University of China, China

Corresponding Author: Sichen Tao (3209748898@qq.com)

Abstract: At present, ORM frameworks in the Java ecosystem cannot simultaneously satisfy the dual demands of high-concurrency business and rapid development, exhibiting a clear polarization. Semi-automatic ORM frameworks allow developers full control over SQL statements and make performance tuning straightforward, but they require repetitive coding for basic CRUD operations. The logic for assembling dynamic SQL is complex, resulting in high development redundancy. Fully automatic ORM frameworks simplify data operations and significantly accelerate development speed, but their automatically generated underlying SQL lacks transparency, easily leading to performance issues such as N+1 queries and redundant queries. Debugging and optimization in high-concurrency scenarios become extremely difficult. In addition, most mainstream existing frameworks are primarily designed for traditional monolithic architectures and provide inadequate support for modern microservice features such as cloud-native capabilities, multi-tenancy, and dynamic data sources, failing to meet the development needs of contemporary distributed projects [1-3]. Accordingly, this paper proposes a new ORM framework called ORM-X, which balances development efficiency and runtime performance while adapting to cloud-native architectures. Featuring a concise architecture, outstanding performance, and low system overhead, ORMX significantly improves the development efficiency of Java back-end systems and offers high practical application value.

Keywords: Object-Relational Mapping; ORM Framework; SQL; Java Backend

References