农业科技成果转化资金项目管理系统数据仓库的设计与实现

doi:10.3969/j.issn.1008-0864.2010.04.24

›› 2010, Vol. 12 ›› Issue (4): 133-137.DOI: 10.3969/j.issn.1008-0864.2010.04.24

• 研究报告 • 上一篇

农业科技成果转化资金项目管理系统数据仓库的设计与实现

谭华1,孙桂川2,曹存根2

(1.科技部中国农村技术开发中心, 北京 100045|2.中国科学院计算技术研究所, 北京 100190)

收稿日期:2010-06-04 修回日期:2010-07-23 出版日期:2010-08-15 发布日期:2010-08-13
作者简介:谭华,高级工程师,从事农村信息化和科技项目管理及研究工作。Tel:010-51503675|E-mail:tanhua@crtdc.org.cn
基金资助:
软课题计划项目(国科农技字\[2007\]27号);软科学计划项目(2005DGS3B051);星火计划项目(2005EA106003)资助。

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)

Received:2010-06-04 Revised:2010-07-23 Online:2010-08-15 Published:2010-08-13

摘要/Abstract

摘要：

针对科技部组织实施的农业科技成果转化基金的历史数据分析,设计了支持农业转化项目管理决策的数据仓库。给出了项目管理的数据仓库的体系结构；制定了针对项目管理数据的抽取规则,并使用ETL工具,将数据抽取、转换、加载到数据仓库中,对该设计进行了工程实现；利用展现工具对该数据仓库的OLAP功能进行了检验；利用数据挖掘算法对相关数据进行预测分析,为农业转化项目经费的管理决策提供科学依据。

关键词: 农转;数据仓库;多维数据模型, ETL, OLAP

Abstract:

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.

Key words: agricultural scientific and technical achievement transformation, data warehouse, multidimensional data model, ETL, OLAP

中图分类号:

TP311.13

谭华1,孙桂川2,曹存根2. 农业科技成果转化资金项目管理系统数据仓库的设计与实现[J]. , 2010, 12(4): 133-137.

TAN Hua1, SUN Gui-chuan2, CAO Cun-gen2. The Design and Implementation of Data Warehouse in Management System for Agricultural Science and Technology Achievements Transformation Fund Projects[J]. , 2010, 12(4): 133-137.

农业科技成果转化资金项目管理系统数据仓库的设计与实现

The Design and Implementation of Data Warehouse in Management System for Agricultural Science and Technology Achievements Transformation Fund Projects

PDF

可视化

被引次数

摘要/Abstract

引用本文

使用本文

参考文献

相关文章 0

编辑推荐

Metrics