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.

Pending Publication Date: 2021-09-14
CHINA EVERBRIGHT BANK +2
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The embodiment of the present invention provides a SQL statement processing method and device to at least solve the problem of extracting a large amount of data from database nodes in the related art and performing calculations through a single computing node. Traffic congestion may also affect the stability of database cluster production and operation

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
  • SQL statement processing method and device
  • SQL statement processing method and device
  • SQL statement processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0058] The method embodiment provided in Embodiment 1 of the present application may be executed in a mobile terminal, a computer terminal, or a similar computing device. Taking running on a mobile terminal as an example, figure 1 It is a block diagram of the hardware structure of the mobile terminal of the SQL statement processing method of the embodiment of the present invention, such as figure 1 As shown, the mobile terminal may include one or more ( figure 1 Only one is shown in the figure) a processor 102 (the processor 102 may include but not limited to a processing device such as a microprocessor MCU or a programmable logic device FPGA) and a memory 104 for storing data. Optionally, the above-mentioned mobile terminal also A transmission device 106 for communication functions as well as input and output devices 108 may be included. Those of ordinary skill in the art can understand that, figure 1 The shown structure is only for illustration, and does not limit the str...

Embodiment 2

[0091] According to another embodiment of the present invention, a SQL statement processing device is also provided, Figure 4 is a block diagram of the SQL statement processing device according to the present embodiment, such as Figure 4 shown, including:

[0092] Parsing module 42, used for parsing the semantics of the SQL statement to obtain multiple clauses;

[0093] The first construction module 44 is used to construct the clause dependencies of the multiple clauses in a directed acyclic graph manner;

[0094] The second construction module 46 is configured to construct the logical execution plan of the plurality of clauses based on the clause dependencies;

[0095] The execution module 48 is configured to execute the logic execution plan through the local data node to obtain an execution result.

[0096] Optionally, the second building block 46 includes:

[0097] A grouping submodule, configured to group the tables involved in the multiple clauses based on the claus...

Embodiment 3

[0113] Embodiments of the present invention also provide a computer-readable storage medium, in which a computer program is stored, wherein the computer program is set to execute the steps in any one of the above method embodiments when running.

[0114] Optionally, in this embodiment, the above-mentioned storage medium may be configured to store a computer program for performing the following steps:

[0115] S11, analyzing the semantics of the SQL statement to obtain multiple clauses;

[0116] S12. Construct the clause dependencies of the multiple clauses in a directed acyclic graph manner;

[0117] S13. Construct a logical execution plan of the multiple clauses based on the clause dependencies;

[0118] S14. Execute the logic execution plan through the local data node to obtain an execution result.

[0119] Optionally, in this embodiment, the above-mentioned storage medium may include but not limited to: U disk, read-only memory (Read-Only Memory, ROM for short), random ac...

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

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

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/242G06F16/27
CPCG06F16/2433G06F16/27
Inventor 王莉莉史晨阳丁永建向小佳彭晓史黎王志刚吴海洋赵振海王忠璐高孝鑫龙禹
Owner CHINA EVERBRIGHT BANK
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap