Title: Field-embedded database query system based on natural language processing

Authors: Fei Long

Addresses: Foreign Language School, Harbin University of Commerce, Harbin 150028, Heilongjiang, China; Artificial Intelligence and Human Languages Laboratory, Beijing Foreign Studies University, Beijing 10089, Beijing, China

Abstract: This research seeks to develop a paradigm that will improve user-database interaction. To convert the user's queries into structured query language (SQL), natural language processing (NLP) is needed, and then the SQL can be processed quickly by the query system in the embedded database. The primary goal of NLP is to facilitate human-computer interaction with little reliance on programming knowledge. To access the data efficiently, field embedded database query system (FEDQS) uses NLP to take in 2880 structured queries about train prices and seat availability from the train reservation database and turn them into a SQL query. Therefore, field embedded database query system (FEDQS) is suggested in this research to help the users access the data efficiently. The simulation findings show that the proposed method achieves a translation accuracy of 92%, precision of 91%, RMSE of 7%, and MAE of 9%.

Keywords: field embedded database; query system; natural language processing; NLP; structured query language; SQL.

DOI: 10.1504/IJES.2023.141925

International Journal of Embedded Systems, 2023 Vol.16 No.5/6, pp.331 - 342

Received: 20 Feb 2023
Accepted: 09 Sep 2023
Published online: 03 Oct 2024 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article