A SQL statement processing method, device, equipment, medium and product

CN119782335APending Publication Date: 2025-04-08WUHAN DAMENG DATABASE
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411842238.9
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-12-13
Publication Date
2025-04-08

AI Technical Summary

Technical Problem

When the prior art migrates SQL statements to other databases, it is difficult to compatible with the SQL syntax of multiple databases at the same time, which is prone to syntax conflicts and is highly complex, resulting in the inability to compatible large-scale SQL statements.

Method used

By distinguishing the parsing requirements based on the session level in the database server, providing corresponding parsing models, syntax parsing the SQL statements to be executed, generating an SQL syntax tree structure, and executing SQL statements based on this structure to solve syntax conflict problems and improve database compatibility.

Benefits of technology

It realizes the distinction between parsing requirements at the session level, provides corresponding parsing models, solves syntax conflict problems, improves database compatibility, and simplifies the SQL statement processing process.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119782335A_ABST
    Figure CN119782335A_ABST
Patent Text Reader

Abstract

The present invention discloses a method, device, equipment, medium and product for processing SQL statements. The method comprises: receiving a to-be-executed SQL statement sent by a database client through a session; performing syntax analysis on the to-be-executed SQL statement based on a target parsing model corresponding to the session to obtain an SQL syntax tree structure; executing the to-be-executed SQL statement based on the SQL syntax tree structure to obtain an execution result, and sending the execution result to the database client. Through the technical solution of the present invention, parsing requirements can be distinguished at the session level, and a parsing model corresponding to the parsing requirements can be provided, thereby improving database compatibility and solving syntax conflict problems.
Need to check novelty before this filing date? Find Prior Art