Possibility Of Amharic Query Processing In Database Using Natural Language Interface

Abstract

In The World, Information Plays An Important Role In Our Lives. One Of The Major Sources Ofinformation Is Database. Database And Database Technology Are Having Major Impact On The growing Use Of Computers. Almost All IT Applications Are Storing And Retrieving The Informationor Data To And From The Database. Database Management Systems (DBMS) Have Been Widelyused For Storing And Retrieving Data. However, Databases Are Often Hard To Use Since Theirinterface Is Quite Rigid With Users. For Storing And Retrieving The Information From Database Itrequires The Knowledge Of Database Language Like SQL. Structured Query Language (SQL) Is Anansi Standard For Accessing And Manipulating The Information Stored In Databases. Only Fewpeople Who Have Knowledge Of Database Structure And Formal Database Language (Such Asstructured Query Language (SQL) Can Retrieve The Desired Information From Databases. The Objective Of This Research Is To Explore The Development Of An Efficient And User Friendlyamharic Language Query Interface To Database (ALIDB) System That Allows Non-Technical Usersto Interact With Database Using Amharic Language. The Prototype System Can Handle The Following Types Of Queries: List Queries, Condition Queriesand Join Queries Is Developed. It Is Tested With 60 Amharic Query Sentences Which Are Collectedfrom 12 Users. The Accuracy Of The System Is Measured In Term Of Precision Percentage With Twoclasses That Identifies Query Response As: Correct And Incorrect. The Results Found Are encouraging And The Overall Efficiency Of System Is Observed To Be 63.3%.