CFP last date
20 June 2024
Reseach Article

Natural Language Statement to SQL Query Translator

by Pranali P. Chaudhari
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 82 - Number 5
Year of Publication: 2013
Authors: Pranali P. Chaudhari
10.5120/14112-2152

Pranali P. Chaudhari . Natural Language Statement to SQL Query Translator. International Journal of Computer Applications. 82, 5 ( November 2013), 18-22. DOI=10.5120/14112-2152

@article{ 10.5120/14112-2152,
author = { Pranali P. Chaudhari },
title = { Natural Language Statement to SQL Query Translator },
journal = { International Journal of Computer Applications },
issue_date = { November 2013 },
volume = { 82 },
number = { 5 },
month = { November },
year = { 2013 },
issn = { 0975-8887 },
pages = { 18-22 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume82/number5/14112-2152/ },
doi = { 10.5120/14112-2152 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T21:56:59.059122+05:30
%A Pranali P. Chaudhari
%T Natural Language Statement to SQL Query Translator
%J International Journal of Computer Applications
%@ 0975-8887
%V 82
%N 5
%P 18-22
%D 2013
%I Foundation of Computer Science (FCS), NY, USA
Abstract

A Database is an organized collection of data. It is created to store large amount of data and retrieve it efficiently in less amount of time. To retrieve data from the database Structured Query Language (SQL) is used. SQL has its own syntax of query. To retrieve correct data from the database this query should be written in proper or correct syntax. Thus users should have sufficient knowledge of SQL to retrieve data. In this paper a light weight technique of converting a natural language statement into equivalent SQL statement is highlighted which when executed on database provides us with the accurate results. The main advantage of this technique is the users which are unknown to the syntax of SQL can also use the system and retrieve data.

References
  1. Faraj A. El-Mouadib, Zakaria Suliman Zubi, Ahmd A. Almagrous, "Generic interactive natural language interface to databases (GINLIDB)", EC'09 Proceedings of the 10th WSEAS international conference on evolutionary computing, ISBN: 978-960-474-067-3
  2. Rani Nelken, Nissim Francez, "Querying temporal databases using controlled natural language", Proceeding COLING '00 Proceedings of the 18th conference on Computational linguistics - Volume 2
  3. Alessandra Giordani, Alessandro Moschitti, "Semantic mapping between natural language questions and SQL queries via syntactic pairing", Proceeding NLDB'09 Proceedings of the 14th international conference on Applications of Natural Language to Information Systems, ISBN:3-642-12549-2 978-3-642-12549-2
  4. Alessandra Giordani and Alessandro Moschitti, "Translating Questions to SQL Queries with Generative Parsers Discriminatively Reranked", Proceedings of COLING 2012: Posters, pages 401–410, COLING 2012, Mumbai, December 2012.
  5. SQ-HAL: Natural language to SQL Translator, http://www. csse. monash. edu. au/hons/projects/2000/Supun. Ruwanpura/
  6. Popescu, A. M. , A Etzioni, O. , A Kautz, H. : Towards a theory of natural language interfaces to databases. In: Proceedings of the 2003 International Conference on Intelligent User Interfaces, Miami, Association for Computational Linguistics (2003).
  7. Frank S. C. Tseng, Chun-Ling Chen, "Extending the UML concepts to transform natural language queries with fuzzy semantics into SQL" Information and Software Technology, Volume 48, Issue 9, September 2006, Pages 901–914
  8. Thanisch P Androutsopoulos I, Ritchie G. 1995. Natural language interfaces to databases - an introduction. Journal of Language Engineering.
  9. I-S. Kang, J-H. Bae, J-H. Lee, "Database Semantics Representation for Natural Language Access", CW '02 Proceedings of the First International Symposium on Cyber Worlds (CW'02), ISBN:0-7695-1862-1
  10. Desai B Stratica, N. 2004. "Schema-based natural language semantic mapping. " In Proceedings of the 9th International Conference on Applications of Natural Language to Information Systems.
Index Terms

Computer Science
Information Sciences

Keywords

Structured Query Language Natural Language Statement.