Components of a Data-Warehouse

1. COMPONENTS OF A DATA-WAREHOUSE:
The primary components of a data-warehouse are
1. Source data component
 Production data
 internal data
 Archived data
 External data

2. Data staging component
 Extraction of data
 Transformation of data
 Synonyms
 Homonyms
 Loading of data
3. Data storage component
4. Information delivery component
 Novice users
 Casual users
 Business analyst
 Power user
 Senior executives
5. Meta-data component
 Operational meta-data
 Transformational meta-data
 End user meta-data
6. Management & control component

2. Figure 1: Components of a Data-warehouse

Management
& Control
Component
Meta Data
Component
Information
Delivery
Component
Data Storage
Component
Data Staging
Component
Source Data
Component
Components of Data ware house
Production
Data Novice Users
Homonyms
Synonyms
Transformation
of Data
Extraction of
Data
External
Data
Archived
Data
Internal
Data
Loading of
Data
End User
Meta Data
Transformation
Meta Data
Operational
Meta Data
Senior
Executive
Power Users
Business
Analyst
Casual Users