基于Analysis Services的小城镇先进适用技术OLAP系统的实现  

Implement of the Little Town with Advanced Technology and Products Based on the Analysis Services

作　　者：宋晓宇[1] 张宇[1] 孙焕良[1] 

机构地区：[1]沈阳建筑大学信息与控制工程学院,沈阳110168

出　　处：《计算机与数字工程》2007年第5期149-152,共4页Computer & Digital Engineering

基　　金：国家十五科技攻关计划专题(编号:2003BA808A21-6)资助

摘　　要：介绍数据仓库和OLAP技术的基本概念和功能,并给出一个基于Analysis Services的小城镇先进适用技术OLAP系统的实现方案。该系统通过OLAP多维模型的上卷下钻功能,为用户提供先进适用技术与产品信息的查询,为管理者提供对信息的分析和统计。通过本系统,可以更好的将先进适用技术与产品的信息从不同层次提供给用户,并将统计分析的结果展示给管理者,为其提供决策支持,有效地促进小城镇先进适用技术与产品的推广。This paper presents an overview of data warehouse and OLAP technology, discusses the implementation of a little town use OLAP system which based on Microsoft SQL Server 2000 analysis services. In this system, OLAP operation such as 'roll up' and 'drill down', can be executed effectively, so that the information of advanced technology and product of the little town can be queried from multiple sides and levels, and this system can provide support for manager’s decision-making .It is make effectively promotion and popularization of the advanced techniques and products.

关 键 词：OLAP 多维数据集 MDX 数据仓库 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]