| 数据仓库实现过程及在线分析 |
| |
| 引用本文： | 郭和伟,孙德宝,韩锋,秦元庆,皮鲲.数据仓库实现过程及在线分析[J].计算机与应用化学,2004,21(2):293-298. |
| |
| 作者姓名： | 郭和伟 孙德宝 韩锋 秦元庆 皮鲲 |
| |
| 作者单位： | 1. 孝感职业技术学院,湖北,孝感,432100
2. 华中科技大学控制科学与工程系,湖北,武汉,430074 |
| |
| 摘 要： | 数据仓库技术是近几年来出现并迅速发展的一种技术，它可以充分利用数据仓库中已存储的信息，帮助决策者进行决策。本文在介绍数据仓库的定义和数据仓库决策支持系统原理的基础上，详尽地讨论了数据仓库中的数据抽取与转换方法，并对数据仓库实现过程进行了实例探索和在线分析，最后根据数据挖掘方法进行了实际的应用。本文就是采用微软SQL Server 2000数据仓库技术设计了一商业用的数据仓库，使读者可清楚了解数据仓库的决策支持系统的实现过程。
|
| 关 键 词： | 数据仓库 数据抽取 数据转换 在线分析 数据挖掘 |
| 文章编号： | 1001-4160(2004)02-293-298 |
Realization process and on-line analysis processing of the data warehouse |
| |
| GUO HeWei SUN DeBao HAN Feng QIN YuanQing and PI Kun.Realization process and on-line analysis processing of the data warehouse[J].Computers and Applied Chemistry,2004,21(2):293-298. |
| |
| Authors: | GUO HeWei SUN DeBao HAN Feng QIN YuanQing and PI Kun |
| |
| Affiliation: | GUO HeWei~1 SUN DeBao~2 HAN Feng~2 QIN YuanQing~2 and PI Kun~2 |
| |
| Abstract: | 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. |
| |
| Keywords: | data warehouse(DW) data extraction and transformation on-line analysis processing data mining(DM) |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
