High Impact Factor : 4.396 icon | Submit Manuscript Online icon |

DB Mapping and IQML Generation for SQL Queries Generated from Natural Language Queries

Author(s):

Manisha , UIET,KURUKSHETRA UNIVERSITY,KURUKSHETRA; Sona Malhotra, UIET,KURUKSHETRA UNIVERSITY,KURUKSHETRA

Keywords:

XML (Extensible Markup Language), DTD (Document Type Definition), RDBMS, SQL

Abstract

Natural language processing has always been an area of great interest to the research scholars and NLIDB (Natural language interface for databases) is that field which uses the techniques defined in NLP to the best possible level to create an interface for humans which interacts with database like an SQL expert does. An advanced XML based technique is defined which convert the natural language queries into SQL queries. An interface (IQML based DBMapper) is defined which inputs the user query and then parses the query generating an IQML which gets converted into a SQL query with the help of DBMapper which is finally executed and then the intended result is displayed. The proposed research methodology is programmed in java language due to its ease and quick XML generation and parsing. The conversion into IQML makes the query exportable into many other language independent formats like JSON and can be used for different purposes.

Other Details

Paper ID: IJSRDV5I50859
Published in: Volume : 5, Issue : 5
Publication Date: 01/08/2017
Page(s): 682-685

Article Preview

Download Article