NLKBIDB - Natural language and keyword based interface to database

One of the major source of information is database which plays an important role in computer field. Almost all IT applications are storing and retrieving information from databases. There are various interfaces available to retrieve data such as form based, natural language and keyword based. Data retrieval from the database requires knowledge of database language like SQL [1]. The need of natural language arises from the fact that common people (other than SQL experts) are not used to writing SQL query. Therefore researchers have identified a new system called Natural Language Interface to Database (NLIDB) and Keyword Based Interface to Database (KBIDB). In this paper we have proposed architecture of a Natural Language and Keyword Based Interface for Database (NLKBIDB) which provides solution for syntactically correct and incorrect natural language input query. Our partial experiment of Lexical Analyzer and Keyword based interface on agriculture survey database solves 53% of syntactically incorrect query which will not be solved by natural language interface resulting in increase of rate of SQL query conversion.

[1]  Sukho Lee,et al.  Path expression processing in Korean natural language query interface for object-oriented databases , 1995, 1995 IEEE International Conference on Systems, Man and Cybernetics. Intelligent Systems for the 21st Century.

[2]  Yan Shi,et al.  The study on natural language interface of relational databases , 2010, 2010 The 2nd Conference on Environmental Science and Information Application Technology.

[3]  Dongmo Zhang,et al.  The model design of a case-based reasoning multilingual natural language interface for database , 2002, Proceedings. International Conference on Machine Learning and Cybernetics.

[4]  Xiaofeng Meng,et al.  EasyQuerier: A Keyword Based Interface for Web Database Integration System , 2007, DASFAA.

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

[6]  Surajit Chaudhuri,et al.  DBXplorer: a system for keyword-based search over relational databases , 2002, Proceedings 18th International Conference on Data Engineering.

[7]  Nikos Papadakis,et al.  A tool for access to relational databases in natural language , 2011, Expert Syst. Appl..

[8]  Fangju Wang,et al.  Parsing "grammatically incomplete" natural language queries to spatial databases , 2001, Proceedings Joint 9th IFSA World Congress and 20th NAFIPS International Conference (Cat. No. 01TH8569).

[9]  Dietmar F. Rösner,et al.  NAUDA: a cooperative natural language interface to relational databases , 1993, SIGMOD '93.

[10]  Christian Callegari,et al.  Advances in Computing, Communications and Informatics (ICACCI) , 2015 .

[11]  Galina Datskovsky Moerdler,et al.  Semantic Interpretation of a Database Query Language , 1985, Data Knowl. Eng..

[12]  Hu Li,et al.  A WordNet-based natural language interface to relational databases , 2010, 2010 The 2nd International Conference on Computer and Automation Engineering (ICCAE).

[13]  Rajendra Akerkar,et al.  Natural Language Interface Using Shallow Parsing , 2008, Int. J. Comput. Sci. Appl..

[14]  G. A. Patil,et al.  Natural Language Database Interface for Selection of Data Using Grammar and Parsing , 2009 .

[15]  Alessandro Moschitti,et al.  Semantic Mapping between Natural Language Questions and SQL Queries via Syntactic Pairing , 2009, NLDB.

[16]  Safwan Shatnawi,et al.  Toward enhanced Natural Language Processing to databases: Building a specific domain Ontology derived from database conceptual model , 2010, 2010 The 7th International Conference on Informatics and Systems (INFOS).

[17]  Zakaria Suliman Zubi,et al.  Generic interactive natural language interface to databases (GINLIDB) , 2009 .

[18]  O. Enikuomehin.  LANLI: A Natural Language Interfacing Tool for Relational Database Query Generation , 2012 .

[19]  Bipin C. Desai,et al.  Using semantic templates for a natural language interface to the CINDI virtual library , 2005, Data Knowl. Eng..

[20]  Nuno J. Mamede,et al.  Databases and Natural Language Interfaces , 2000, JISBD.

[21]  B. Carminati,et al.  Computer Standards & Interfaces , 2009 .

[22]  P. Marino,et al.  Inlina: Interface In Natural Language For Queries On Distributed Database , 1991, Proceedings of the Annual International Conference of the IEEE Engineering in Medicine and Biology Society Volume 13: 1991.

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

[24]  Bei-Bei Huang,et al.  A Natural Language Database Interface Based on a Probabilistic Context Free Grammar , 2008, IEEE International Workshop on Semantic Computing and Systems.

[25]  Daniel Dominic Sleator,et al.  Parsing English with a Link Grammar , 1995, IWPT.

[26]  Jun Zhang,et al.  NUITS: a novel user interface for efficient keyword search over databases , 2006, VLDB.

[27]  Tien Dat Nguyen,et al.  A Vietnamese Natural Language Interface to Database , 2012, 2012 IEEE Sixth International Conference on Semantic Computing.

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

[29]  Frank S. C. Tseng,et al.  Enriching the class diagram concepts to capture natural language semantics for database access , 2008, Data Knowl. Eng..

[30]  George A. Miller,et al.  WordNet: A Lexical Database for English , 1995, HLT.

[31]  Ashish Tamrakar,et al.  Query Optimization Using Natural Language Processing , 2011 .

[32]  George A. Miller.  WordNet: A Lexical Database for English , 1992, HLT.

[33]  Sanjay Silakari,et al.  Natural language Interface for Database: A Brief review , 2011 .