Zobraziť v EDS

Review on conversion of natural language queries into SQL queries.

Uložené v:
Podrobná bibliografia
Názov: Review on conversion of natural language queries into SQL queries.
Autori: Manisha, Malhotra, Sona
Zdroj: International Journal of Advanced Research in Computer Science; May/Jun2017, Vol. 8 Issue 5, p1036-1038, 3p
Predmety: SQL, DECLARATIVE programming languages, PROGRAMMING languages, QUERY languages (Computer science), DATABASE management
Abstrakt: Natural language processing is a vast field of research in computer science which aims at simplifying 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. [ABSTRACT FROM AUTHOR]
Copyright of International Journal of Advanced Research in Computer Science is the property of International Journal of Advanced Research in Computer Science and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)
Databáza: Complementary Index
Popis
Abstrakt:Natural language processing is a vast field of research in computer science which aims at simplifying 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. [ABSTRACT FROM AUTHOR]
ISSN:09765697