Герерація sql запитів використовуючи підходи обробки природньої мови

Abstract

A method for executing database queries using a natural language interface has been proposed, addressing a significant problem in database administration for people who lack SQL query writing skills. A module for the interface that can generate SQL instructions from natural language queries has been presented. Semantic grammar is used in the proposed architecture to convert queries in English into SQL queries that can be executed in the database.

In the modern era of information technology, access to relevant data is critically important for business users. However, many users do not possess SQL language skills or find writing long queries challenging. Automating the process of creating SQL queries using natural language processing (NLP) can significantly simplify access to databases. This paper presents the QCNER approach for automatic generation of SQL queries from natural language.