Design and Application of Enterprise Data Warehouse Based on SQL Server 2000
基于SQL Server2000的企业数据仓库设计与应用

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.