Description
Kishor asked: DATA WAREHOUSE AND ITS APPLICATIONS IN AGRICULTURE K.P.Wagh Dr. Satish R. Kolhe Assistant Professor Reader Gf’s GCOE Jalgaon NMU Jalgaon Kishorwagh2000@yahoo.com srkolhe2000@gmail.com A Data warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated. This makes it much easier and more efficient to run queries over data that originally came from different sources. In other words Data warehouse is a database that is used to hold data for reporting and analysis. Economic foundation and productivity growth depends on agricultural sectors. Agriculture is the driving force behind the way of live and source of earnings for the majority of peoples. More than 60 percents of population are living in rural areas and the majority are farmers. The rural communities as a main producer for country food productivity and food security earn only 11 percents of Gross Domestic Product (GDP). The arrival of information age guides this country to new development strategies. National Electronics and Computer Technology Center (NECTEC) in collaboration with the Ministry of Agriculture, has launched “Agriculture Information Network” as a response to the unmet information requirements of the agricultural sector. Farmers should gain benefit from the contents provided which include risk assessment, agriculture warning system and agricultural knowledge base, which aim to improve technology, productivity, income and stability of India agriculture sector through the age of Information Technology. The data warehouse consists of common databases and geo-spatial databases from various departments and organizations in the country and abroad. Farmers can get access to the contents through Internet by themselves or from groups of professional people called “Information Brokers”. Keywords: Data Warehouse, Agriculture, IT 1. Introduction A Data warehouse [1] is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated. This makes it much easier and more efficient to run queries over data that originally came from different sources. In other words Data warehouse is a database that is used to hold data for reporting and analysis. Goals of Data Warehousing To facilitate reporting as well as analysis Maintain an organizations historical information Be an adaptive and resilient source of information Be the foundation for decision making Data Warehouse Architecture Data warehouse Architecture comprises of Operational source systems A data staging area One or more conformed data marts A data warehouse database Operational Source Systems Operational source systems [1] are developed to capture and process original business transactions. These systems are designed for data entry, not for reporting, but it is from here the data in data warehouse gets populated. Data Staging Area Data staging area is where the raw operational data is extracted, cleaned, transformed and combined so that it can be reported on and queried by users.