基于微软数据仓库的农业科技支撑数据应用分析与展望  

Application and Prospect on Agricultural Science and Technology Support Data Based on Microsoft Data Warehouse

作　　者：吴定峰[1] 王丽云 刘婷婷[1] 樊景超[1] Wu Dingfeng;Wang Liyun;Liu Tingting;Fan Jingchao(Agricultural Information Institute,Chinese Academy of Agricultural Sciences,Beijing 100081)

机构地区：[1]中国农业科学院农业信息研究所

出　　处：《农业展望》2019年第12期101-105,共5页Agricultural Outlook

摘　　要：农业科技支撑数据资源是国家农业科技发展的数据基础,是重要的战略资源。目前,中国农业科技支撑数据零散存储,缺乏有效管理,无法进行有效的数据交叉分析,影响数据分析和利用效率。对此,基于Microsoft SQL Server数据仓库架构及其相关软件体系,分析梳理了利用Microsoft数据仓库建立农业科技支撑数据信息平台的关键应用技术,设计并实现农业科技支撑数据展现平台,解决了因科技支撑数据分散、数据量巨大、数据关系复杂以及范围广等问题导致的分析效率低、无法交叉分析及数据不统一的问题。设计实现的信息平台能从多方面直观、简洁地系统展现农业科技支撑数据,为决策人员综合分析支撑数据做出决策提供了便利。最后,对基于微软数据仓库技术的数据信息平台的发展和作用进行了展望。Agricultural science and technology support data resources is the data foundation of China’s agricultural science and technology development, and is also an important strategic resource. At present,agricultural science and technology support data is lack of effective management with scattered storage, and is unable to perform effective data cross analysis. It affects the efficiency of data analysis and utilization. Based on the introduction of Microsoft SQL Server data warehouse service and related software architecture, in order to solve the problems of slow analysis queries caused by the great amount of the original data, complex classification and wide scope, the key application technologies of building agricultural science and technology support data information platform were analyzed by using Microsoft data warehouse, an agricultural science and technology support data display platform was designed and realized. In proposed system, agricultural science and technology support data were showed clearly and intuitively. At the end of this article, future prospects of the display system development and function based on Microsoft data warehouse technology were put forward.

关 键 词：农业科技支撑数据 Microsoft数据仓库 维度建模 信息平台 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论] F323.3[自动化与计算机技术—计算机科学与技术]