A Model of a Generic Natural Language Interface for Querying Database

Bais, Hanane; Machkour, Mustapha; Koutti, Lahcen

doi:10.5815/ijisa.2016.02.05

Cited by 10 publications

(6 citation statements)

References 13 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Unlike a conventional RDBMS, this system is entirely structured on inter-relationships between data by treating them not as a schema structure but as data, just like other values. There are four main steps involved in the conversion of natural language input to SQL queries [18][19][20][21][22][23][24][25].…”

Section: Refmentioning

confidence: 99%

Structuring Natural Language to Query Language: A Review

Nethravathi¹,

Amitha²,

Saruka³

et al. 2020

Eng. Technol. Appl. Sci. Res.

View full text Add to dashboard Cite

SQL (Structured Query Language) is a structured language for specialized purposes used to communicate with the data stored in a database management system. It uses dynamic and sophisticated query commands for processing and controlling data in a database, which can become an obstacle for users with no previous experience. In order to address this constraint, we have analyzed the existing models in Natural Language Processing, which convert a native-language query into an SQL query. Thus, any novice user can use the SQL program and eliminate the need to generate any complex queries. This work is a detailed survey of the existing literature.

show abstract

Section: Refmentioning

confidence: 99%

Structuring Natural Language to Query Language: A Review

Nethravathi¹,

Amitha²,

Saruka³

et al. 2020

Eng. Technol. Appl. Sci. Res.

View full text Add to dashboard Cite

show abstract

“…By expressing the logical query in XML form, the proposed interface can function independently of the database domain and model (Relational and XML). Figure 1 shows the proposed architecture [20].…”

Section: Proposed Systemmentioning

confidence: 99%

Method and Apparatus for Querying Relational and XML Database Using French Language

Bais¹,

Machkour²

2019

RIA

Self Cite

View full text Add to dashboard Cite

The extraction of the information from database systems requires the formulation of queries using database query languages, such as Structured Query Language (SQL). This formulation needs the knowledge of the model and the structure of the database. However, non-expert users cannot write such queries. This is why a lot of works have been developed to request the database in natural language. Historically, most of these works were carried out for English language and they were designed for a specific database model. Some of them function independently of database domain. For the French language, all existing contributions are dependent on database domain and model. The aim of this paper is to present a model of an intelligent interface to query databases using the French language. A simulation model was established through the using of linguistic operations and machine learning. The results indicate that the proposed interface functions independently of the database domain and model (relational and XML) and it can translate a very important number of French natural language query into a database query. The findings of this research may serve to improve the interaction between non-expert French users and databases.

show abstract

“…This paper aims to combine this technology and create an environment where anybody can create a SQL query and work on relational databases. The user can interact with a computer specifying his data requirements from the databases in natural language by speaking it to an application that listens and converts the speech into text, and then preprocessing the text for understanding the user requirements and creating a structured query, which can be used to get the data from the database [1]. The neural network model is used as it gives the most accurate result compared to other technologies.…”

Section: Introductionmentioning

confidence: 99%

AI Model to Generate SQL Queries from Natural Language Instructions through Voice

Sawant¹,

Raina²,

Patil³

et al. 2022

J. Phys.: Conf. Ser.

View full text Add to dashboard Cite

Data plays the most important role in the development of industries, small businesses. Even world leaders need the data to make analyses and make better policies for people. In almost every field where the work process is digitized need to store data and then retrieve it. According to statistics most of the data is stored in the relational database and for manipulations of the data, Structured Query Language(SQL) is commonly used. So for handling databases a person need to have specialized knowledge regarding the queries and had to remember the syntax of many complex queries. So to enhance data manipulation using SQL and to efficiently get the required query, the paper proposes a method for the generation of SQL query from natural language input, spoken(audio input) by the user. The model is constructed on NLP (Natural Language Processing) and Neural Networks (Deep Learning) technologies. Long Short Term Memory(LSTM) Model is used for predicting queries and is trained on the dataset with natural language as input and returns outline skeletal structure of the query as output. Then the output will be processed and the final query will be displayed to the user. The project also aims to benefit the people who are suffering from Repetitive Stress Injury (RSI), causing pain in the finger joints, which has been attributed to work requiring a long period of typing and also to those who are not familiar with SQL queries. As this system will readily provide the required query.

show abstract

A Model of a Generic Natural Language Interface for Querying Database

Cited by 10 publications

References 13 publications

Structuring Natural Language to Query Language: A Review

Structuring Natural Language to Query Language: A Review

Method and Apparatus for Querying Relational and XML Database Using French Language

AI Model to Generate SQL Queries from Natural Language Instructions through Voice

Contact Info

Product

Resources

About