Chinese database SQL statement generation method and device, and storage medium

A database and sentence technology, applied in the direction of digital data processing, natural language data processing, special data processing applications, etc., can solve the problems of poor convenience and achieve the effect of speeding up, good user experience, and strong generalization ability

Active Publication Date: 2020-07-14
JIANGSU SECURITIES
View PDF3 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] The purpose of the present invention is to overcome the deficiencies in the prior art, to provide a Chinese database SQL statement generation method, equipment and storage media, which can effectively solve the problems of generalization, expansibility and poor convenience in the prior art question

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
  • Chinese database SQL statement generation method and device, and storage medium
  • Chinese database SQL statement generation method and device, and storage medium
  • Chinese database SQL statement generation method and device, and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] An embodiment of the present invention provides a method for generating SQL statements in a Chinese database based on NLP (Nature Language Processing, natural language processing). Aiming at the current extensive database interaction requirements, the embodiment of the present invention disassembles the construction of the SQL (Structured Query Language, Structured Query Language) statement into 8 subtasks, and utilizes the semantic representation model to carry out the natural language query statement and the list name of the table to be queried. After semantic encoding, sequential and combined predictions are made for the 8 subtasks respectively, combined with pre- and post-processing, and finally a complete executable SQL statement is formed. The present invention can directly convert query statements expressed in natural language into machine-executable SQL statements, avoiding the business and technical requirements of building SQL, simplifying data interaction logi...

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 a Chinese database SQL statement generation method and device, and a storage medium, and the method comprises the following steps: decomposing the construction of an SQL statement into a plurality of subtasks according to the types of tasks; carrying out semantic coding on the natural language query statement and the to-be-queried table column name by utilizing a semantic representation model, and then respectively carrying out sequential and united prediction on each sub-task; and combining the prediction results to generate the SQL statement. According to the method provided by the embodiment of the invention, the technical problems of poor generalization, expansibility, convenience and the like in the existing scheme can be effectively solved. Through combinationof pre-processing, post-processing and a deep learning model, end-to-end conversion from natural language statements to SQL statements is realized. And meanwhile, the SQL statement is subjected to sub-task disassembly, so that the complexity of model prediction is reduced, and the accuracy of SQL statement generation is improved.

Description

technical field [0001] The invention relates to a method, device and storage medium for generating SQL statements in a Chinese database, and belongs to the technical field of language processing. Background technique [0002] The essence of human-computer interaction is the interaction of data and information. In this era of information explosion, data is growing at an unprecedented rate. After sorting out the structured data, it needs corresponding machine language query to obtain its value. But for non-professionals, these machine languages ​​are undoubtedly unfriendly and unnatural, which greatly limits the quickness of user interaction with data. Therefore, how to quickly and conveniently generate SQL statements and provide query results according to user needs is of great significance for improving user experience. [0003] The commonly used methods and deficiencies of SQL statement generation in the current stage of data interaction process are specifically stated a...

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/2452G06F40/295G06F40/30
CPCG06F16/24522Y02D10/00
Inventor 张汝宸王玲孔亚洲朱德伟朱峰陈志宝张超
Owner JIANGSU SECURITIES
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