Review on conversion of natural language queries into SQL queries
Main Article Content
Abstract
Natural language processing is a vast field of research in computer science which aims at simplifying the interactions between computers and humans. The research creates an interface (NLIDB) which inputs the user query and then parses the query thereby generating an XML from that and then converts it into a SQL query that is finally executed to display the intended result. The input query is converted into sentence vectors and then filtering and stemming techniques are applied on it to finally generate a series of tokens which contain each word in its most raw format. This array of tokens is used to design conversion of query into a new language (XML based) i.e SQML, whose DTD will specify the tags which are permitted in language. We also create the query parser which creates the XML for the user query and finally, the XML is converted into SQL query. The research methodology will be programmed in java language due to its easy and quick XML generation and parsing. The conversion into SQML makes the query exportable into many other language independent formats like JSON and can be used for different purposes.
Downloads
Download data is not yet available.
Article Details
Section
Articles
COPYRIGHT
Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work
- The journal allows the author(s) to retain publishing rights without restrictions.
- The journal allows the author(s) to hold the copyright without restrictions.