Abstract

Information retrieval is very important area in any of the IT applications. Systematic data storage is essential in information retrieval. In conventional method, data is stored in a structured format and retrieved using SQL queries which requires technical knowledge. Most common data storing and retrieving mechanism in IT is the Relational Database Management Systems. Now there is a necessity to retrieve data from a very large database using natural language from any social media. A brief survey of various methods used to store and retrieve data using Natural Language Processing (NLP) is carried out in this paper.

References

• Fei L, H. V. Jagadish, “Constructing an Interactive Natural Language Interface for Relational Databases”, Proceedings of the VLDB Endowment, Vol. 8, No. 1, 2014
• Garima Singh, Arun Solanki, “An algorithm to transform natural language into SQL queries for relational databases”, IAEES, 3(3), pp 100-116, 2016
• Subhabrata Sengupta, Prasun Kanti Ghosh, Saparja Dey “Automatic SQL Query Formation from Natural Language Query”, International Journal of Computer Applications (0975 – 8887), July 2014
• Prabhdeep Kaur, Shruthi J, “Conversion of Natural Language Query to Sql”, International Journal of Engineering Sciences & Emerging Technologies, Vol. 8, Issue 4, pp 208-212, January 2016.
• Axita Shah, Dr. Jyoti Pareek, Hemal Patel, Namrata Panchal, “NLKBIDB - Natural Language and Keyword Based Interface to Database”, International Conference on Advances in Computing, Communications and Informatics (ICACCI) IEEE, pp 1569-1576, 2013
• Filbert Reinaldha, Tricya E. Widagdo, S.T., M.Sc., “Natural Language Interfaces to Database (NLIDB): Question Handling and Unit Conversion”, IEEE, 2014
• Azilawati Azizan, Zainab Abu, Shahrul Azman Noah, “Query Reformulation Using Ontology and Keyword for Durian Web Search”, Third International Conference on Information Retrieval and Knowledge Management, pp 94-100, 2016
• Manavalan, Subrata Chattopadhyay, Mangala, Prahlada Rao, Sarat Chandra Babu, Akhil Kulkarni, “Experiments on Information Retrieval Mechanisms for Distributed Biodiversity Databases Environment”, IC3I, IEEE, pp 219–223, 2014
• Sanket S.Pawar, Abhijeet Manepatil, Aniket Kadam, Prajakta Jagtap, “Keyword Search in Information Retrieval and Relational Database System: Two Class View”, ICEEOT, pp 4534-4540, 2016
• Xuan Xuan, Liu Jianbo, Yang Jin, “Research on the natural language querying for remote sensing databases”, International Conference on Computer Science and Service System, pp 228-231, 2012
• Xu Yiqiu Wang Liwei Yan Shi, “The Study on Natural Language Interface of Relational Databases”, 2nd Conference on Environmental Science and Information Application Technology, pp 596-599, 2010
• Mahesh P.Gaikwad, Natural Language Interface to Database, International Journal of Engineering and Innovative Technology (IJEIT) Vol. 2, Issue 8, pp 153-155, February 2013
• Pooja A.Dhomne, Sheetal R.Gajbhiye, Tejaswini S.Warambhe, Vaishali B.Bhagat, “ACCESSING DATABASE USING NLP”, IJRET, Vol. 02, Issue 12, pp 589-594, December, 2013
• Avinash J. Agrawal, Dr. O. G. Kakde, “Semantic Analysis of Natural Language Queries Using Domain Ontology for Information Access from Database”, I.J. Intelligent Systems and Applications, Vol. 12, pp 81-90, 2013
• Rukshan Alexander, Prashanthi Rukshan,Sinnathamby Mahesan, “Natural Language Web Interface for Database (NLWIDB)”, Proceedings of the Third International Symposium, SEUSL: 6-7 July 2013
• Gaganpreet Kaur, “Usage Of Regular Expressions In NLP”, IJRET, Vol. 03 Issue. 01, pp 168-174, January 2014
• Akshay G. Satav, Archana B. Ausekar, Radhika M. Bihani, Mr Abid Shaikh,” A Proposed Natural Language Query Processing System”, International Journal of Science and Applied Information Technology, Volume 3, No.2, pp 37-39, April 2014
• K. Javubar Sathick, A. Jaya, “Natural language to SQL Generation for Semantic Knowledge Extraction in Social Web Sources”, Vol. 8(1), pp 01–10, January 2015
• Rongrong Zhang, Qingtian Zeng, Sen Feng, “Data Query Using Short Domain Question in Natural Language”, IEEE, pp 351-354, 2010
• Johanna Monti, Mario Monteleone, Maria Pia di Buono, Federica Marano, “Natural Language Processing and Big Data An Ontology-Based Approach for Cross-Lingual Information Retrieval”, IEEE, pp 725-731, 2013
• Mochamad Vicky Ghani Aziz, Ary Setijadi Prihatmanto, Diotra Henriyan, Rifki Wjay, “Design and Implementation of Natural Language Processing with Syntax and Semantic Analysis for Extract Traffic Conditions from Social Media Data”, IEEE 5th International Conference on System Engineering and Technology, pp 43-18, Aug. 10 - 11, 2015
• Belainine Billal, Alexsandro Fonseca and Fatiha Sadat,” Efficient Natural Language Pre-processing for Analyzing Large Data Sets”, IEEE International Conference on Big Data, pp 3864- 3871, 2016
• Abdeljalil EL ABDOULI, Larbi HASSOUNI, Houda ANOUN, Mining Tweets of Moroccan Users using the Framework Hadoop, NLP, K-means and Basemap”, IEEE, 2017
• Mohd Suhairi Md Suhaimin, Mohd Hanafi Ahmad Hijazi, Rayner Alfred and Frans Coenen, “Natural Language Processing Based Features for Sarcasm Detection: An Investigation Using Bilingual Social Media Texts”, ICIT, pp 703-709, 2017
• Li Xin, Xie Qianqian1, Huang Lucheng, Yuan Zhou, “Twitter Data Mining for the Social Awareness of Emerging Technologies”, Proceedings of PICMET '17, IEEE, 2017
• Kaixian Yu, Tingting Zhao, Peixiang Zhao, Jinfeng Zhang, “Extraction of protein-protein interactions using natural language processing based pattern matching” IEEE International Conference on Bioinformatics and Biomedicine, pp 1292- 1295, 2017
• Ranjeet Devarakonda (Senior Member, IEEE), Michael Giansiracusa, Jitendra Kumar, and Harold, “Social Media Based NPL System to Find and Retrieve ARM Data: Concept Paper”, IEEE International Conference on Big Data, pp 4736- 4737, 2017
• Donia Gamal, Marco Alfonse, El-syed M. El-Horbaty, Abdel-Badeeh M.Salem, “ A comparative study on Opinion Mining Algorithms of Social Media Statuses”, ICICIS, pp 385- 390, 2017
• Marie-Catherine de Marneffe and Christopher D. Manning, “Stanford typed dependencies manual” September 2008.
• Valentin Ilyich Spitkovsky, “Grammar Induction and Parsing with Dependency-And-Boundary Models”, December 2013
• http://www.nltk.org/book/ch10.html
• http://www.nltk.org/book/