BI query method, apparatus and device based on NL2SQL and medium

Abstract

The invention provides a BI query method, apparatus and device based on NL2SQL and medium, and a medium. The method comprises the steps of obtaining a feature vector of a to-be-processed text; calculating similarity according to the feature vector and a plurality of preset table feature vectors, and determining a first table corresponding to the feature vector according to the similarity; inputting the information of the first table and the to-be-processed text into a pre-trained NL2SQL model to obtain SQL label data; confirming a query result corresponding to the to-be-processed text according to the SQL label data, wherein the NL2SQL model is obtained by training according to first training sample data and SQL label data corresponding to the first training sample data, and the first training sample data comprises a plurality of sample questions and sample tables corresponding to the plurality of sample questions. According to the query method provided by the invention, the accuracy and efficiency of model analysis and recognition can be improved, and the accuracy of question query is improved.

Description

technical field [0001] The present invention relates to the field of database technology, in particular to a BI query method, device, equipment and medium based on NL2SQL Background technique [0002] With the rapid development of informatization, the application of databases is becoming more and more common. People hope that according to the input questions, they can quickly query the corresponding results from the database. [0003] At present, the Chinese NL2SQL (Natural Language to SQL) technology is still immature, and it mainly faces challenges in three aspects: the lack of Chinese data sets, the lack of background knowledge support for query intent conversion, and the accuracy of model analysis. In addition, some colloquial abbreviations and descriptions increase Reduced the difficulty of NL2SQL parsing. In enterprise-level applications, there are high requirements for user interaction, not only expecting to be able to automatically match data tables, but also strict...

AI Technical Summary

Problems solved by technology

[0004] The present invention provides a BI query method, device, equipment and medium based on NL2SQL to solve the technical problems in the prior art that the tables cannot be dynamically associated, the accuracy of model analysis is low, and enterprise-level applications cannot be realized. The purpose of improving the accuracy of model analysis and database query efficiency

Images