Method and apparatus for optimizing request to poll SQL

A syntax tree and processing unit technology, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problems of high optimization cost and low optimization efficiency, and achieve the effect of high optimization efficiency, efficiency improvement, and speed improvement.

Active Publication Date: 2007-08-22
青岛金蝶软件科技有限公司
View PDF0 Cites 51 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The technical problem to be solved by the present invention is to provide a method and device for optimizing

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 apparatus for optimizing request to poll SQL
  • Method and apparatus for optimizing request to poll SQL
  • Method and apparatus for optimizing request to poll SQL

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0040] Referring to Fig. 1, it is a flow chart of method embodiment 1 of the present invention, comprising:

[0041] Step 101, standardize the field names and aliases in the SELECT SQL.

[0042] In the actual SELECT SQL written by hand or generated by the O-R Mapping system, there are often problems with irregular field names and aliases, which affect query optimization. Therefore, the representation methods of these field names and aliases must be standardized first. For example, replace the fields that do not identify the table name with the form of "original table name. original field name" or "original table alias. original field name", such as,

[0043] SELECT name FROM t1″O″

[0044] Can be specified as:

[0045] SELECT "O".name FROM t1 "O".

[0046] The specification processing process can be realized by implementing a preset specification table, or can also be realized by preset certain conversion data operations. For example, all table names and column names are u...

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 a method and a device for optimizing query SQL request, in which, the method includes: standardizing the field names and bynames in the SQL sentences to eliminate the redundant associated relations in them, converting said SQL sentences into a grammar tree to be optimized for logic relation to be converted to standard SQL sentences.

Description

technical field [0001] The invention relates to the field of database applications, in particular to the field of optimizing query SQL requests. Background technique [0002] In large-scale software application systems, it is often necessary to combine programs and databases for use. In application systems, the amount of data involved is particularly large. For medium and large-scale applications, the number of database records is on the order of millions or more, and the database system needs to be simultaneously To process SQL (StructuredQuery Language, Structured Query Language) requests from multiple clients, the processing speed of the database system becomes the bottleneck of the operating speed of the system. For low-quality SELECT SQL requests (query SQL statements), which may contain redundant columns, database table connections and filter conditions, etc., these will affect the performance of the database system, increase the consumption of database locks and datab...

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/30
Inventor 修斯研
Owner 青岛金蝶软件科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap