Interactive natural language interface (original) (raw)
Related papers
Generic Interactive Natural Language Interface to Databases (GINLIDB)
To override the complexity of SQL, and to facilitate the manipulation of data in databases for common people (not SQL professionals), many researches have turned out to use natural language instead of SQL. The idea of using natural language instead of SQL has prompted the development of new type of processing method called Natural Language Interface to Database systems (NLIDB). The NLIDB system is actually a branch of more comprehensive method called Natural Language Processing (NLP). In general, the main objective of NLP research is to create an easy and friendly environment to interact with computers in the sense that computer usage does not require any programming language skills to access the data; only natural language (i.e. English) is required.
A Comprehensive Study on Natural Language Processing and Natural Language Interface to Databases
It was highly desirable for a machine to interact more friendly with the users so that the field of Natural Language Processing (NLP) emerged and Natural Language Interface to Databases (NLIDBs) systems are built and design. A major problem faced by the users of the data bases is that the databases generally make use of special purpose languages familiar only to the trained users like Structured Query Language (SQL). Natural Language Interface to Databases provides the interface in which queries are written in the form Natural Language. These queries are passed through the machine, machine translates these queries. There are different levels of it, after passing these levels machine produce relevant results. This paper will provides comprehensive understanding about Natural Language Processing and Natural Language Interface to Databases.
SURVEY OF NATURAL LANGUAGE INTERFACE TO DATABASES
This paper is an introduction to the natural language interfaces to databases (NLIDBS). First the applications of natural language processing (NLP) is presented. Some already developed systems are then discussed followed by the discussion of the components of NLIDB. Comparison of NLIDBS to corpus based, rule based and connectionist approaches are then discussed. The discussion then moves on to various techniques are discussed. Comparisons among already developed NLIDBs Systems described in tabular form.
An Advanced Natural Language Interface to Databases
Database management systems have been widely used for storing and retrieving data. However, databases are difficult to use and there interface is complex and the same is difficult to access. To make it easy for a user to retrieve data, an interface is developed in which a database can be accessed by a user through querying in Hindi language and to get the result in same language. In order to develop an improved Hindi language graphical user interface to database management system. The proposed system can handle single and multiple columns retrieval queries, selection of whole table, conditional queries (between, in), join queries and queries that include nested, functions and logical operators. Since a user should not be able to update or delete data from database so the user is suggest on selection queries.
Natural Language Interfaces to Databases: An Analysis of the State of the Art
People constantly make decisions based on information, most of which is stored in databases. Accessing this information requires the use of query languages to databases such as SQL. In order to avoid the difficulty of using these languages for users who are not computing experts, Natural Language Interfaces for Databases (NLIDB) have been developed, which permit to query databases through queries formulated in natural language. Although since the 60s many NLIDBs have been developed, their performance has not been satisfactory, there still remain very difficult problems that have not been solved by NLIDB technology, and there does not yet exist a standardized method of evaluation that permits to compare the performance of different NLIDBs. This chapter presents an analysis of NLIDBs, which includes their classification, techniques, advantages, disadvantages, and a proposal for a proper evaluation of them.
International Journal of Advance Research, Ideas and Innovations in Technology, 2019
In this research, an intelligent system is designed for users to access the database using natural language. It accepts natural language input and then converts it into an SQL query. Using query language for dealing with databases has always been a professional and complex problem. The system currently handles single sentence natural language inputs and concentrates on MySQL database system. The system accommodates aggregate functions, multiple conditions in WHERE clause, join operations, advanced clauses like ORDER BY, GROUP BY and HAVING. The natural language statement goes through various stages of Natural Language Processing like morphological, lexical, syntactic and semantic analysis resulting in SQL query formation. Intelligent Interface is the need for database applications to enhance efficient interaction between user and DBMS. The research focuses on making the system more dynamic. Improvements have been introduced to the system by incorporating preprocessing of text, named entity recognition, building hierarchical relations, semantic similarity and negation handling using dependency graphs.
The history and recent advances of Natural Language Interfaces for Databases Querying
2021
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 ...
Natural Language Interface for Web-based Databases
Advances in the work on interfaces that facilitate access to databases through Internet are presented. Increasing needs of the users that access computer resources, the technological advance in this field, and the limitations of the graphic interfaces and forms motivate the development of new solutions in human-machine interfaces. In recent years, natural language processing has received a new impulse and achieved sufficient maturity to become a real solution in human-machine interfaces. A general architecture of a system of natural language interface to Web-based databases is described, as well as the current advance of the project. A detailed review of the history and the state of the art of the problem is given.
Natural Language Web Interface for Database (NLWIDB)
Proceedings of the Third International Symposium, SEUSL, 2013
It is a long term desire of the computer users to minimize the communication gap between the computer and a human. On the other hand, almost all ICT applications store information in to databases and retrieve from them. Retrieving information from the database requires knowledge of technical languages such as Structured Query Language. However majority of the computer users who interact with the databases do not have a technical background and are intimidated by the idea of using languages such as SQL. For above reasons, a Natural Language Web Interface for Database (NLWIDB) has been developed. The NLWIDB allows the user to query the database in a language more like English, through a convenient interface over the Internet.