SQL statement processing method and device

• Main Authors: DING YONGJIAN, WANG LILI, SHI CHENYANG, GAO XIAOXIN, LONG YU, PENG XIAO, ZHAO ZHENHAI, WANG ZHIGANG, XIANG XIAOJIA, WU HAIYANG, WANG ZHONGLU, SHI LI
• Format: Patent
• Language: Chinese; English
• Published: 14.09.2021
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

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 poss