A rule based approach for NLP based query processing

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. In order to retrieve information from a database, one needs to formulate a query in such way that the computer will understand and produce the desired output. Generally, query processing is handled by the Structured Query Language (SQL). But the non IT people cannot be able to write SQL queries as they may not be aware of the SQL as well as structure of the database. So there is a need for non-expert users to query the databases in their natural language instead of working with the values of the attributes. This paper proposes an approach for accessing the database easily using natural language without having any knowledge about the query language. The approach is a rule based approach. The obvious advantage is that it makes a great promise for computer interfaces easier for the use of general people. Because of this, people will be able to communicate to the computer in their own language instead of learning a specialized language or commands. In order to test our approach in an actual computer environment, we have developed a prototype system. We obtained promising results using our system.

[1]  Jyoti Pareek,et al.  NLKBIDB - Natural language and keyword based interface to database , 2013, 2013 International Conference on Advances in Computing, Communications and Informatics (ICACCI).

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

[3]  Liu Jianbo,et al.  Research on the Natural Language Querying for Remote Sensing Databases , 2012, 2012 International Conference on Computer Science and Service System.

[4]  Vaishali B. Bhagat,et al.  ACCESSING DATABASE USING NLP , 2013 .

[5]  Abhijeet Gupta,et al.  A Novel Approach Towards Building a Portable NLIDB System Using the Computational Paninian Grammar Framework , 2012, 2012 International Conference on Asian Language Processing.

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

[7]  Mahesh Motwani,et al.  Natural Language Interface to Database using Semantic Matching , 2011 .

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

[9]  Rajender Kumar,et al.  Translating controlled natural language query into SQL query using pattern matching technique , 2014, International Conference for Convergence for Technology-2014.

[10]  Tricya E. Widagdo,et al.  Natural Language Interfaces to Database (NLIDB): Question handling and unit conversion , 2014, 2014 International Conference on Data and Software Engineering (ICODSE).

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