A Novel IR for Relational Database using Optimize Query Building
DOI:
https://doi.org/10.32628/CSEIT195438Keywords:
Fuzzy, IR,NLP, PrecisionAbstract
The different type search engine like Google, binge, AltaVista is used to fetch the information from the database by easy language. The non-technical employee they don’t understand the database and query cannot access the database. The proposed system is performing work as a search engine where users can fetch the information from the database by natural human sounding language. The previous existing system doesn’t able to solve queries in one easy statement. The structured query approach, while expressive and powerful, is not easy for naive users. The keyword-based approach is very friendly to use, but cannot express complex query intent accurately. This paper emphasis on Natural Language based query processor. We have proposed the use of query optimization approach to convert complex NLP query to SQL query, SPAM word removal, POS tagger applied over NL query and concluded that execution time lesser when query size increases.
References
- Mathias Soeken, Christopher B. Harris, Nabila Abdessaied, Ian G. Harris, RolfDrechsler, Automating the Translation of Assertions Using Natural Language Processing Techniques FDL Proceedings | ECSI 2014.
- Ryuichiro Higashinaka1, Kenji Imamura1, Toyomi Meguro2, Chiaki Miyazaki Towards an open-domain conversational system fully based on natural language processing Proceedings of COLING 2014, the 25th International Conference on Computational Linguistics: Technical Papers, pages 928–939, Dublin, Ireland, August 23-29 2014.
- Anupriya, Prof. Rahul Rishi Fuzzy Querying Based on Relational Database OSR Journal of Computer Engineering (IOSR-JCE) e-ISSN: 2278-0661, p- ISSN: 2278-8727 Volume 16, Issue 1, Ver. I (Jan. 2014), PP 53-59.
- Antonio Lieto, Andrea Minieri1, Alberto Piana1 and Daniele P. Radicioni A Knowledge-Based System for Prototypical Reasoning ISSN: 0954-0091 print/ISSN 1360-0494 oct 2014.
- Lei Zou, Ruizhe Huang, Haixun Wang Natural Language Question Answering over RDF — A Graph Data Driven Approach SIGMOD’14, June 22–27, 2014.
- Andre Freitas, Edward Curry Natural Language Queries over Heterogeneous Linked Data Graphs: A Distributional- Compositional Semantics Approach ACM 978-1-4503-2184-6/14 Feb 2014.
- Fei Li, H. V. Jagadish NaLIR: An Interactive Natural Language Interface for Querying Relational Databases SIGMOD’14, June 22–27, 2014.
- Akshay G. Satav, Archana B. Ausekar, Radhika M. Bihani, Mr Abid Shaikh A Proposed Natural Language Query Processing System WARSE Volume 3, No.2, March - April 2014.
- Huangi,Guiang Zangi, Phillip C-Y Sheu “A Natural Language database Interface based on probabilistic context free grammar”, IEEE International workshop on Semantic Computing and Systems 2008..
- Higashinaka Ryuichiro, Imamura Kenji , Meguro Toyomi, Miyazaki Chiaki Kobayashi Nozomi , Sugiyama Hiroaki , Hirano Toru, Makino Toshiro ,Matsuo Yoshihiro Towards an open-domain conversational system fully based on natural language processing
Downloads
Published
Issue
Section
License
Copyright (c) IJSRCSEIT
This work is licensed under a Creative Commons Attribution 4.0 International License.