Natural language Interface for Database: A Brief review

Information is playing an important role in our lives. One of the major sources of information is databases. Databases and database technology are having major impact on the growing use of computers. Almost all IT applications are storing and retrieving information from databases. Retrieving information database requires knowledge of database languages like SQL. The Structured Query Language (SQL) norms are been pursued in almost all languages for relational database systems. However, not everybody is able to write SQL queries as they may not be aware of the structure of the database. So this has led to the development of Intelligent Database System ( IDBS) . There is an overwhelming need for non-expert users to query relational databases in their natural language instead of working with the values of the attributes. As a result many intelligent natural language interfaces to databases have been developed, which provides flexible options for manipulating queries. The idea of using Natural Language instead of SQL has prompted the development of new type of processing called Natural language Interface to Database. NLIDB is a step towards the development of intelligent database systems (IDBS) to enhance the users in performing flexible querying in databases. This paper is an introduction to Intelligent Database System and Natural Language Interface to Databases. Then a brief overview of NLIDB subcomponents is given and then discussion then moves on to NLIDB architectures and various approaches for the development of NLIDB systems.

[1]  Philip Resnik.  Access to Multiple Underlying Systems in Janus , 1989 .

[2]  Eugene Charniak,et al.  Statistical language learning , 1997 .

[3]  Risto Miikkulainen,et al.  Natural Language Processing with Subsymbolic Neural Networks , 2019, Neural Network Perspectives on Cognition and Adaptive Robotics.

[4]  H. V. Jagadish,et al.  Constructing a Generic Natural Language Interface for an XML Database , 2006, EDBT.

[5]  Oren Etzioni,et al.  Modern Natural Language Interfaces to Databases: Composing Statistical Parsing with Semantic Tractability , 2004, COLING.

[6]  Yuk Wah Wong,et al.  Learning for Semantic Parsing Using Statistical Machine Translation Techniques , 2005 .

[7]  Wendy G. Lehnert,et al.  Using Decision Trees for Coreference Resolution , 1995, IJCAI.

[8]  Bruce W. Ballard,et al.  Semantic Acquisition In TELI: A Transportable, User-Customized Natural Language Processor , 1986, ACL.

[9]  Lokendra Shastri,et al.  A Model of Rapid Memory Formation in the Hippocampal System , 2007 .

[10]  Douglas E. Appelt,et al.  TEAM: An Experiment in the Design of Transportable Natural-Language Interfaces , 1987, Artif. Intell..

[11]  H. V. Jagadish,et al.  NaLIX: an interactive natural language interface for querying XML , 2005, SIGMOD '05.

[12]  Risto Miikkulainen,et al.  Subsymbolic natural language processing - an integrated model of scripts, lexicon, and memory , 1993, Neural network modeling and connectionism.

[13]  Carole D. Hafner,et al.  Interaction of Knowledge Sources in a Portable Natural Language Interface , 1984, ACL.

[14]  P MarcusMitchell,et al.  Building a large annotated corpus of English , 1993 .

[15]  Paul W. Abrahams,et al.  The LISP 2 programming language and system , 1966, AFIPS '66 (Fall).

[16]  Bruce W. Ballard,et al.  LDC-1: a transportable, knowledge-based natural language processor for office environments , 1984, TOIS.

[17]  David L. Waltz,et al.  An English language question answering system for a large relational database , 1978, CACM.

[18]  Ellen Riloff,et al.  Automatically Generating Extraction Patterns from Untagged Text , 1996, AAAI/IAAI, Vol. 2.

[19]  Remko J. H. Scha,et al.  Philips question-answering system PHLIQA1 , 1977, SGAR.

[20]  R. Reilly,et al.  Connectionist approaches to natural language processing , 1994 .

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

[22]  Mark Chignell,et al.  Intelligent databases - object-oriented deductive hypermedia technologies , 1989 .

[23]  Elisa Bertino,et al.  Intelligent Database Systems , 2000 .

[24]  Fred J. Damerau,et al.  Operating Statistics for the Transformational Question Answering System , 1981, CL.

[25]  Barbara J. Grosz,et al.  TEAM: A Transportable Natural-Language Interface System , 1983, ANLP.

[26]  Kenneth Ward Church,et al.  Introduction to the Special Issue on Computational Linguistics Using Large Corpora , 1993, Comput. Linguistics.

[27]  Tore Amble.  BusTUC - A natural language bus route oracle , 2000, ANLP.

[28]  Rohit J. Kate,et al.  Using String-Kernels for Learning Semantic Parsers , 2006, ACL.

[29]  Beatrice Santorini,et al.  Building a Large Annotated Corpus of English: The Penn Treebank , 1993, CL.

[30]  James Henderson,et al.  Review of Connectionist approaches to natural language processing by Ronan G. Reilly and Noel E. Sharkey. Lawrence Erlbaum Associates 1992. , 1993 .

[31]  W. Teitelman.  PILOT: A STEP TOWARDS MAN-COMPUTER SYMBIOSIS , 1966 .

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

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

[34]  Ellen Riloff,et al.  Automatically Constructing a Dictionary for Information Extraction Tasks , 1993, AAAI.