SQL statement generation method and device based on artificial intelligence, equipment and storage medium

A technology of artificial intelligence and generating devices, applied in natural language data processing, special data processing applications, instruments, etc., can solve the problem of low output efficiency of sample corpus, achieve the effect of improving generation efficiency and reducing the amount of development

Pending Publication Date: 2021-11-09
PING AN TECH (SHENZHEN) CO LTD
View PDF5 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Embodiments of the present invention provide an artificial intelligence-based SQL statement generation method, device, computer equipment, and storage medium to solve the technical problem of low output efficiency of sample corpus caused by manual configuration of sample corpus in traditional solutions

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
  • SQL statement generation method and device based on artificial intelligence, equipment and storage medium
  • SQL statement generation method and device based on artificial intelligence, equipment and storage medium
  • SQL statement generation method and device based on artificial intelligence, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] Next, the technical solutions in the embodiments of the present invention will be described in conjunction with the drawings of the embodiments of the present invention, and it is clear that the described embodiments are intended to be in an embodiment of the invention, not all of the embodiments. Based on the embodiments in the present invention, all other embodiments obtained without creative labor are not made in the premise of creative labor.

[0028] The present application is based on artificial intelligence SQL (Structure Language, Structured Query Language) statement generation method, can be applied figure 1 In the application environment, the computer device can communicate with the server via the network. Among them, the computer device can, but is not limited to, various personal computers, laptops, smartphones, tablets, and portable wearable devices. The server can be a stand-alone server, or a cloud service, cloud database, cloud computing, cloud function, clo...

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 discloses an SQL statement generation method based on artificial intelligence, is applied to the technical field of artificial intelligence, and is used for solving the technical problem of low sample corpus output efficiency caused by manual configuration of sample corpus in a traditional scheme. The method provided by the invention comprises the following steps: acquiring a Chinese question input by a user, and performing word segmentation processing on the Chinese question to obtain a plurality of words; according to the obtained word, matching a Chinese corpus template corresponding to the Chinese question in a plurality of pre-configured Chinese corpus templates to obtain a target Chinese corpus template; obtaining a pre-configured English corpus template uniquely corresponding to the target Chinese corpus template; identifying each English template slot position in the English corpus template; and obtaining values of a plurality of variables correspondingly configured with the English template slots, and sequentially filling the English template slots corresponding to the values of the variables to obtain a plurality of SQL query statements corresponding to the Chinese question.

Description

Technical field [0001] The present invention relates to the field of artificial intelligence, and more particularly to an artificial intelligence SQL statement generation method, a device, a computer device, and a storage medium. Background technique [0002] Text-to-SQL is a technology that converts the natural language to SQL query statements. Users can quickly get visual conversion results by entering a simple issue. For example, the user enters "The maximum of age" and converts to the SQL statement as "SELECT MAX (AGE) from User. Then, the model of the supervisory TextTOSQL is required to learn the ability to translate from a sentence into a SQL statement from one sentence. [0003] The process of training the model may be: the user configures a business table; builds 'questioning' and table field values, and the corpus corresponding to 'sql' is given to the Text2SQL model, the Bert model Or other models are trained. [0004] Obviously, sample corpus for training TextTOSQL mo...

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/242G06F40/289G06F40/279
CPCG06F16/2433G06F40/289G06F40/279
Inventor 袁超徐介夫
Owner PING AN TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap