A Design Of A Data Warehouse And Use Of Data Mining Techniques For Analysis Of Risk Factors Affecting Agriculture In India

We published a paper titled "A Design Of A Data Warehouse And Use Of Data Mining Techniques For Analysis Of Risk Factors Affecting Agriculture In India" in the IOSR Journal of Agricultural and Veterinary Sciences.

Here is the link to the published paper: A Design Of A Data Warehouse And Use Of Data Mining Techniques For Analysis Of Risk Factors Affecting Agriculture In India

The Journal issue can be found here: IOSR Journal of Agricultural and Veterinary Sciences Volume 8 Issue 10

Abstract: In this paper, data made available in public domain by the Government of India, under the Open Government Data Initiative is analysed using data warehouse design and data analysis techniques. A data model is developed to analyse risks in agriculture. Regression analysis and K-Means Clustering are used as analysis techniques to derive insights from the available data and identify potential risk factors.

The datasets used in this paper can be accessed here:

SOURCE DATASETS DOWNLOADED FROM DATA.GOV.IN    DOI: 10.13140/RG.2.1.1557.2566

SCHEMA TABLE DATASETS GENERATED BY TRANSFORMING THE INPUT DATA:  DOI: 10.13140/RG.2.1.3654.4087

SELECTED PIVOT CHARTS USED FOR FINAL ANALYSIS: DOI: 10.13140/RG.2.1.4178.6966

Differential Snap-Shot Algorithms For Data Extraction From Data Sources And Updating A Centralized Data Warehouse

 A paper with the above title was published in the IOSR Journal of Engineering in their October 2015 issue.

Abstract: An in-depth review of existing techniques for loading a data warehouse using differential snapshot algorithms is presented. Further, certain performance bottlenecks have been identified and improvements to the existing state of the art are suggested.

The full paper can be downloaded here: IOSR Journal Of Engineering

The journal issue can be accessed here: IOSR Journal Of Engineering