A Domain and Language Construct based Mapping to Convert Natural Language Query to SQL

Alka Malik, Rahul Rishi
2015 International Journal of Computer Applications  
Database management systems (DBMS) have been widely used for storing and retrieving data. However, databases are often hard to use since their interface is quite rigid in cooperating with users. End user is required to issue SQL query to retrieve information from the database. Thus, a user cannot interact directly because of lack of knowledge about the SQL query form, thus is restricted to available application options. To provide the direct access of user on dataset, some unstructured query
more » ... cessor is required. The present work is an interface that will convert the unstructured text query to structured SQL query. It is an intelligent interface formation between the user and the dataset and defined in three main stages namely Descriptive Database Construction, Unstructured Query Filtration and Mapping Stage. The system provide the robustness in terms to handle the broader range of user queries and is be implemented in java environment on Enterprise Employee Database.
doi:10.5120/20325-2444 fatcat:vdjjmag3ajhjpougqjkguopc7a