Method and device for achieving efficient database access based on ORM (object relational mapping) architecture

Abstract

The invention discloses a method and a device for achieving efficient database access based on an ORM (object relational mapping) architecture. The method comprises the following steps that: a code generator module generates a data entity code of a database table according to the database table; an ORM module builds a mapping relationship between the entity data and corresponding database according to the data entity code, and a data access module accesses the database requested by a user by the mapping relationship. According to the invention, efficient access on different databases by different development languages is achieved; business data is transferred between layers in an object-oriented manner by adopting an effective layering architecture design; maintainability and expandability of the program are improved; labor division of each layer is explicit; agile development and co-operative development are convenient, and load of an application developer is reduced by automatically generating most of SQL (structured query language) sentences and entity class components, so that more energy is input on achievement of a view layer design and a system service logic function and the like.

Description

technical field [0001] The invention relates to a method and a device for realizing efficient database access based on an Object Relational Mapping (Object Relational Mapping, ORM) architecture. Background technique [0002] At present, the object-oriented programming method is the mainstream development method in the enterprise-level application development environment, and the relational database is the mainstream data storage method for storing data in the enterprise-level application. Therefore, during the development process, some business logic often needs to directly call Structured Query Language (Structured Query Language, SQL) statements to achieve, but the disadvantages of such development are SQL statements everywhere, low development efficiency, high error rate, poor program maintainability, and poor scalability. [0003] In order to improve the flexibility of the project and improve the development efficiency, ORM is a good choice. When the database model chang...

AI Technical Summary

Problems solved by technology

[0005] 1. Some functions are very powerful, but the structure is complex, and it is not easy to transplant programs and reuse codes, which increases the cost of learning and using;

[0006] 2. Some structures are simple, but the functions are relatively weak, and the layering of the structure is not clear, which is not conducive to the automatic generation of codes, and is not conducive to the division of labor and cooperation. Therefore, the development efficiency is low;

[0007] 3. Improper use of ORM in some systems will cause a decrease in execution efficiency, because ORM actually sacrifices storage space in exchange for a large number of database access performance improvements, and improper use of space will also cause performance degradation

Images