Frameworks for Querying Databases Using Natural Language

2021 ◽  
Vol 17 (2) ◽  
pp. 21-38
Author(s):  
Syed Ahmad Chan Bukhari ◽  
Hafsa Shareef Dar ◽  
M. Ikramullah Lali ◽  
Fazel Keshtkar ◽  
Khalid Mahmood Malik ◽  
...  
Keyword(s):  
Natural Language ◽  
English Language ◽  
Query Language ◽  
Language Technology ◽  
Wide Range ◽  
Natural Language Interface ◽  
Database Query Language ◽  
Overall Performance ◽  
User Friendly ◽  
Language Text

A natural language interface is useful for a wide range of users to retrieve their desired information from databases without requiring prior knowledge of database query language such as SQL. The advent of user-friendly technologies, such as speech-enabled interfaces, have revived the use of natural language technology for querying databases; however, the most relevant and last work presenting state of the art was published back in 2013 and does not encompass several advancements. In this paper, the authors have reviewed 47 frameworks that have been developed during the last decade and categorized the SQL and NoSQL-based frameworks. Furthermore, the analysis of these frameworks is presented on the basis of criteria such as supporting language, scheme of heuristic rules, interoperability support, scope of the dataset, and overall performance score. The study concludes that the majority of frameworks focus on translating natural language queries to SQL and translates English language text to queries.

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

2021 ◽  
Vol 229 ◽  
pp. 01039
Author(s):  
Khadija Majhadi ◽  
Mustapha Machkour
Keyword(s):  
Natural Language ◽  
Query Language ◽  
Natural Language Interfaces ◽  
Recent Advances ◽  
Database Structure ◽  
Natural Language Interface ◽  
Information Management Systems ◽  
Database Query Language ◽  
Indispensable Tool ◽  
Expert Database

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.

Issues in the Syntactic Parsing of Queries for a Natural Language Interface to Databases

2021 ◽  
pp. 157-179
Author(s):  
Alexander Gelbukh ◽  
José A. Martínez F. ◽  
Andres Verastegui ◽  
Alberto Ochoa
Keyword(s):  
Natural Language ◽  
State Of The Art ◽  
Experimental Tests ◽  
Syntactic Parsing ◽  
Natural Language Interfaces ◽  
Natural Language Interface ◽  
Overall Performance

In this chapter, an exhaustive parser is presented. The parser was developed to be used in a natural language interface to databases (NLIDB) project. This chapter includes a brief description of state-of-the-art NLIDBs, including a description of the methods used and the performance of some interfaces. Some of the general problems in natural language interfaces to databases are also explained. The exhaustive parser was developed, aiming at improving the overall performance of the interface; therefore, the interface is also briefly described. This chapter also presents the drawbacks discovered during the experimental tests of the parser, which show that it is unsuitable for improving the NLIDB performance.

Translating Advanced Integrity Checking Technology to SQL

2002 ◽  
pp. 203-249 ◽  
Author(s):  
Hendrik Decker
Keyword(s):  
Natural Language ◽  
Order Logic ◽  
Predicate Calculus ◽  
Integrity Constraints ◽  
First Order Logic ◽  
First Order ◽  
Integrity Checking ◽  
Natural Language Interface ◽  
User Friendly ◽  
Declarative Specifications

The main goal of this chapter is to arrive at a coherent technology for deriving efficient SQL triggers from declarative specifications of arbitrary integrity constraints. The user may specify integrity constraints declaratively as closed queries in predicate calculus syntax (i.e., sentences in the language of first-order logic, abbr. FOL), as datalog denials, as query conditions in SQL WHERE clauses, or in some other, possibly more user-friendly manner (e.g., via a dialog-driven graphical or natural language interface which internally translates to equivalent WHERE clause conditions). As we are going to see, the triggers derived from such specifications behave such that whenever some update event would violate any of the integrity constraints, one or several of the triggers derived from that constraint are activated in order to enforce the constraint. That is, the violation is either prevented by rolling back the update or repaired instantly by subsequent further updates.

scholarly journals NLP TOKEN MATCHING ON DATABASE USING BINARY SEARCH

2012 ◽  
Vol 3 (1) ◽  
pp. 140-143
Author(s):  
Ekta Aggarwal ◽  
Shreeja Nair
Keyword(s):  
Natural Language ◽  
Language Processing ◽  
Time Complexity ◽  
Binary Search ◽  
Translation Process ◽  
Query Translation ◽  
Natural Language Text ◽  
Natural Language Interface ◽  
Reduced Time ◽  
Language Text

Natural Language Processing (NLP) is an area of research and application that explores how computers can be used to understand and manipulate natural language text or speech to do useful things. The paper deals with the concept of database where by the data resources data can be fetched and accessed accordingly with reduced time complexity. The retrieval techniques are pointed out based on the ideas of binary search. A natural language interface refers to words in its own dictionary as well as to the words in the standard dictionary, in order to interpret a query. The main contribution of this investigation is addressing the problem of improving the accuracy of the query translation process by using the information provided by the database schema.  

