Abstract:Developing general-purpose solutions that could be migrated to a variety of databases, companies, and data domains has been a big challenge for researchers for years. Today, most of the data is stored in relational databases, and extracting useful information from these databases requires special knowledge of the structured query language. Recent advances in natural language understanding and processing have led to renewed interest in natural language interfaces to database (NLIDB) approach, which provides a simple mechanism for non-technical users to access data from data storages. That is why NLIDB have attracted attention as useful tools that simplify interaction between users and computer systems. The paper describes the results of the NLIDB system design and software implementation. Created system allows to generate users-system dialogue and process its results to obtain formalized data about the data domain. The NLIDB pattern matching system approach that allows to set a template for control and clarification questions for users and form an algorithm for transforming knowledge about the data domain into a database structure was used in the research. Depending on the users’ responses, the system outputs the domain business rules, database diagram, SQL queries, and database file to users. The results of the developed NLIDB system testing are presented in the paper. The testing of the system was carried out to create a fragment of the database for storing invoice data. In order to check the adequacy of the proposed project solutions, an entity relation diagram for the document was used. The main problem in generating a database structure is the implementation of data normalization rules and checking for anomalies in the created database. Checking and optimizing of the developed database is carried out after populating a database with an initial data, by using a dialogue with users and applying queries to the created database tables.

NLP-SIR: A Natural Language Approach for Spreadsheet Information Retrieval

Querying Spreadsheets: An Empirical Study

A natural language interface to a graph-based bibliographic information retrieval system

Using NLP or NLP Resources for Information Retrieval Tasks

NLPIR: A theoretical framework for applying natural language processing to information retrieval

Spreadsheets in Financial Departments: An Automated Analysis of 65,000 Spreadsheets using the Luminous Technology

Excel Spreadsheet Analyzer

Early evaluation of a natural language processing tool to improve access to educational resources for surgical patients

NL2Formula: Generating Spreadsheet Formulas from Natural Language Queries

Progress in the Application of Natural Language Processing to Information Retrieval Tasks

NLPExplorer: Exploring the Universe of NLP Papers

A Survey of Natural Language Processing in Information Retrieval

SheetAgent: Towards A Generalist Agent for Spreadsheet Reasoning and Manipulation via Large Language Models

Natural Language Interface to Database Approach in the Task of Relational Databases Design

SheetCopilot: Bringing Software Productivity to the Next Level through Large Language Models

Introducing Information Retrieval for Biomedical Informatics Students

Evaluation of an Intelligent Assistive Technology for Voice Navigation of Spreadsheets

dIR -- Discrete Information Retrieval: Conversational Search over Unstructured (and Structured) Data with Large Language Models

A Natural Language Processing Pipeline for Detecting Informal Data References in Academic Literature

IR Design for Application-Specific Natural Language: A Case Study on Traffic Data

An accessible, efficient, and accurate natural language processing method for extracting diagnostic data from pathology reports