Structured statement execution method and device, storage medium and electronic equipment

Through the structured statement execution method based on ES cluster, SQL Parser parses and converts SQL statements into ES cluster-recognizable formats, solving the problems of ElasticSearch operation complexity and learning cost, realizing deep integration of SQL and ES and simplification of operation.

CN120541102APending Publication Date: 2025-08-26中国邮政储蓄银行股份有限公司
0 Cites 0 Cited by

Patent Information

Application Number
CN202510598630.1
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-05-09
Publication Date
2025-08-26

AI Technical Summary

Technical Problem

In the prior art, ElasticSearch has high operational complexity, and users need to learn its unique query language, which increases operational difficulty and labor costs, especially in large-scale data environments, lacks flexible and efficient data definition and manipulation functions.

Method used

Provide a structured statement execution method based on ES cluster. It parses structured statements through SQL Parser, generates a hierarchical abstract syntax tree, determines the language type based on the syntax tree, and converts SQL statements into a format recognized by the ES cluster, performs corresponding operations, and supports data definition, manipulation, control and query languages.

Benefits of technology

It reduces the cost of users being familiar with ElasticSearch's native API and syntax, simplifies the operation process, realizes the deep integration of SQL protocol and ElasticSearch, bridges the compatibility gap between ElasticSearch and SQL protocols, and supports DDL, DCL and DML operations.

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

Abstract

The invention provides a structured statement execution method and device, a storage medium and electronic equipment, and the method comprises the steps: obtaining a structured statement, and checking the grammar correctness of the structured statement, the language type of the structured statement being one of the following: a data definition language, a data manipulation language, a data control language and a data query language; under the condition that the grammar of the structured statement is correct, analyzing the structured statement by adopting SQL Parser to obtain a hierarchical abstract syntax tree; determining the language type of the structured statement according to the hierarchical abstract syntax tree; and processing the structured statement according to the language type of the structured statement to obtain a target statement, and executing the target statement to perform corresponding operation on the ES cluster. According to the method, the SQL instruction is accurately converted into the domain specific language adapting to the ES internal working principle, the cost that an SQL user is familiar with ES native API and grammar is reduced, and deep integration of the SQL protocol and the ES is achieved.
Need to check novelty before this filing date? Find Prior Art