Development of Amharic Locale Integrating System in Open Source Database
No Thumbnail Available
Date
2020-06-04
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
Addis Ababa University
Abstract
Nowadays, in many domains, managing data according to local convention is required to be taken into account. Due to this, most of the existing system environments include the models for internationalization to allow developer to easily develop software that support different locales. Even though, software’s include models of internationalization the localization work conducted on Amharic locale development has limitations which has a considerable impact on managing Amharic locale data in database as well as in other software system. There are attempts to support Amharic locale in database and other software by developing locale schema in XML however, these works are not including all the required features of Amharic locale. Calendar and collation sequence are examples of Amharic locales which are not managed in the current database software environment. For supporting Amharic locale in a database system we developed an extension to meet needs of Amharic locales. In this report, we present our work that extends the PostgreSQL database system to manage Amharic locale data. We introduce new data types along with a set of functions to support Amharic locale data in PostgreSQL database. Finally, for integrating the extension into PostgreSQL database we developed source code in C programing language, control and SQL script file which contain real implementation of the locale, information about the extension and map all the new data type, functions and operators to SQL command respectively. Testing of the extended system produced the expected result.
Description
Keywords
Database Management System, Database Extension, Amharic Locale, Locale in Postgresql