Unlock instant, AI-driven research and patent intelligence for your innovation.

A kind of SQL forwarding method, device and readable storage medium

A forwarding method and temporary caching technology, applied in the database field, can solve problems such as low query efficiency and long system response time, and achieve the effect of solving low query efficiency

Active Publication Date: 2022-07-01
HIGHGO SOFTWARE
View PDF11 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The embodiment of the present invention provides a SQL forwarding method, device and readable storage medium to solve the problems of low query efficiency and long system response time existing in the prior art

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
  • A kind of SQL forwarding method, device and readable storage medium
  • A kind of SQL forwarding method, device and readable storage medium
  • A kind of SQL forwarding method, device and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 2

[0098] The embodiment of the present invention also provides a structured query language forwarding device, including:

[0099] The parsing module is used to parse the structured query language SQL to determine the corresponding operation type;

[0100]A forwarding module, configured to forward the SQL execution query according to the operation type according to preset rules.

[0101] When SQL forwarding is performed in the prior art, different read and write statements of the same transaction will be sent to different nodes for execution, and the data may not be synchronized in time. Therefore, in this embodiment, the query statements are divided according to the operation type, so as to ensure the In the case of data consistency, the query statement is sent to the corresponding node to execute the query. The embodiment of the present invention determines the corresponding operation type by parsing the structured query language SQL, and forwards the SQL to execute the query ...

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 discloses a SQL forwarding method, device and readable storage medium, wherein the method includes parsing a structured query language SQL to determine a corresponding operation type; and forwarding the SQL according to the operation type according to preset rules to execute a query. The method of the invention forwards the SQL to execute the query according to the operation type corresponding to the determined SQL, and forwards the SQL to execute the query according to the preset rule, thereby realizing the targeted forwarding of the SQL to execute the query, and solving the low query efficiency existing in the prior art , the system response time becomes longer.

Description

technical field [0001] The present invention relates to the technical field of databases, and in particular, to a SQL forwarding method, device and readable storage medium. Background technique [0002] In the prior art, when SQL forwarding is performed, different read and write statements of the same transaction will be sent to different nodes for execution, and the data may not be synchronized in time, which results in low query efficiency, longer system response time, and poor user experience. it is good. SUMMARY OF THE INVENTION [0003] Embodiments of the present invention provide a SQL forwarding method, device, and readable storage medium, so as to solve the problems of low query efficiency and long system response time in the prior art. [0004] In a first aspect, an embodiment of the present invention provides a structured query language forwarding method, including: [0005] Determine the corresponding operation type by parsing the structured query language SQL...

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 Patents(China)
IPC IPC(8): G06F16/242G06F16/2455G06F16/25G06F16/27
CPCG06F16/2433G06F16/24552G06F16/25G06F16/27
Inventor 冯路张元超常晓丽张鲁敏卢健
Owner HIGHGO SOFTWARE