Querying database using a universal natural language interface based on machine learning

Bais, Hanane; Machkour, Mustapha; Koutti, Lahcen

doi:10.1109/it4od.2016.7479304

Cited by 15 publications

(4 citation statements)

References 8 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Hanane Bais et al [6] developed a non-exclusive regular language interface with an AI technique for a social information base. The advantage of this interface is that it has a freely usable information base that naturally grows over time as a result of experience.…”

Section: Literature Reviewmentioning

confidence: 99%

Review on a rule based approach to align natural language with query language

Singh,

Bansal

2023

Int. J. Comput. Programming Database Manage.

View full text Add to dashboard Cite

Information is crucial to our daily life in the globe. Databases are one of the main sources of information. Massive amounts of data are stored in databases. For access to that data, knowledge of structured query language is necessary. The requirement for a system that converts text to a SQL query itself rather than the user arises from the fact that not all non-technical people can do that. Due to its importance in industry and commerce, the text to SQL task is also essential. The system that supports the text-to-SQL job is called Natural Language Interface to Database (NLIDB). The creation of the NLIDB system has long been a challenge. In this paper, we review the current work and summarize the research trends of NLIDB.

show abstract

Section: Literature Reviewmentioning

confidence: 99%

Review on a rule based approach to align natural language with query language

Singh,

Bansal

2023

Int. J. Comput. Programming Database Manage.

View full text Add to dashboard Cite

show abstract

“…There is also a system that is developed this year that allows user queries to be evaluated with high security: when ambiguities exist, the system generates multiple probable interpretations for the user. Next, so many systems were developed such as a system for querying the database using a Universal Natural Language Interface based on Machine Learning approach (2016) [25], An Arabic Natural Language Interface for Querying Relational Databases based on Natural Language Processing and Graph theory methods (2018) [26].…”

Section: The History Of Nlidb Systems: Literature Surveymentioning

confidence: 99%

The history and recent advances of Natural Language Interfaces for Databases Querying

Majhadi

Machkour

2021

E3S Web Conf.

Self Cite

View full text Add to dashboard Cite

Databases have been always the most important topic in the study of information systems, and an indispensable tool in all information management systems. However, the extraction of information stored in these databases is generally carried out using queries expressed in a computer language, such as SQL (Structured Query Language). This generally has the effect of limiting the number of potential users, in particular non-expert database users who must know the database structure to write such requests. One solution to this problem is to use Natural Language Interface (NLI), to communicate with the database, which is the easiest way to get information. So, the appearance of Natural Language Interfaces for Databases (NLIDB) is becoming a real need and an ambitious goal to translate the user’s query given in Natural Language (NL) into the corresponding one in Database Query Language (DBQL). This article provides an overview of the state of the art of Natural Language Interfaces as well as their architecture. Also, it summarizes the main recent advances on the task of Natural Language Interfaces for databases.

show abstract

“…For this purpose, we use an Automatic Producer of Syntax Rules (APSR). The operation of APSR is based on machine learning approach which consists in automatically producing all new rules necessary to parse the FNLQ [23]. It has two roles:…”

Section: Noun → Clientmentioning

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

Querying database using a universal natural language interface based on machine learning

Cited by 15 publications

References 8 publications

Review on a rule based approach to align natural language with query language

Review on a rule based approach to align natural language with query language

The history and recent advances of Natural Language Interfaces for Databases Querying

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

Contact Info

Product

Resources

About