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

Object-oriented data bank access method and system

An object-oriented and access method technology, applied in the object-oriented database access method and system field, can solve problems such as low operation efficiency, and achieve the effects of avoiding memory space occupation, expanding hit range, and reducing time overhead

Active Publication Date: 2007-08-22
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF0 Cites 58 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The technical problem to be solved by the present invention is to provide an object-oriented database access method and system to solve the problem of low operating efficiency caused by multiple compilation of SQL statements in ORMapping

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
  • Object-oriented data bank access method and system
  • Object-oriented data bank access method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] In order to make the above objects, features and advantages of the present invention more comprehensible, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0038] In the ORMapping business system, although most of the operations on objects are different, many of them are similar. For example, there are many query operations like this: the query database table name, query field, and query condition field are the same, but the query condition The comparison values ​​are different. For example, if the query operation is performed on the student performance data table, the attribute information of the data table includes: personal information such as student number and student name, grades of English, mathematics, Chinese and other subjects, total grades, and average grades. Wherein, the student achievement data table is the main body of the query, and in the technique of processing the ...

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

This invention discloses an access method and a system for database facing objects, in which, said method includes: analyzing requests of objects to obtain accessed database list names, at least one access field, a condition field and a condition comparing value, generating key assignments based on the analyzed result including database list names, access fields and access condition fields, looking for parameterized SQL sentences corresponding to said key assignments and generating parameterized SQL sentences and storing them if they are not found out and setting the condition comparing value to a request parameter, if they are found out, then the request parameter is assigned to execute related access operation, in this invention, similar object requests use a same parameterized SQL sentence so as to reduce time cost for editing and generating SQL sentences many times.

Description

technical field [0001] The invention relates to database access technology, in particular to an object-oriented database access method and system. Background technique [0002] Object Relationship Mapping (ORMapping for short) is a technology that maps a database table to a class in an object-oriented system, and each record in the table corresponds to a specific object of the class. Through this technology, an object-oriented approach can be used in the process of software development to deal with database-related parts, such as adding, modifying, and deleting records. [0003] Object-oriented databases organize data into objects, objects can have attributes, and each attribute is also an object. In ORMapping technology, SQL (Structured Query Language, Structured Query Language) statements for database access operations will be generated according to requests (generally divided into operations such as adding records, deleting records, and querying records). The process of...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 郭志波
Owner KINGDEE SOFTWARE(CHINA) CO LTD
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