Study Of Data Warehouse On Agriculture Science And Technology Achievement Transformation Funds

Agricultural science and technology achievements into capital projects in 2001 used C / S version of the software, and used the network management system that integrated reporting, acceptance, trial, supervision, inspection as one in 2006, so that agricultural science and technology achievements into capital projects fully implemented digital management. The information system has accumulated a large number of project-related data. However, the existing systems mainly used traditional database for the only transaction processing, and databases are difficult to combine, as a result systems can not provide analysis and decision making for allocation of agriculture science and technology achievement transformation funds. The emergence of data warehouse technology meets the needs of analysis and decision-making.This paper introduced the status of data warehouse, the theory knowledge of data warehouse and OLAP analysis processing. On the basis of understanding of existing systems, the system proposed the demand of data warehouse and design goals and principles. Through analysis of agriculture science and technology achievement transformation funds, this paper studied the entire process of building data warehouses. This paper detailedly analyzed the relation of business activities and data of agriculture science and technology achievement transformation funds, and designed concept model, logical model, physical model. On the basis of the model, system carried out data extraction, transformation, loading. Taking reporting project system data source for example, the project used the kettle tool for data conversion. System recombined historical data by topic and established data cube in the theme, analysised and inquiried through MDX language in cube. Finally, the paper implemented the system-specific ETL and OLAP design according to features of language agriculture science and technology achievement transformation funds data and corresponding Java language.Through the data warehouse technology and agriculture science and technology achievement funds project closely to achieve, implementing decisions and analysis of agriculture science and technology achievement transformation funds, supporting use and allocation of funds in the Ministry of Science and Technology to balance distribution of agriculture science and technology achievement in various fields, and generating maximum economic benefit and social benefit to lay the foundation in decision-making of digital.