Constructing an Interactive Natural Language Interface for Relational Databases

@article{Li2014ConstructingAI,
  title={Constructing an Interactive Natural Language Interface for Relational Databases},
  author={Fei Li and H. V. Jagadish},
  journal={Proc. VLDB Endow.},
  year={2014},
  volume={8},
  pages={73-84}
}
Natural language has been the holy grail of query interface designers, but has generally been considered too hard to work with, except in limited specific circumstances. In this paper, we describe the architecture of an interactive natural language query interface for relational databases. Through a carefully limited interaction with the user, we are able to correctly interpret complex natural language queries, in a generic manner across a range of domains. By these means, a logically complex… 
Understanding Natural Language Queries over Relational Databases
TLDR
Through a carefully limited interaction with the user, the architecture of an interactive natural language query interface for relational databases is described, able to correctly interpret complex natural language queries, in a generic manner across a range of domains.
NEURON: An Interactive Natural Language Interface for Understanding Query Execution Plans in RDBMS
TLDR
A novel generic system called NEURON that facilitates natural language interaction with QEPs of SQL queries and facilitates understanding of various features related to the QEP through a natural language-based question answering framework.
A Natural Language Interface Supporting Complex Logic Questions for Relational Databases
TLDR
This paper introduced an NLIDB system which not only supports simple logic questions but also attempts to understand and resolve complex logic ones, and is equipped with a Natural Language Generation module to generate human-like description for given queries.
Fragment-Driven Natural Language Interaction with Databases
TLDR
This work proposes an alternative fragment-driven interaction model, where the system provides an explanation as to how the natural language produced the resulting SQL, which enables the user to interact with the system purely in natural language and to make incremental modifications to their resulting database query without having to learn any SQL.
“What Do You Mean by That?” - a Parser-Independent Interactive Approach for Enhancing Text-to-SQL
TLDR
A novel parser-independent interactive approach (PIIA) that interacts with users using multi-choice questions and can easily work with arbitrary parsers is presented and is capable of enhancing the text-to-SQL performance with limited interaction turns.
Towards Building A Domain Agnostic Natural Language Interface to Real-World Relational Databases
In this paper we present Surukam-NLI — a novel system of building a natural language interface to databases, which composes the earlier work on using linguistic syntax trees for parsing natural
Constructing Expressive Relational Queries with Dual-Specification Synthesis
TLDR
This work proposes dual-specification query synthesis which consumes both a NLQ and an optional PBElike table sketch query that enables users to express varied levels of knowledge and introduces the Duoqest system, which leverages guided partial query enumeration to efficiently explore the space of possible queries.
An efficient natural language interface to XML database
TLDR
A novel architecture which is capable of translating a wide range of natural language queries into formal database queries and can accept English language sentences and then it is translated into an XQuery expression.
Explaining Queries Over Web Tables to Non-experts
TLDR
This work augments a state-of-the-art NL interface over web tables, enhancing it in both its training and deployment phase, and introduces novel query explanations that provide a graphic representation of the query cell-based provenance in its execution on a given table.
Development of a Virtual View for Processing Complex Natural Language Queries
TLDR
This chapter describes a method for using a virtual view in a NLIDB, which allows processing queries that involve semantically implied entities more efficiently than a previous version of the interface that uses materialized views.
...
1
2
3
4
5
...

References

SHOWING 1-10 OF 24 REFERENCES
NaLIX: an interactive natural language interface for querying XML
TLDR
It is shown that NaLIX, while far from being able to pass the Turing test, is perfectly usable in practice, and able to handle even quite complex queries in a variety of application domains.
Towards a theory of natural language interfaces to databases
TLDR
This paper proves that, for a broad class of semantically tractable natural language questions, Precise is guaranteed to map each question to the corresponding SQL query, and shows that Precise compares favorably with Mooney's learning NLI and with Microsoft's English Query product.
NAUDA: a cooperative natural language interface to relational databases
TLDR
This paper describes the extension of a natural language interface to relational databases with respect to its cooperative behavior, and argues that cooperative support of users is especially important for a complex domain such as environmental protection.
Natural language interfaces to databases - an introduction
TLDR
This paper is an introduction to natural language interfaces to databases (NLIDBS) and some less explored areas of NLIDB research are presented, namely database updates, meta-knowledge questions, temporal questions, and multi-modal NLIDBS.
Modern Natural Language Interfaces to Databases: Composing Statistical Parsing with Semantic Tractability
TLDR
The paper shows how a strong semantic model coupled with "light re-training" enables PRECISE to overcome parser errors, and correctly map from parsed questions to the corresponding SQL queries.
Logos: a system for translating queries into narratives
TLDR
Logos, a system that provides natural language translations for relational queries expressed in SQL based on a graph-based approach to the query translation problem, is presented.
Précis: from unstructured keywords as queries to structured databases as answers
TLDR
This paper extends the semantics of précis queries considering that they may contain multiple terms combined through the AND, OR, and NOT operators, and defines the concept of a logical database subset, which is the one that is most relevant to a given query, and provides algorithms for its generation.
SQAK: doing more with keywords
TLDR
SQAK provides a novel and exciting way to trade-off some of the expressive power of SQL in exchange for the ability to express a large class of aggregate queries using simple keywords.
Keyword searching and browsing in databases using BANKS
TLDR
BANKS is described, a system which enables keyword-based search on relational databases, together with data and schema browsing, and presents an efficient heuristic algorithm for finding and ranking query results.
QueryViz: helping users understand SQL queries and their patterns
TLDR
In this demonstration, the visual alphabet is explained, the visualization algorithm is walked through, and users experience the difference in understanding SQL queries from text or graphical representation while browsing through repositories of well-known textbook SQL queries.
...
1
2
3
...