scholarly journals OLGA GRUSHIN`S LANGUAGE: A GLOBAL PERSPECTIVE ON LOCAL CULTURE

2021 ◽  
Vol 18 (1) ◽  
pp. 172-175
Author(s):  
E.S. Lebedeva ◽  
Keyword(s):  
English Language ◽  
Global Perspective ◽  
Local Culture ◽  
Russian Culture ◽  
Native Culture ◽  
Wide Range ◽  
The World ◽  
English Speaking ◽  
Global Language ◽  
Language Text

The writings of the Russian English-speaking author Olga Grushin have long been studied by Russian and international linguists and literary scholars, and revealed the way the Russian translingual writer builds her English-language text, what techniques she uses to convey features of her native culture. Olga Grushin positions herself as a Russian author, which is confirmed by the analysis of her writings. The present paper expands the material of the research and focuses on the analysis of the Twitter posts made by Olga Grushin. As Grushin's local culture is transmitted to the world through the global language - English, a wide range of readers for whom Russian culture is not native have access to her texts. This study also looks at how Grushin's Russian culture is perceived by English-speaking readers with different cultural background through their reviews of her novels in the Instagram.

Natural Language for Querying Geographic Databases

2021 ◽  
pp. 148-181
Author(s):  
Ghada Landoulsi ◽  
Khaoula Mahmoudi
Keyword(s):  
Natural Language ◽  
Query Language ◽  
Human Diseases ◽  
Temporal Data ◽  
Geographic Databases ◽  
Hazard Characterization ◽  
Wide Range ◽  
Structured Query Language ◽  
Geographic Data ◽  
Spatio Temporal

The amount of spatio-temporal data is growing as is its potential in improving several fields (such as hazard characterization and human diseases). Meanwhile, several problems have risen and concern specially retrieving, storing, and interpreting spatio-temporal phenomena. In fact, there is a need today to make the exploitation of this flood of information popularized for a wide range of users. Although this is not the case since now, generally managing such data requires specific skills, especially the structured query language (SQL) expertise. To profit a wide range of users from this technology, natural language is to be exploited to bridge the gap between non-expert users and geographic data exploitation. This is the scope of the chapter.

scholarly journals An Efficient Approach to Restructure Natural Language Text

2021 ◽  
Vol 23 (07) ◽  
pp. 1445-1452
Author(s):  
Dr. R. N. Kulkarni ◽  
◽  
Swetha Koduri ◽  
Keyword(s):  
Software Development ◽  
Natural Language ◽  
English Language ◽  
Design Elements ◽  
Natural Language Text ◽  
Efficient Approach ◽  
Input Text ◽  
The World ◽  
Automated Tool ◽  
Language Text

During the recent times, there is enormous growth found in the domain of software development across the world. Many organizations are automating all the activities in the organization and for the development of any customized application; the developing organization needs to gather the requirements from the client organization. The gathered requirements may be structured or unstructured because of the flexibility and ambiguity in the English language. The natural language sometimes has the problem of flexibility because of which the same term may be written in a different way. To overcome the problems of natural language statements, in this paper an automated tool is proposed to restructure the sentences, paragraphs, simple statements, compound statements and pages which are grammatically correct. This approach takes the input text and converts compound statements into simple statements, removing duplicate statements, places one statement per line and assigns sequence numbers to each physical statement. This enables us to extract the correct and complete meaning of the statements for further processing and output achieved is used for abstraction of design elements.

scholarly journals SpeakQL Natural Language to SQL

2021 ◽  
Vol 40 ◽  
pp. 03018
Author(s):  
Dhairya Shah ◽  
Aniruddha Das ◽  
Aniket Shahane ◽  
Dharmik Parikh ◽  
Pranit Bari
Keyword(s):  
Natural Language ◽  
Language Processing ◽  
Relational Databases ◽  
Query Language ◽  
Automatic Generation ◽  
Query Languages ◽  
Natural Language Interface ◽  
Open Issue ◽  
Conventional Structure ◽  
Structure Query

Incorporating SQL questions from normal language is a long-standing open issue and has been drawing in extensive intrigue as of late. Natural Language Interface (NLI) is the confluence of Natural Language Processing (NLP) and Human-Computer Interaction, which allows interaction between humans and computers through the utilization of Natural Language. Here we are gonna deal with the problem of automatic generation of Structured Query Language (SQL) queries. SQL is a database language for querying and manipulating relational databases. Despite the spectacular rise in the acceptance of relational databases, there is a fundamental limitaion to the ability to fetch data from those databases. One of the major reasons for this is the fact that the users of these relational databases need to comprehend convoluted structured query languages. In this body of work, we present an interface that allows users to interact with the databases using Natural Lanaguage as opposted to the conventional structure query languages.

Electron sources: Past, present, and future

1993 ◽  
Vol 51 ◽  
pp. 764-765
Author(s):  
David C Joy
Keyword(s):  
Glass Tube ◽  
Source Size ◽  
Electron Gun ◽  
Operating Parameters ◽  
Operational Parameters ◽  
Electron Sources ◽  
Difficult Decision ◽  
Probe Size ◽  
Wide Range ◽  
Overall Performance

The electron source is the most important component of the Scanning electron microscope (SEM) since it is this which will determine the overall performance of the machine. The gun performance can be described in terms of quantities such as its brightness, its source size, its energy spread, and its stability and, depending on the chosen application, any of these factors may be the most significant one. The task of the electron gun in an SEM is, in fact, particularly difficult because of the very wide range of operational parameters that may be required e.g a variation in probe size of from a few angstroms to a few microns, and a probe current which may go from less than a pico-amp to more than a microamp. This wide range of operating parameters makes the choice of the optimum source for scanning microscopy a difficult decision.Historically, the first step up from the sealed glass tube ‘cathode ray generator’ was the simple, diode, tungsten thermionic emitter.

Sign in / Sign up

Export Citation Format

Share Document