SQL (Structured Query Language) rewriting method and device, electronic equipment and storage medium

Abstract

The embodiment of the invention provides an SQL rewriting method and device, electronic equipment and a storage medium, and relates to the technical field of databases. According to the method, the corresponding candidate AST identifier is determined based on the target grammar structure information, then the candidate AST corresponding to the candidate AST identifier is selected according to the candidate AST identifier and the preset AST set, finally, the candidate AST is rewritten according to the target parameter information, the corresponding target AST is obtained, and then the target SQL corresponding to the target AST is generated. By adopting the method and the device, after the SQL rewriting request is received, the candidate AST matched with the candidate AST identifier is selected from the preset AST set based on the candidate AST identifier corresponding to the target grammar structure information, so that the SQL rewriting efficiency is improved.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to an SQL rewriting method, device, electronic equipment and storage medium. Background technique [0002] Structured Query Language (SQL) is widely used in various databases to improve the work quality and efficiency of computer application systems. However, in order to meet specific business needs, it is often necessary to rewrite one SQL into another SQL. [0003] For example, in order to realize the rewriting of SQL, the distributed database Mycat uses the Druid parser to perform lexical analysis and syntax analysis on the initial SQL in sequence, so as to obtain the corresponding initial abstract syntax tree (Abstract Syntax Tree, AST); then, based on a specific According to the business requirements, modify the structure and content of the initial AST to obtain the target AST, and finally complete the rewriting of the initial SQL based on the target AST to generat...

AI Technical Summary

Problems solved by technology

[0005] However, using the above-mentioned SQL rewriting method directly uses SQL as a key to cache the corresponding target AST, which will consume a lot of time because the entire SQL needs to be matched when executing the SQL rewriting operation; and if a large number of similar Extremely high SQL will affect the accuracy of SQL matching

[0006] Therefore, using the above method will reduce the efficiency of SQL rewriting

Images