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 87
- Downloads 0
Security in Smart Home Development: A Review
A clever home or structure is a modern house or construction with special organized wiring that enables residents to control or program a variety of automatic household electrical devices remotely with a single order. Tr...
Design, Construction and Performance of Porous and Rubbrised Asphalt Pavement
Moreover, porous asphalts have volumetric and surface characteristics (e.g., acoustic absorption, drain ability, texture, and friction). These characteristics are influenced by both intrinsic (such as gradation and bitum...
An Overview of Device-To-Device Communication in Cellular Networks
Gadget to-Device (D2D) correspondence was first recommended as another worldview for further developing organization execution in cell organizations. New use-cases for D2D correspondences in cell networks have arisen bec...
Competition Between Saturated and Unsaturated Components for Reacting with Emerging 1:1 Adduct Radical as Cause for Peaking Dependence of 1:1 Adduct Formation Rate on Unsaturated Component Concentration in Free-Radical Nonbranched-Chain Processes of Initiated Addition to Molecular C=C, C=O Bonds, and Oxygen in Binary Systems
The kinetics of free-radical nonbranched-chain processes of addition to unsaturated compounds (such as alkenes, formaldehyde, dioxygen) was investigated. The aim of this study was the conclusion of simple kinetic equatio...
An Analysis of Convolutional Neural Networks
Convolutional neural networks (CNNs), form of artificial neural network (ANN) prominent in computer vision, are finding traction in diversity of sectors, comprising radiology. CNN employs a variety of building pieces, in...