摘要
数据仓库技术是近几年来出现并迅速发展的一种技术,它可以充分利用数据仓库中已存储的信息,帮助决策者进行决策。本文在介绍数据仓库的定义和数据仓库决策支持系统原理的基础上,详尽地讨论了数据仓库中的数据抽取与转换方法,并对数据仓库实现过程进行了实例探索和在线分析,最后根据数据挖掘方法进行了实际的应用。本文就是采用微软SQL Server 2000数据仓库技术设计了一商业用的数据仓库,使读者可清楚了解数据仓库的决策支持系统的实现过程。
The technology of Data Warehouse(DW)is developed in the recent years which can make full use of the datathat store in DW and help the decision-maker in decision-making.On the basis of introduction of DW and the decision-making support system,the methods of data extraction and transformation in DW have been discussed carefully,and the in-stance exploration and online analysis processing of DW have been carried out too.In addition,the method of data miningand its application is introduced.This paper designs a practically commercial DW adopting Microsoft SQL Server 2000 inorder for readers to understand the realization of the decision-making support system well.
出处
《计算机与应用化学》
CAS
CSCD
北大核心
2004年第2期293-298,共6页
Computers and Applied Chemistry
关键词
数据仓库
数据抽取
数据转换
在线分析
数据挖掘
data warehouse(DW)
data extraction and transformation
on-line analysis processing
data mining(DM)
