Volume- 9
Issue- 2
Year- 2021
DOI: 10.21276/ijircst.2021.9.2.2 |
DOI URL: https://doi.org/10.21276/ijircst.2021.9.2.2
Crossref
This is an Open Access article distributed under the terms of the Creative Commons Attribution License (CC BY 4.0) (http://creativecommons.org/licenses/by/4.0)
Article Tools: Print the Abstract | Indexing metadata | How to cite item | Email this article | Post a Comment
Shumet Walelign , Debela Tesfaye, Teferi Kebebew
Database management system has been widely used for storing and retrieving data. However, database is often hard to access the data since their interface is rigid in cooperating with user, due to that analysis of natural language query interface to relational databases has gained much interest in research community. This can be termed as structured free query interface as it allows the users to retrieve the data from the database without knowing the underlying schema. Structured free query interface should address majorly two problems. Querying the system with natural language interfaces is comfortable for the naive users but it is difficult for the machine to understand. The other problem is that the users can query the system with different expressions to retrieve the same information. The different words used in the query can have same meaning and the same word can have multiple meanings. Hence; it is the responsibilities of the NLI to understand the exact meaning of the word in the particular context to handle such problem the researcher develops an algorithm that is from manually crafted rule that extracted from user queries for proper query translation and SQL query generation. The proposed, pattern matching approach to natural language interface to database system has been passes through various phases. The idea behind the approach is to overcome the problem bottleneck luck of tools in the language, while pattern-matching method can fill the gap of those resources. This makes our approach suitable for AONIDB since Afaan Oromoo is under resourced language. The exact meaning of the word used in the query in particular context obtained using domain-mapping dictionary and database-mapping table constructed form student database that contains grade, department and course table for mapping database information with the help of an algorithm developed by researcher based on the rule that extracted from collected user query. The system has been developed in which user can input query in Afaan Oromoo language and can see result in the same language. The proposed system can handle list query, single and multiple conditional queries, aggregate function queries and join queries. The proposed system evaluated on 100 Afaan Oromoo queries using student database with precision, recall and F-measure. The result of testing is very encouraging and an average performance of 94.2% that implies that the systems validity and reliability is very high, an indicator of its strong and successfully features use and operation. Yet; further experiments using different approaches that extend this work are needed for a better performance.
[1] Allen. pattern-based Language Understanding,” 2nd Ed, California Redwood, Benjamin /Cummings Publishing Company, Inc. 1996.
[2] Amanuel Alemayehu, “the Syntax of Interrogatives in Oromoo,” Ma Thesis, Addis Ababa University, Addis Ababa, 2006.
[3] Liddy E.D,” Natural Language Processing,” Encyclopedia of Library and Information Science, 2nd Ed. Ny. Marcel Decker, Inc 2001.
[4] A. Kaur, “Punjabi Language Interface to Database,” Thapar University, 2010.
[5] Ashish Kumar and Dr. Kunwar Singh Vaisla,” Natural Language Interface to Databases: Development Techniques,” Elixir Comp. Sci. & Engg. 58 (2013) 14724-14727, on 17 May 2014.
[6] Getachew Mamo, “Part-of-Speech Tagging for Afaan Oromoo Language,” Addis Ababa, Ethiopia January, 2009.
[7] Flickinger, D.(2015) Natural Language Engineering-Efficient Processing With Hpsg: Methods, Systems, Evaluation. At: Http://Www.Coli.Uni-Sb.De/Nlesi/ Accessed at 3/15/2015.
[8] Abhijeet R. Sontakke et al.,” A Rule Based Graphical User Interface to Relational Database Using NLP,” International Journal of Scientific Engineering and Research (Ijser), Issn (Online): 2347-3878, Impact Factor, 2014.
[9] B.Sujatha, et al, ”A Novel Architecture for the Natural Language Interface to Databases,” International Journal of Computer Architecture and Mobility (ISSN 2319-9229) Volume 1-Issue 6, April 2013.
[10] Oromoo Language. Http://En.Wikipedia.Org/Wiki/Oromoo_Language; Last Accessed on August 25, 20016.
[11] Kekeba Tune, Vasudeva Varma and Prasad Pingali, “Evaluation of Oromoo-English Cross-Language Information Retrieval,” Ijcai 2007 Workshop on Clia, Hyderabad, India, 2007.
[12] Oromoo Language: Encyclopedia Http://En.Allexperts.Com/E/O/Or/Oromoo_Language. Htm, Last Accessed on October 10, 2016.
[13] C.Griefenew Mewis, “A Grammatical Sketch of Written Oromoo,” Druckerei Franz Hansen, Bergisch Gladbach, Germany, 2001.
[14] Jadhav Sneha, Raut Shubhangi and A.S. Zore, “Natural Language to Database Interface”, International Journal of Advanced Research in Computer and Communication Engineering Vol. 3, Issue 2, India, February 2014.
[15] R. Kasper, “A Flexible Interface for Linking Applications to Penman’s Sentence Generator,” Darpa Speech and Natural Language Work- Shop, 1989.
[16] Hanane Bais et al. “A Model of A Generic Natural Language Interface for Querying Database,” I.J. Intelligent Systems and Applications, 2016.
[17] A. H. Madessa,“ Probabilistic Information Retrieval System for Amharic Language,” Addis Ababa University, 2012.
[18] A. R. Sontakke and P. A. Pimpalkar, “A Review Paper on Hindi Language Graphical User Interface to Relational Database Using Nlp,” Int. J. Adv. Res. Comput. Eng. Technol., Vol. 3, No. 10, Pp. 3393–3397, 2014.
[19] A. Kumar and K. S. Vaisla, “Natural Language Interface to Databases : Development Techniques,” Elixir Comp. Sci. Engg, No. November, 2015.
[20] I. Androutsopoulos, G. D. Ritchie, P. Thanisch, and M. Road,“ Natural Language Interfaces to Databases An Introduction,” No. 709, Pp. 1–50, 1995.
[21] Neelu. Nihalani, S. Silakari, and M. Motwani,“ Natural Language Interface for Database : A Brief Review,” Ijcsi Int. J. Comput. Sci. Issues, Vol. 8, No. 2, Pp. 600–608, 2011.
[22] Preeti Verma et al.,“ Punjabi Language Interface to Database”.
[23] Smegnew A ”Amharic Language Query Processing in Database Using Natural Language Interface,” M.Sc. Thesis, School of Computing, Jimma University, Jimma, Ethiopia, August, 2008.
[24] Fei Shao, Yanjiao Cao(2005) A New Real-Time Clustering Algorithm, Department of Computer Science
and Technology, Chongqing University of Technology Chongqing 400050, China. Linguistics: Linguistic Studies in Honor of Jan Svartvik, London, Longman.
[25] B. Sujatha et al.” A Generic Model for Natural Language Interface to Database,” IEEE 6th International Advanced Computing Conference, 978-1-4673-8286-1/16, 2016.
[26] Joseph Weisenbaum,“Eliza Computer Program for the Study of Natural Language Communication Between Man and Machine,” Communication of the Acm, Vol. 9. 1966.
[27] Jurafsky, D. Martin,“ Speech and Language Processing Pearson Education,” 2nd Edition, 2009.
[28] Workineh Tesema Gudisa,” Towards the Words Sense Disambiguation of Afaan Oromoo using Hybrid Approach,” Jimma University Institute of Technology (Jit), October 3, 2015.
Lecturer, Department of Information Technology, IoT Hachalu Hundesa Campus, Oromia, Ambo University, Ethiopia (shumetw549@gmail.com)
No. of Downloads: 63 | No. of Views: 2525
Anmol Chauhan, Sana Rabbani, Devendra Agarwal, Nikhat Akhtar, Yusuf Perwej.
July 2024 - Vol 12, Issue 4
Dr S. A. Talekar, Shravani A. Lajurkar, Divya S. Patil, Rutika A. Benke, Pranjal A. Kunde.
May 2024 - Vol 12, Issue 3
Dr. Deepika Rani.
May 2024 - Vol 12, Issue 3