数据仓库技术及SQLServer的数据仓库实现

DATA Warehouse and its Implementation

数据仓库技术是近几年来出现并迅速发展的一种技术,它可以充分利用数据仓库中已存储的信息,帮助决策者进行决策。本文主要探讨了构成数据仓库的各种因素,并设计了一个面向销售的数据仓库,使读者可以清楚了解数据仓库的建立过程,以及MicrosoftSQLServer(tm)7.0工具的简单应用。最后,是作者对数据仓库及MicrosoftSQLServer(tm)7.0工具的总结。

The technology of Data Warehouse is developed in the recent years This echnology can make full use of the data that store in the Data Warehouse and help the decision-maker in decision-making.This paper focuses mainly on the factor that construct Data Warehouse.Then,the paper provides an example of Data Warehouse relating to a Selling System,which will explain the construction approach of a Data Warehouse and the simple application ofthe tools ofMicrosoft SQL Server7.0to the readers.In the last part ofthis paper,the author summarize s the experience ofusing the tools ofData Warehouse and the Microsoft SQL Server7.0.