基于SQL Server2000的企业数据仓库设计与应用

在激烈的市场竞争中,企业纷纷建立了自己的数据库系统,以此来收集、存储、管理业务操作数据,改善办公环境,提高操作人员的工作效率,同时,企业也希望从海量的数据中获得有价值的信息,以支持企业决策。但是,传统的数据库应用系统是面向业务的,无论是查询、统计,还是生成报表,其处理方式都只是对指定的数据进行简单的数字处理,这虽然减轻

Design and Application of Enterprise Data Warehouse Based on SQL Server 2000

To make up the shortage of current database in information distilling, we need to integrate mass data indata warehouse so that it can offer better reference to business manage and decision-making for enterprise. By using relational database SQL Server 2000 of Microsoft as resolution scheme of data warehouse, an enterprise datawarehouse with star schema is established. Data cubes are constructed and measures are calculated by Analysis Services tools in SQL Server ,and these cubes are online analyzed through OLAP, then user can easily get relationship of data or attributes which can provide reference to their business, and utilize data in existence fully and effectively.