Application of data warehouse technology in crop planting
Liu Ya-tao · Hebei Journal of Industrial Science and Technology · 2007
In order to make full use of the data about crop growing,climate,soil,and field work,etc,discover the rules and characteristics in crop growing and breeding,and guide agricultural producing and scientific research,this paper discusses how to implement the crop planting data warehouse.The tools to realize date extraction,transformation and load are presented.Data modeling,management of the metadata,data increment addition,online analytical processing and result outputting are also introduced.By building the soy planting data warehouse through the use of the crop planting data warehouse,the soy breeding and planting research were greatly promoted.This paper is a helpful exploration of the application of data warehouse technology in crop planting.