SQL Server 2005 OLAP技术研究与实现

Research and Realization of OLAP Technology on SQL Server 2005

简要介绍了OLAP的概念和特点;从OLAP最新概念和技术等方面,解释了微软SQL Server 2005中统一维度模型;研究了微软现代OLAP搭建方法与传统搭建方法的差异;通过基于企业销售数据多维数据集的OLAP实例,说明了微软最新OLAP的设计概念的可行性,有助于企业方便快捷地建立自已的分析决策支持平台。

The OLAP concept and features is reviewed briefly. The unified dimensional model in SQL Server 2005 is explained. The difference between Microsoft new OLAP and traditional OLAP structural design is studied. By a OLAP practical example based on the enterprise sales data cube, to show the feasibility of design with Microsoft new OLAP concept, and helpful to promptly build a platform of enterprise decision support with it.