DESIGN OF AN INTEGRATED AGRARIAN DATA DIMENSIONAL DATA WAREHOUSE

Abstract

The concept of the Data warehouse was developed to provide a single access point to data from a variety of sources. There isa need to have a single location for the storage and sharing of data that users can easily utilize to make effective and qualitybusiness decisions, rather than trying to traverse the multiple data sources that exist today. Although many frameworks havebeen developed to integrate these sources into a single database, a reliable framework has yet to be developed. A majorhindrance to achieving a reliable warehouse is the poor quality of data obtained from the data transformation stage in theextract, transfer and load process. This poor quality of data contributes to inaccurate and unreliable results and if this data isused for decision making, unforeseen critical business errors can occur. This work reviews the data integration andtransformation process in dimensional data warehouses and proposes a dual structure for data integration and metadata ofmulti-formatted data used for the design of dimensional data warehouse using Agrarian data collected from Ondo State,Nigeria as a case study.Keywords: Data Warehouse, Data Integration, Metadata, Agrarian data.