Optimization method and device for query statement, storage medium and computer equipment

A query statement and optimization method technology, applied in the database field, can solve the problems of a large range of filter conditions without filter conditions in associated data tables, querying large data sets, querying full tables, etc.

Active Publication Date: 2018-06-22
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In traditional technology, because the information system is deployed vertically according to the business modules, when the client performs cross-data joint query, it usually does not know the database distribution of each module, which makes it impossible to optimize the query. F

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
  • Optimization method and device for query statement, storage medium and computer equipment
  • Optimization method and device for query statement, storage medium and computer equipment
  • Optimization method and device for query statement, storage medium and computer equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] In order to make the above objects, features and advantages of the present invention more comprehensible, specific implementations of the present invention will be described in detail below in conjunction with the accompanying drawings. In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention. However, the present invention can be implemented in many other ways different from those described here, and those skilled in the art can make similar improvements without departing from the connotation of the present invention, so the present invention is not limited by the specific implementations disclosed below.

[0048]Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the technical field of the invention. The terms used herein in the description of the present invention are for the purpose of descri...

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 an optimization method and device for a query statement, a storage medium and computer equipment. The method comprises the following steps that: obtaining the query statement,and obtaining a query tree according to the query statement; beginning to traverse the query node of the query tree from the root node of the query tree; when the query node which conforms to a preset execution rule is in the presence, obtaining query data corresponding to the query node as current query data; when an association attribute value is in the presence in the current query data, extracting the association attribute value, and pushing the association attribute value to the corresponding query node; when an associated query node which is not optimized is in the presence in the querynode, obtaining the query data of the query node, and judging whether the execution cost of the query node exceeds the preset execution cost or not; and if the execution cost of the query node exceeds the preset execution cost, taking the query data as the current query data to enter the step when the association attribute value is in the presence in the current query data until the associated query node corresponding to the association attribute value does not contain the associated query node which is not optimized. By use of the method, query efficiency during cross-database joint query isimproved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to an optimization method, device, storage medium and computer equipment for query sentences. Background technique [0002] Cross-database joint query means that the client initiates a query request to perform associated query on multiple tables distributed in different databases. [0003] In traditional technology, because the information system is deployed vertically according to the business modules, when the client performs cross-data joint query, it usually does not know the database distribution of each module, which makes it impossible to optimize the query. For example, when the associated data table is queried If there is no filtering condition or only a wide range of filtering conditions, if it is not optimized, it may cause the entire table to be queried or a large number of unnecessary data sets to be queried, resulting in low query efficiency. Contents of the invent...

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
CPCG06F16/24549G06F16/24564G06F16/2471
Inventor 郑政芳
Owner KINGDEE SOFTWARE(CHINA) CO LTD
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