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

SQL forwarding method and 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: 2021-02-05
HIGHGO SOFTWARE
View PDF11 Cites 1 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
  • SQL forwarding method and device and readable storage medium
  • SQL forwarding method and device and readable storage medium
  • SQL forwarding method and 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 analysis module is used to analyze 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] In the existing technology, when performing SQL forwarding, 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 that the guaranteed 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, forwards the SQL to execute...

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 an SQL forwarding method and device and a readable storage medium, and the method comprises the steps: analyzing a structured query language SQL, and determining a corresponding operation type; and forwarding the SQL execution query according to a preset rule and the operation type. The SQL is forwarded according to the preset rule and the operation type to execute the query according to the determined operation type corresponding to the SQL, so that the SQL is forwarded in a targeted manner to perform the query, and the problems of low query efficiency and longer system response time in the prior art are solved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to an SQL forwarding method, device and readable storage medium. Background technique [0002] In the existing technology, when SQL forwarding is performed, different read and write statements of the same transaction will be sent to different nodes for execution, but 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. Contents of the invention [0003] Embodiments of the present invention provide an SQL forwarding method, device and readable storage medium 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; [00...

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