SQL forwarding method and device, electronic equipment and storage medium

By generating routing information in a distributed database system and forwarding SQL to the corresponding target node, the response speed problem caused by mismatch between data and computing nodes is solved, and the system performance is improved.

CN119697080APending Publication Date: 2025-03-25JINZHUAN INFORMATION TECHNOLOGY CO LTD
0 Cites 0 Cited by

Patent Information

Application Number
CN202411881997.6
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-12-19
Publication Date
2025-03-25

AI Technical Summary

Technical Problem

Due to the mismatch between data and computing nodes, SQL needs to go through a complex network forwarding process during processing, resulting in a decrease in the overall response speed of the system.

Method used

By determining the target SQL parser, obtaining metadata information and the target SQL to be forwarded, routing information is generated, and the target message is sent to the load balancing node, so that the load balancing node forwards the target SQL to be forwarded to the corresponding first target node based on the routing information.

Benefits of technology

Based on routing information, the target SQL to be forwarded is sent to the corresponding first target node, which solves the problem of response speed reduction caused by mismatch between data and computing nodes, and improves the overall performance of the system.

✦ Generated by Eureka AI based on patent content.
Patent Text Reader

Abstract

The invention provides an SQL forwarding method and device, electronic equipment and a storage medium. The method comprises the following steps: determining a target SQL parser, and obtaining metadata information and a to-be-forwarded target SQL; inputting a target SQL to be forwarded into the target SQL parser, and outputting a syntax tree of the SQL; when the syntax tree of the SQL meets a first rule, generating routing information according to the metadata information; generating a target message according to the routing information and a to-be-forwarded target SQL; and sending the target message to a load balancing node, thereby enabling the load balancing node to analyze routing information in the target message and a to-be-forwarded target SQL, and forwarding the to-be-forwarded target SQL to a corresponding first target node according to the routing information. In this way, the technical problem that due to mismatching between the data and the computing nodes, SQL can access the actually stored data nodes only through a complex network forwarding process in the processing process, and consequently the overall response speed of the system is decreased can be solved.
Need to check novelty before this filing date? Find Prior Art