Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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

A structured query and natural language technology, applied in natural language data processing, program code conversion, software engineering design, etc., can solve problems that affect the accuracy of natural language conversion into SQL, affect user work efficiency, and inconsistent data sets , to achieve the effect of ensuring the accuracy of the query, strengthening the correlation, and ensuring the data form

Pending Publication Date: 2020-05-19
ONE CONNECT SMART TECH CO LTD SHENZHEN
View PDF0 Cites 22 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

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
  • Structured query language conversion method based on natural language, and related equipment thereof
  • Structured query language conversion method based on natural language, and related equipment thereof
  • Structured query language conversion method based on natural language, and related equipment thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0031] The natural language-based structured query language conversion method provided by this application is applied to the server, and the server can be implemented by an independent server or a server cluster composed of multiple servers. In one embodiment, as figure 1 As shown, a natural language-based structured query language conversion method is provided, including the following steps:

[0032] S1: Obtain natural language text from a preset dat...

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 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...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/242G06F8/41G06F40/151G06F40/253G06F40/284
CPCG06F8/427G06F16/2433
Inventor 刘利郭鹏程
Owner ONE CONNECT SMART TECH CO LTD SHENZHEN
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com