Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and system for achieving database operation by utilizing object relational mapping (ORM) frame in object orientation

An object-oriented, database technology, applied in the field of database applications, can solve problems such as troublesome use of ODB, and achieve the effect of simplifying operations, saving time, and simplifying operations.

Inactive Publication Date: 2014-04-02
DINGLI COMM
View PDF3 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in the world of c++, there are few ORM frameworks. The well-known ORM library in c++ should be ODB, but the use of ODB is more troublesome, requiring three libraries, and the ORM code written needs to be specially compiled by ODB

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for achieving database operation by utilizing object relational mapping (ORM) frame in object orientation
  • Method and system for achieving database operation by utilizing object relational mapping (ORM) frame in object orientation

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] In the existing object-oriented technology, when accessing the database, because the access interface is inconsistent, the interface needs to be replaced frequently, and the calling method needs to be changed for different databases, and errors caused by manual spelling of SQL statements are frequent, and a large number of calling statements need to be memorized and spelled. slower.

[0022] For this, refer to figure 1 As shown in the flow chart, the present invention provides an object-oriented method utilizing the ORM framework to realize database operation, realizes access to the database through the ORM framework, first generates a calling command for operating the database according to the ORM framework and business entities, and calls Commands are generated in chain calls, such as query ().where(…).orderby(…) , where T is a business entity, which corresponds to a certain physical table in the database. The number and type of fields of the two are consistent, but ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to the field of database application, in particular to a method and a system for achieving database operation by utilizing an object relational mapping (ORM) frame in object orientation. The method includes processing all structured query language (SQL) statements in a unification mode to enable all the processed SQL statements to achieve database access and operation through a simple application program interface (API), avoid access switching caused by the fact that different databases have different interfaces and enable database access to be simple; automatically generating an SQL script through an ORM entity, utilizing template metaprograms and macros to achieve a generation process to avoid the trouble of manual memory of a large amount of SQL statements, reduce manual spelling errors and improve development efficiency; conducting operation on the databases through a chained calling mode to achieve flexibility of an access mode. The system comprises a processing module, a converting module and an operation module, and can achieve contents in the method. By means of the method and the system, operation of small databases or large databases becomes simple and automatic, and access efficiency and accuracy are effectively improved.

Description

technical field [0001] The invention relates to the field of database application, in particular to an object-oriented method and system for realizing database operation by utilizing an ORM framework. Background technique [0002] In object-oriented, when accessing the database, due to the difference of the database and the difference of different database interfaces, it is necessary to switch the access mode when accessing the database, which makes the access operation very inconvenient. When accessing the database, it is generally implemented through the sql language, which requires spelling to generate various sql statements. The spelling work is cumbersome, and the work is often repetitive and error-prone. [0003] Existing technology uses ORM language to access databases. For example, there are many ORM frameworks in java and c#, entity framework, Linq to Sql, NHibernate, etc. in c#, Hibernate, Mybatis, etc. in java, and many other open source ORM libraries. However, i...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30G06F9/44
CPCG06F16/25
Inventor 祁宇裴大桥张品林喻大发曹雪山
Owner DINGLI COMM
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products