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, improving performance, and expanding hit range

Active Publication Date: 2009-10-14
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF4 Cites 0 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

The invention discloses an object-oriented database access method and system, relates to database access technology, and solves the problem of low operation efficiency caused by multiple compilation of SQL statements when processing database access in an object-oriented manner. The method includes: analyzing the object request, obtaining the name of the database table for access, at least one access field, at least one condition field for access, and a condition comparison value; generating a key value according to the analysis result, and the key value includes the name of the database table, the access field , the access condition field; look for the parameterized SQL statement corresponding to the key value; if not found, then generate a parameterized SQL statement and save it, wherein the condition comparison value is set as a request parameter; if found, Then perform corresponding access operations after assigning values ​​to the request parameters. In the present invention, similar object requests use the same parameterized SQL statement, which minimizes the time overhead of multiple compilations and generates SQL statements, and greatly improves system performance.

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 Patents(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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com