Makerere University Research Repository >
Faculty of Computing and Information Technology >
Theses & Dissertations (CIT) >
Please use this identifier to cite or link to this item:
|Title: ||Data warehousing in fisheries: A case study of the National Fisheries Resources Research Institute (FIRRI)|
|Authors: ||Onyango, Gerald|
|Keywords: ||Data warehousing|
Fisheries Resources Research Institute (FIRRI)
|Issue Date: ||18-Nov-2009 |
|Abstract: ||Information on the status and trends in fisheries is key to sustainable exploitation and management of fisheries resources. In Uganda, the organisation charged with research and dissemination of fisheries information is The National Fisheries Resources Research Institute (FIRRI). FIRRI packages this information in brochures, posters, videos, and press releases. However, preparation of this information, within FIRRI, is an uphill task because most of this information is scattered in files and other storage media scattered among the Institute’s different research disciplines. This called for a system that can centralise the storage and dissemination of the information generated within FIRRI. A DataWarehousing system was the system of choice to remedy the situation.
Work on the development of the Data Warehousing System commenced with the development of a Data Mart for one of the research disciplines. A Data mart for the Fish Biology and Ecology discipline was designed and developed using Microsoft SQL Server 2005. SQL Server Integration Services
(SSIS) was used to develop the Extract, Transform, and Load (ETL) tools, while SQL Server Analysis Services (SSAS) was used to develop the dimensional data cubes. Microsoft Excel, fitted with Cube Analysis add-in, was chosen as the enduser interface. Validation of the system proved it to be functioning as required. The results of the study show that it is possible to centralise information storage and retrieval in fisheries using a data warehouse. It provides evidence that centralised data storage, information retrieval, and reporting in FIRRI is both possible and attainable.
Shortage of time could not allow for the development of a fully fledged DataWarehouse, complete with a web interface. Since it was only possible to build a data mart for one of the disciplines within FIRRI, it is proposed that future work comprise of the development of an Enterprise wide DataWarehouse that can even be accesses through the WorldWide Web / Internet.|
|Description: ||A Project Report submitted to School of Graduate Studies in partial fulfillment of the requirements for the award of the Degree of Master of Science in Computer Science of Makerere University.|
|Appears in Collections:||Theses & Dissertations (CIT)|
Files in This Item:
All items in DSpace are protected by copyright, with all rights reserved.