IJSTR

International Journal of Scientific & Technology Research

Home About Us Scope Editorial Board Blog/Latest News Contact Us
0.2
2019CiteScore
 
10th percentile
Powered by  Scopus
Scopus coverage:
Nov 2018 to May 2020

CALL FOR PAPERS
AUTHORS
DOWNLOADS
CONTACT

IJSTR >> Volume 8 - Issue 8, August 2019 Edition



International Journal of Scientific & Technology Research  
International Journal of Scientific & Technology Research

Website: http://www.ijstr.org

ISSN 2277-8616



Using Deep Learning Technique To Query Relational Data Using Multi-Lingual Query Generator And Translator With NLP Support

[Full Text]

 

AUTHOR(S)

Sunilkumar N. Beghele, Pallavi V. Kulkarni

 

KEYWORDS

natural language processing, SQL, natural language query interface, ambiguity.

 

ABSTRACT

A smart and intelligent interface utilized & enhance effective interaction between its' users with the underlying databases. Such a system application needs for complex query problem as faced by the user who has an understanding of databases. The database should be efficient and should allow quick access. However, all users are unfamiliar and accustomed to queries and structural implementation in structured_query_language (SQL) because of lack of knowledge, of structure info database. Therefore, naiveusers need an intermediate system interact RDB natural_language that is English. For the same, (Database_Management_System) with the ability to inter-compile natural_language (NL). In the research proposal, we intend to create-develop an interface using Meaningful matching techniques that will translate natural search terms as SQL using a predefined set of written production rules and predefined data dictionaries, the data dictionary will consist of a set of definitions for relationships and properties. Pair of steps, such that lowercase conversion, tagging, tokens, database elements, and SQL separation elements are used for conversion the natural language query (NLQ) in SQL query.

 

REFERENCES

[1] Gupta, R Sangal. 2012. Novel Approach to Aggregation Processing in Natural Language Interfaces to Databases. Language Technologies Research Centre International Institute of Information Technology, Hyderabad, India
[2] Javubar SK, Jay A. 2015. Natural language to SQL generation for semantic knowledge extraction in social web sources. Indian Journal of Science and Technology, 8(1): 1-10
[3] Johnson T. 1985. Natural Language Computing: The Commercial Applications. Ovum Limited, London, UK Mckay DP, Finin TW. 1990. The intelligent database interface: Integrating AI and database systems. Proceedings of the 1990 National Conference on Artificial Intelligence. 677-684
[4] Mohite A, Bhojane V. 2014. Challenges and implementation steps of natural language interface for information extraction from the database. International Journal of Recent Technology and Engineering, 3(1): 108
[5] Nihalani N, Motwani M, Silakari S. 2011. An intelligent interface for relational databases. International Journal of Simulation: Systems, Science and Technology, 11(1): 29
[6] Poole D, Mackworth A. 2010. Artificial Intelligence-Foundations of Computational Agents. http://artint.info/index.html
[7] Rao G, Agarwal C, Chaudhry S, et al. 2010. NATURAL LANGUAGE QUERY PROCESSING USING SEMANTIC GRAMMAR. International Journal on Computer Science and Engineering, 2(2): 219-223
Rukshan A, Rukshan P, Mahesan S. 2013. Natural Language Web Interface for Database (NLWIDB). Proceedings of the Third International Symposium. SEUSL, Oluvil, Sri Lanka
[8] Sontakke AR, Pimpalkar A. 2014. A rule-based graphical user interfaces to a relational database using NLP. International Journal of Scientific Engineering and Research, 3(4): 81-84
[9] Sreenivasulu M. 2014. Information retrieval using natural language interfaces. International Journal of Computer Applications, 92(12): 34-37
[10] Wan FJ. 2000. A fuzzy grammar and possibility theory-based natural language user interface for spatial queries. Fuzzy Sets and Systems, 113: 147-159
[11] I. Androutsopoulos, “Interfacing a Natural Language Front-End to a Relational Database(MSc thesis),” Technical paper 11, Department of Artificial Intelligence, University of Edinburgh, 1993.
[12] Ana-Maria Popescu, Alex Armanasu, Oren Etzioni, David Ko, and Alexander Yates, “Modern Natural Language Interfaces toDatabases Composing Statistical Parsing with Semantic Tractability,” COLING 2004.
[13] Y. Li, H. Yang, and H.V. Jagadish, "NALIX: an interactive natural language interface for querying XML," in Proceedings of the International Conference on Management of Data, pp. 900–902, 2005.
[14] I. Androutsopoulos, G.D. Ritchie, and P. Thanisch, ”Natural Language Interfaces to Databases – An Introduction,” j. Lang, pp. 29-81, Eng.1995.
[15] E.W. Hinrichs. Tense, “Quantifiers, and Contexts. Computational Linguistics,” 14(2), pp.3–14, June 1988.
[16] P. Reis, J. Matias, and N. Mamede, "Edit – A Natural Language Interface to Databases: A New Dimension for an Old Approach, in Proceedings of the Fourth International Conference on Information and Communication Technology in Tourism (ENTER' 97), Edinburgh, 1997.
[17] Jurgen Albert, Dora Giammarresi, and Derick Wood, " Normal form algorithms for extended context-free grammars," in Theoretical Computer Science 267, pp. 35–47, 2001.
[18] I. Androutsopoulos, G. Ritchie, and P. Thanisch, "Natural language interfaces to the databases-an introduction," in Journal of Language Engineering, v. 1(1), pp. 29–81, 1995.
[19] Manning C. and Schütze H., “ Foundations of Statistical Natural Language Processing,” MIT Press, Cambridge, 1999.
[20] Luis Tari, Phan Huy Tu, Jorg Hakenberg, Yi Chen, Tran Cao Son, Graciela Gonzalez, and Chitta Baral, " Parse Tree Database for Information Extraction," in IEEE transactions on knowledge & data engineering, 2010.