
Home

Selforganizology, 2016, 3(3): 100-116
[XML] [EndNote] [RefManager] [BibTex] [

Full PDF (634K)] [Comment/Review Article]

Article

An algorithm to transform natural language into SQL queries for relational databases

Garima Singh, Arun Solanki
Department of Computer Science and Engineering, Gautam Buddha University, Greater Noida, India

Received 12 April 2016;Accepted 18 May 2016;Published online 1 September 2016
IAEES

Abstract
Intelligent interface, to enhance efficient interactions between user and databases, is the need of the database applications. Databases must be intelligent enough to make the accessibility faster. However, not every user familiar with the Structured Query Language (SQL) queries as they may not aware of structure of the database and they thus require to learn SQL. So, non-expert users need a system to interact with relational databases in their natural language such as English. For this, Database Management System (DBMS) must have an ability to understand Natural Language (NL). In this research, an intelligent interface is developed using semantic matching technique which translates natural language query to SQL using set of production rules and data dictionary. The data dictionary consists of semantics sets for relations and attributes. A series of steps like lower case conversion, tokenization, speech tagging, database element and SQL element extraction is used to convert Natural Language Query (NLQ) to SQL Query. The transformed query is executed and the results are obtained by the user. Intelligent Interface is the need of database applications to enhance efficient interaction between user and DBMS.

Keywords natural language query interface;natural language processing;ambiguity;SQL.

International Academy of Ecology and Environmental Sciences. E-mail: office@iaees.org
Copyright © 2009-2024 International Academy of Ecology and Environmental Sciences. All rights reserved.
Web administrator: office@iaees.org, website@iaees.org; Last modified: 2024/5/3

Translate page to: