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

Query sentence processing device and query sentence processing method

A query statement and processing device technology, applied in the computer field, can solve problems such as insufficient ease of use, insufficient support, and inability to generate, and achieves the effect of solving heterogeneous database problems and optimizing query statements

Inactive Publication Date: 2011-11-23
YONYOU
View PDF1 Cites 23 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The problem with option 1 is that it is not easy to use
The problem with solution 2 is that the support is not comprehensive enough, for example: complex report sql statements cannot be generated based on the O / R framework

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
  • Query sentence processing device and query sentence processing method
  • Query sentence processing device and query sentence processing method
  • Query sentence processing device and query sentence processing method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] In order to understand the above-mentioned purpose, features and advantages of the present invention more clearly, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0025] In the following description, many specific details are set forth in order to fully understand the present invention, but the present invention can also be implemented in other ways different from those described here, therefore, the present invention is not limited to the specific embodiments disclosed below limit.

[0026] figure 1 is a block diagram of a query statement processing device according to an embodiment of the present invention.

[0027] Such as figure 1 As shown, the present invention provides a query sentence processing device 100, including: a rule definition module 102, which sets rules for processing custom elements; a syntax analysis module 104, which parses expressions to obtain custom elemen...

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 provides a query sentence processing device and a query sentence processing method. The query sentence processing device comprises a rule definition module 102, a syntactic analysis module 104 and a rule processing module 106, wherein the rule definition module 102 is used for setting a rule for processing self-defined elements; the syntactic analysis module 104 is used for analyzing an expression to acquire the self-defined elements in the module 104; and the rule processing module 106 is used for processing the self-defined elements according to the rule and forming query sentences by using a processing result of the elements. By a preset rule, the elements of the expression are converted into an identifiable form of the current database, so that the expression can be applied to any database.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular, to a query statement processing device and a query statement processing method. Background technique [0002] In database application development, our products often need to support different databases, such as Oracle, DB2, SQL Server, etc. Although all database products support the standard sql syntax specification, they all expand on this basis and form their own unique syntax and functions. Although these special syntaxes are beneficial to give full play to the performance of each database product itself, they are not conducive to the development of database applications. How to support heterogeneous databases has become a problem. In the prior art, there are usually two ways to solve this kind of problem: [0003] 1. For the static sql in the code, different sql versions can be provided for different database types to support; [0004] 2. For systems that use the O...

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 YONYOU
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