MULTIDIMENSIONAL SCHEMA FOR AGRICULTURAL DATA WAREHOUSE

Aditya Kumar Gupta, Bireshwar Dass Mazumdar

Abstract: Agriculture is one of the important issues for a nation’s economy and it required technical breakthroughs in this century. With today’s computerized world, the agricultural data processing is an increasing need for formers and decision makers. Agricultural data is diversified, complex and non-standard. Developing a data warehouse for agricultural is a key challenge for researchers. The objective of this work is to design a data warehouse about crops and their requirements. The proposed data warehouse may be extended to Decision Support System (DSS) combine with data mining techniques. We proposed a multidimensional data warehouse for agriculture that provides solutions for farmers and gives response of their ad-hoc quires. This multidimensional schema further promotes star schema and snowflake schema that are commonly used to design data warehouses. In our manuscript normalization is applied to store the data in to star schema and duplicate values are removed, so that space and time complexities could be minimized

Keywords: Agriculture, Data Warehouse, Multidimensional Schema, Dimensional Modeling, OLAP

DOI: https://doi.org/10.15623/ijret.2013.0203006