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

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

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

Images