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

A technology of data manipulation and execution method, applied in the field of database processing, can solve the problems of reducing execution efficiency, large amount of data in intermediate data sets, etc., to achieve the effect of improving execution efficiency, reducing data amount, and reducing execution cost

Active Publication Date: 2022-02-18
SHANGHAI DAMENG DATABASE
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

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
  • Executing method, device, device and storage medium for data operation
  • Executing method, device, device and storage medium for data operation
  • Executing method, device, device and storage medium for data operation

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0030] Figure 1A It is a flow chart of a data operation execution method provided by Embodiment 1 of the present invention. This embodiment is applicable to the case of merging inner joins and groupings in SOL operation statements in any database. A data operation execution method provided in this embodiment can be executed by a data operation execution device provided in an embodiment of the present invention, and the device can be implemented by means of software and / or hardware, and integrated into a device for executing this method In this embodiment, the device for executing the method may be any smart terminal capable of performing data operations in the database, such as a tablet computer, a desktop computer, and a notebook.

[0031] Specifically, refer to Figure 1A , the method may include the following steps:

[0032] S110, acquiring an SQL operation statement input by a user.

[0033] Among them, the SQL operation statement is a database query and programming lang...

Embodiment 2

[0100] figure 2 It is a flowchart of a data operation execution method provided by Embodiment 2 of the present invention. This embodiment is optimized on the basis of the foregoing embodiments. Specifically, this embodiment can optimize details in the process of constructing new inner links and groups and the process of transforming original inner links and original groups.

[0101] Such as figure 2 As shown, this embodiment may include the following steps:

[0102] S201. Obtain an SQL operation statement input by a user.

[0103] S202, if the original inner join 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, combine the core tables involved in the set of tables specified by the original inner join other tables.

[0104] S203. For each combination result, generate a corresponding core table set according to other tables and core tables in the ...

Embodiment 3

[0120] image 3 A schematic structural diagram of a data operation execution device provided by Embodiment 3 of the present invention, as shown in image 3 As shown, the device may include:

[0121] An operation statement acquisition module 310, configured to acquire the SQL operation statement input by the user;

[0122] The table combination module 320 is used to combine the division function in the table set specified by the original inner join if the original inner join 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 Tables other than the core tables involved;

[0123] The execution plan generation module 330 is used to construct a new inner connection and grouping according to the inner connection conditions of other tables and core tables in the SQL operation statement in the combined result for each combination result, and construct new inner ...

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

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 Patents(China)
IPC IPC(8): G06F16/242
CPCG06F16/2433
Inventor 张钦刘志勇韩朱忠
Owner SHANGHAI DAMENG DATABASE
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