Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Parts of a Data Warehouse

Parts of a Data Warehouse

SQL Server 2000

There are several physical and functional elements that make up a data warehouse. The topics in this section discuss these elements.

Topic Description
Data Marts Describes data marts, which contain portions of data warehouse data for specialized purposes.
Relational Databases Describes the roles and uses of relational databases in data warehouses.
Data Sources Describes various sources of organizational data typically used in data warehouses.
Data Preparation Area Describes the area where data extracted from data sources is prepared for use in a data warehouse.
Presentation Services Describes the services that organize and analyze data warehouse information and make it available to client applications.
End-User Analysis Describes the use of client applications to access and analyze information in a data warehouse.

© 2015 Microsoft