Executing method, device, device and storage medium for data operation

Abstract

The invention discloses a data operation execution method, device, equipment and storage medium. Among them, the method includes: obtaining the SQL operation statement input by the user; if the original inner connection in the SQL operation statement is the next-level operation of the original grouping and the set function corresponding to the original grouping satisfies the preset condition, then combining the original inner connection specified other tables in the table set except the core table involved in the set function; for each combination result, construct a new inner connection according to the inner connection conditions of the other tables in the combination result and the core table in the SQL operation statement and grouping, and transform the original inner connection and original grouping according to the new inner connection and grouping to obtain the corresponding operation execution plan; use the operation execution plan with the least execution cost to execute the SQL operation statement. The technical solution provided by the invention reduces the amount of data in the intermediate result set obtained by the inner connection, reduces the execution cost of the data operation, and improves the execution efficiency of the data operation.

Description

technical field [0001] Embodiments of the present invention relate to the field of database processing, and in particular, to a data operation execution method, device, device, and storage medium. Background technique [0002] In a structured query language (Structured Query Language, SQL) database, SQL is an operation command set established for the database, and inner join and grouping operations for data tables are basic functions provided by it. Among them, the inner connection means to find the common records that meet the preset conditions in the associated multiple data tables; the grouping operation is usually used in conjunction with the set function, such as grouping statistics and grouping sorting. For example, the implementation statement of the connection between table A and table B can be: selectA.A_name, B.B_name from A, B where A.A_ID=B.B_ID; the implementation statement of table A group statistics is: select count(A.A_ID ) FROM A GROUP BY A.A_ID; where coun...

AI Technical Summary

Problems solved by technology

[0003] When performing inner join and grouping operations on multiple associated data tables at the same time, if the grouping is directly used as the upper level operation of the inner join, such as select count(A.A_ID) FROM A,B where A.A_ID=B.B_ID GROUP BYB.B_ID, since the grouping operator and the inner connection operator are independent of each other, usually the inner connection operation is performed on multiple associated data tables in turn according to the preset association conditions, and the inner connection is satisfied The final data table of the association condition is grouped. If there are many data tables associated with the inner connection, at this time, only two data tables are controlled for inner connection at a time, so that the amount of data in the intermediate data set obtained by the inner connection is relatively large, reducing the effectiveness

Images