气象通信数据多维模型构建及OLAP应用初探  

Development and Application of Multi-Dimensional Model in Meteorological Telecommunication System and OLAP

作　　者：薛蕾[1] 姚燕[1] 巢丽娟[1] 

机构地区：[1]国家气象信息中心,北京100081

出　　处：《气象科技》2013年第4期644-647,共4页Meteorological Science and Technology

摘　　要：气象通信系统是国内和国际气象资料传输与交换的枢纽。为了从宏观上掌握气象通信系统资料的传输情况,有效管理数据、优化和梳理业务流程,根据通信系统数据量大、流程复杂、数据异构等特点,文章基于数据仓库技术构建气象通信数据的多维模型,为长时间序列的通信数据存储和分析提供解决方案。利用SQL Server Analy-sis Service,采用实时业务系统的真实数据展开多维数据模型构建的试验,在此基础上对多维模型进行了联机分析处理(OLAP),验证了多维模型在数据分析和展现方面的优势。The meteorological telecommunication system is the hub of transmitting national and international data, in order to grasp the situation of data transmission in the meteorological telecommunication system, manage the data effectively, optimize and combine the operational service processes, according to the characteristics of the data, a multi-dimensional model is constructed with the data of the telecommunication system, and a solution to long-time series data is proposed, which uses the SQL Server Analysis Service to launch a pilot run with the data in the real operational environment, and implement the OLAP application, and verify the advantages of the multi-dimensional model in data analysis and display.

关 键 词：数据仓库 OLAP 多维数据模型 

分 类 号：P409[天文地球—大气科学及气象学]