Data transmission method, device, equipment and storage medium

Abstract

The embodiment of the invention discloses a data transmission method, a device, equipment and a storage medium. The method comprises the following steps: determining at least one operator according toa received operation instruction; wherein at least one operator forms a tree structure, and each operator is a node in the tree structure; if the tree structure comprises the first operator, obtaining the actual record number and the set record number of each operator after one-time data transmission in the tree structure is completed; updating the set number of records according to the actual number of records; and transmitting data in the tree structure according to the updated set record number, and returning to execute the operation of obtaining the actual record number of each operator and the set record number after one-time data transmission in the tree structure until the data corresponding to the operation instruction is transmitted. According to the technical scheme provided bythe embodiment of the invention, the dynamic setting of the number of the operator records during data transmission is realized, the flexibility of setting the number of the operator records is improved, and the response time of the same command is reduced.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of databases, and in particular, to a data transmission method, device, equipment, and storage medium. Background technique [0002] Database Structured Query Language (Structured Query Language, SQL) is a programming language applied to database query, which can be used to store data in the database and to query, update and manage relational database systems. The application of SQL language can enable users to query in high-level data Work on the structure without knowing the specific data storage method, so that the application of the database has greater flexibility and more powerful functions. SQL is usually expressed in the form of a binary tree of operators in the execution plan, and the data between operators is transmitted in the form of a single record or multiple records. [0003] Data transmission in units of multiple records can perform batch calculations on expressions...

AI Technical Summary

Problems solved by technology

[0003] Data transmission in units of multiple records can perform batch calculations on expressions, reduce the number of calls to expression functions and the number of jumps between operators, and increase the hit probability of CPU instructions, but it will increase the number of scenarios Lower query response time and consumes more memory

Data transmission by a single record can reduce query response time and reduce memory consumption, but it cannot obtain many benefits brought by batch data processing

[0004] In the prior art, for a database system that uses a single record as the scale of data transmission between operators, it is difficult to perform batch processing of data, and it lacks a kind of Optimization means; for database systems that support the use of multiple records as the scale of data transmission between operators, when receiving high-level commands and calling multiple operators for execution, all operators use the same number of records for data transmission Propagation, and the number of records between different operators cannot be adjusted according to the specific characteristics during execution, and it is difficult to optimize the response time

Images