Modelling and Designing of NLP Interface to Database for Afaan Oromoo
Journal Title: International Journal of Innovative Research in Computer Science and Technology - Year 2021, Vol 9, Issue 2
Abstract
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.
Authors and Affiliations
Shumet Walelign, Debela Tesfaye, Teferi Kebebew
Keywords
Related Articles
- EP ID EP747532
- DOI 10.21276/ijircst.2021.9.2.2
- Views 1
- Downloads 0
Convolutional Neural Network-based Object Detection
In the midst of the efforts in an item identification, region CNNs (rCNN) stands out as the most impressive, combining discriminatory exploration, CNNs, sustenance vector machines (SVM), and bounding box regression to ac...
A Review on Time Travel: Fact or Fiction
This article focuses on Einstein's theory of relativity and Minkowski space-time, which combines three dimensions of space and a fourth dimension of time. It contrasts and examines the evolution of time travel in science...
A Review Paper on Wireless Sensor Network
Security is one of the most essential things to consider if sensor networks are to reach their full potential. Even more innocuous applications, such as home health monitoring, habitat monitoring, and subsurface research...
Study on Soil Stabilization Using Rice Husk Ash and Cement In Marshy Soils
The current study was conducted on marshy soils found at Rakh Arth Bemina in Srinagar, J&K,India with the goal of quantifying the effect of rice husk ash and cement on the soil's dry density, optimum moisture content an...
GIS Approach to Determine Suitability of Trees for Afforestation
9.4 million trees across forest areas in India have been lost to development projects over the period of past 4 years (2015-16 to 2018-19). This is according to the Union ministry of environment, forests and climate chan...