Design and Application of Enterprise Data Warehouse Based on SQL Server 2000
Yuan Zhong · 2003
To make up the shortage of current database in information distilling, we need to integrate mass data in data 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 data warehouse 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