基于OLAP技术的数据仓库的设计研究  

Design and Research of Data Warehouse Based on OLAP Technology

作　　者：郭群[1] GUO Qun(Liaoning University of International Business and Economics Dalian 116052)

机构地区：[1]辽宁对外经贸学院信息管理系,大连116052

出　　处：《办公自动化》2018年第20期41-43,共3页Office Informatization

摘　　要：数据仓库作为一种新技术,越来越受到企业的重视。在构建数据仓库的基础上,利用ETL数据抽取工具,从各种业务系统中提取数据,然后将数据集成到数据仓库中。并从联机分析处理技术(OLAP)特点出发对设计建立数据仓库的三种体系架构模式进行了分析比较。对于实现数据多维性分析,对于企业有一定的应用价值。As an emerging technology,data warehouse has been paid more and more attention by more and more enterprises. On the basis of data warehouse construction,ETL data extraction tool is used to extract data from various business systems,and then it is integrated and loaded into data warehouse.Based on the characteristics of OLAP,this paper analyzes and compares the three architectural patterns of data warehouse. It has certain application value for realizing data multidimensional analysis.

关 键 词：数据仓库 联机分析处理 数据分析 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]