Structured query language conversion method based on natural language, and related equipment thereof

Abstract

The invention relates to the technical field of artificial intelligence, and provides a structured query language conversion method based on a natural language, and related equipment thereof. The structured query language conversion method based on the natural language comprises the following steps: obtaining a natural language text from a preset database; performing word segmentation processing on the natural language text to obtain natural language segmented words; obtaining a target text in a mode of mapping the natural language segmented words through a vocabulary analysis end; performinggrammar analysis on the target text by utilizing a preset grammar analyzer to generate an analyzed text; matching a preset select identifier and a preset where identifier with the identifier information in the analysis text respectively, and determining a select clause, a work clause and a from clause according to an obtained matching result; and generating a structured query language based on theselect clause, the where clause and the from clause. The natural language is rapidly and accurately converted into SQL, the accuracy of query by a user through the SQL is further guaranteed, and theworking efficiency of the user is improved.

Description

technical field [0001] The invention relates to the technical field of artificial intelligence, in particular to a natural language-based structured query language conversion method and related equipment. Background technique [0002] At present, the method of converting natural language into Structured Query Language (Structured Query Language, SQL) is mainly based on Ontology's database natural language query interface, but the natural language query interface is based on a preset data set for corresponding conversion. , due to differences in the user's expression, there is a situation that does not match the data set, which in turn affects the accuracy of converting natural language into SQL, causing users to be misled when using SQL to query, thus affecting the user's work efficiency. Contents of the invention [0003] Embodiments of the present invention provide a natural language-based structured query language conversion method and related equipment, so as to improv...

AI Technical Summary

Problems solved by technology

[0002] At present, the method of converting natural language into Structured Query Language (Structured Query Language, SQL) is mainly based on Ontology's database natural language query interface, but the natural language query interface is based on a preset data set for corresponding conversion. , due to differences in the user's expression, there is a situation that does not match the data set, which in turn affects the accuracy of converting natural language into SQL, causing users to be misled when using SQL to query, thus affecting the user's work efficiency

Images