Generic Querying of Relational Databases using Natural Language Generation Techniques

This paper presents a method of querying databases by means of a natural language-like interface which offers the advantage of minimal configuration necessary for porting the system. The method allows us to first automatically infer the set of possible queries that can apply to a given database, automatically generate a lexicon and grammar rules for expressing these queries, and then provide users with an interface that allows them to pose these queries in natural language without the well-known limitations of most natural language interfaces to databases. The way the queries are inferred and constructed means that semantic translation is performed with perfect reliability.

[1]  Harry R. Tennant,et al.  Usable natural language interfaces through menu-based natural language understanding , 1983, CHI '83.

[2]  Eva-Martin Mueckstein.  Controlled natural language interfaces (extended abstract): the best of three worlds , 1985, CSC '85.

[3]  R. Power,et al.  Intuitive querying of e-Health data repositories , 2005 .

[4]  Carole D. Hafner,et al.  Portability of syntax and semantics in DATALOG , 1985, TOIS.

[5]  Harry R. Tennant,et al.  Talk to Your Semantic Web , 2005, IEEE Internet Comput..

[6]  Peter Thanisch,et al.  MASQUE/SQL: an efficient and portable natural language query interface for relational databases , 1993 .

[7]  H. Uszkoreit,et al.  Querying Structured Knowledge Sources , 2005 .

[8]  Richard Power,et al.  Evaluation of the CLEF query interface , 2006 .

[9]  Oren Etzioni,et al.  Towards a theory of natural language interfaces to databases , 2003, IUI '03.

[10]  Richard Power,et al.  Multilingual Authoring Using Feedback Texts , 1998, COLING-ACL.

[11]  Rohit J. Kate,et al.  Learning to Transform Natural to Formal Languages , 2005, AAAI.

[12]  Raymond J. Mooney,et al.  Using Multiple Clause Constructors in Inductive Logic Programming for Semantic Parsing , 2001, ECML.

[13]  Paul Piwek,et al.  ITRI-00-12 Natural Language Generation in the MILE System , 2000 .

[14]  Raymond Turner,et al.  A Formal Approach to Translating English into SQL , 1991, BNCOD.

[15]  Paul Piwek,et al.  ITRI-0203 Requirements Definition , Validation , Verification and Evaluation of the CLIME Interface and Language Processing Technology , 2002 .

[16]  Gary G. Hendrix,et al.  Developing a natural language interface to complex data , 1977, TODS.

[17]  John D. Burger,et al.  Problems in Natural-Language Interface to DBMS With Examples From EUFID , 1983, ANLP.

[18]  Ioannis Androutsopoulos,et al.  Interfacing a Natural Language Front-End to a Relational Database , 1992 .

[19]  S. Jerrold Kaplan,et al.  Designing a Portable Natural Language Database Query System , 1984, TODS.

[20]  Gregor Erbach,et al.  ProFIT: Prolog with Features, Inheritance and Templates , 1995, EACL.

[21]  Frank Meng,et al.  Query formulation from high-level concepts for relational databases , 1999, Proceedings User Interfaces to Data Intensive Systems.

[22]  Peter Thanisch,et al.  Natural language interfaces to databases – an introduction , 1995, Natural Language Engineering.