Position: Home > Articles > The Design and Implementation of Data Warehouse in Management System for Agricultural Science and Technology Achievements Transformation Fund Projects
Journal of Agricultural Science and Technology
2010,12
(4)
133-137
农业科技成果转化资金项目管理系统数据仓库的设计与实现
作 者：
谭华;孙桂川;曹存根
单 位：
中国科学院计算技术研究所;科技部中国农村技术开发中心
关键词：
农转;数据仓库;多维数据模型;ETL;OLAP
摘 要：
针对科技部组织实施的农业科技成果转化基金的历史数据分析,设计了支持农业转化项目管理决策的数据仓库。给出了项目管理的数据仓库的体系结构;制定了针对项目管理数据的抽取规则,并使用ETL工具,将数据抽取、转换、加载到数据仓库中,对该设计进行了工程实现;利用展现工具对该数据仓库的OLAP功能进行了检验;利用数据挖掘算法对相关数据进行预测分析,为农业转化项目经费的管理决策提供科学依据。
译 名：
The Design and Implementation of Data Warehouse in Management System for Agricultural Science and Technology Achievements Transformation Fund Projects
作 者：
TAN Hua1,SUN Gui-chuan2,CAO Cun-gen2(1.China Rural Tehcnology Development Center,Ministry of Science and Technology,Beijing 100045;2.Institute of Computing Technology,Chinese Academy of Sciences,Beijing 100190,China)
关键词：
agricultural scientific and technical achievement transformation;data warehouse;multidimensional data model;ETL;OLAP
摘 要：
Based on the analysis of historical data of agricultural science and technology achievements transformation fund projects implemented by the Ministry of Science and Technology(MOST),a data warehouse was designed to support the management and decision-making of agricultral S&T achievement transformation fund projects.This paper described the data warehouse architecture,developed data extraction rules for project management,then extracted,transferred,loaded the data into the data warehouse by ETL tools,completed the project implementation,tested OLAP functions by demonstration tools,and finally predicted the data using data mining algorithms,providing scientific basis for management decisions for agricultural S&T achievement transformation projects.
导出引用
计量
文章访问数: 6
HTML全文浏览量: 0
PDF下载量: 0
所属期刊
