Natural Language Database Interface System
(Redirected from Natural Language Interfaces to databases (NLIs))
Jump to navigation
Jump to search
A Natural Language Database Interface System is a Natural Language User Interface System that is based on a Database Query System.
- AKA: Natural Language Access to Database, NLIDB, NLDBI.
- Context:
- It can be solved by a Natural Language Database Interface Task by Implementing Natural Language Databese Interface Algorithms.
- It can range from being a simple Natural Language Interface to Databases System, to being a Web-Based Natural Language Interface to Databases System, to being a Neural Natural Language Interface to Databases System.
- Example(s):
- Counter-Example(s):
- See: User Interface, Natural Language Processing, Natural Language Understanding, Natural Language Generation, Question Answering Task.
References
2018
- (Utama et al., 2018) ⇒ Prasetya Utama, Nathaniel Weir, Fuat Basik, Carsten Binnig, Ugur Cetintemel, Benjamin Hattasch, Amir Ilkhechi, Shekar Ramaswamy, and Arif Usta. (2018). “An End-to-end Neural Natural Language Interface for Databases.” In: CoRR Journal, abs/1804.00401. arXiv:1804.00401
- QUOTE: Structured query language (SQL), despite its expressiveness, may hinder users with little or no relational database knowledge from exploring and making use of the data stored in an RDBMS. In order to effectively leverage their data sets, users are required to have prior knowledge about the schema information of their database, such as table names, columns and relations, as well as a working understanding of the syntax and semantics of SQL. These requirements set “a high bar for entry” for democratized data exploration and thus have triggered new research efforts no develop alternative interfaces that allow non-technical users to explore and interact with their data conveniently. While visual data exploration tools have recently gained significant attention, Natural Language Interfaces to Databases (NLIDBs) appear as highly promising alternatives because they enable users to pose complex ad-hoc questions in a concise and convenient manner.
2014
- (Li & Jagadish, 2014) ⇒ Fei Li, and H. V. Jagadish. (2014). “Constructing An Interactive Natural Language Interface for Relational Databases.” In: Proceedings of the VLDB Endowment Journal, 8(1). doi:10.14778/2735461.2735468
- QUOTE: NLIDBs have many advantages over other widely accepted query interfaces (keyword-based search, form-based interface, and visual query builder). For example, a typical NLIDB would enable naive users to specify complex, ad-hoc query intent without training. In contrast, keywords are insufficient to convey complex query intent, form-based interfaces can be used only when queries are predictable and limited to the encoded logic, and visual query builders still requires extensive schema knowledge of the user.
(...) we propose an NLIDB comprising three main components: a first component that transforms a natural language query to a query tree, a second component that verifies the transformation interactively with the user, and a third component that translates the query tree into a SQL statement. We have constructed such an NLIDB, and we call it a NaLIR (Natural Language Interface to Relational databases).
- QUOTE: NLIDBs have many advantages over other widely accepted query interfaces (keyword-based search, form-based interface, and visual query builder). For example, a typical NLIDB would enable naive users to specify complex, ad-hoc query intent without training. In contrast, keywords are insufficient to convey complex query intent, form-based interfaces can be used only when queries are predictable and limited to the encoded logic, and visual query builders still requires extensive schema knowledge of the user.
2008
- (Garcia et al., 2008) ⇒ Krissanne Kaye Garcia, Ma Angelica Lumain, Jose Antonio Wong, Jhovee Gerard Yap, and Charibeth Cheng. (2008). “Natural Language Database Interface for the Community Based Monitoring System.” In: Proceedings of the 22nd Pacific Asia Conference on Language, Information and Computation.
- QUOTE: A NLDBI allows users to access a database using natural language query. It accepts a user query, extracts pertinent data from the query, converts the extracted data to SQL, then retrieves the data from the database. AlLaDIn is domain-dependent, database-dependent natural language interface for CBMS-Pasay.
1995
- (Androutsopoulos et al., 1995) ⇒ I. Androutsopoulos, G.D. Ritchie, and P. Thanisch. (1995). “Natural Language Interfaces to Databases - An Introduction.” In: Natural Language Engineering Journal, 1(1). Cambridge University Press. doi:10.1017/S135132490000005X. arXiv:cmp-lg/9503016
- QUOTE: A natural language interface to a database (NLIDB) is a system that allows the user to access information stored in a database by typing requests expressed in some natural language (e.g. English)(...)
The following are some of the commercially available NLIDBs:
- INTELLECT [56] from Trinzic (formed by the merger of AICorp and Aion). This system is based on experience from Robot [53] [54] [55].
- BBN's PARLANCE [12], built on experience from the development of the RUS [16] and IRUS [11] systems.
- IBM's LANGUAGEACCESS [76]. This system stopped being commercially available in October 1992.
- Q&A from Symantec.
- NATURAL LANGUAGE from Natural Language Inc. According to [29], this system was previously known as DATATALKER, it is described in [72], and it is derived from the system described in [46].
- LOQUI [15] from BIM.
- ENGLISH WIZARD from Linguistic Technology Corporation. The company was founded by the author of AICorp’s original INTELLECT.
- QUOTE: A natural language interface to a database (NLIDB) is a system that allows the user to access information stored in a database by typing requests expressed in some natural language (e.g. English)(...)