SQL statement processing method and device

A processing method and statement technology, applied in the field of data processing, can solve the problems of database cluster performance bottleneck, affecting the stability of database cluster production and operation, network traffic congestion, etc.
CN113392123APending Publication Date: 2021-09-14CHINA EVERBRIGHT BANK +2
0 Cites 2 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
CHINA EVERBRIGHT BANK
Publication Date
2021-09-14

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The invention provides an SQL statement processing method and device. The method comprises the following steps: analyzing SQL statement semantics to obtain a plurality of clauses; adopting a directed acyclic graph mode to construct a clause dependency relationship of the multiple clauses; constructing a logic execution plan of the plurality of clauses based on the clause dependency relationship; and executing the logic execution plan through the local data node to obtain an execution result, thereby solving the problems that in related technologies, due to the fact that a large amount of data is extracted from the database node, calculation is performed through a single calculation node and the configuration of the calculation node becomes a performance bottleneck of a database cluster, serious network flow congestion is easily caused, and the stability of production and operation of a database cluster is possibly affected as well; the join operation is carried out by utilizing local data nodes as far as possible, it is ensured that a distributed database efficiently executes the join operation, meanwhile, the resource bottleneck of a single computing node and network extraction of huge data are avoided, and efficient and stable operation of the database cluster is achieved.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The present invention relates to the field of data processing, in particular to a SQL statement processing method and device. Background technique

[0002] Centralized join needs to extract the data related to the join of the structured query statement (Structured Quevy Language, referred to as SQL) from the data storage layer to the memory of the computing node / computing layer of the database, and then use the memory join algorithm of the traditional database , such as the regular nest-loop join, to perform the join operation. The advantage of this is that the implementation of join is simple, the traditional memory join algorithm can be reused directly, and the support of various complex joins is relatively easy. However, the implementation of this method usually has the following disadvantages:

[0003] The computing node / coordinating node responsible for join needs to cache all or most of the data, which can easily limit the scale of join computi...

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