Export (0) Print
Expand All

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft