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

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

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. For example, when the associated data table is queried No filter conditions or only a wide range of filter conditions, in the case of unoptimized conditions, may cause the entire table to be queried or a large number of unnecessary data sets to be queried, resulting in low query efficiency

Images