I. EDW (Enterprise Data Warehouse):
It contains the historical business data at the enterprise level to support the business needs of top management in the organization.
- Contains data drawn from multiple operational systems.
- Supports time- series and trend analysis across different business areas.
- Can be used to populate data marts.
- Can be used for everyday and strategic decision making.
II. Data Marts:
A data mart is a subset of an organizational data store, usually oriented to a specific purpose or major data subject, which may be distributed to support business needs.
- Subset of enterprise data warehouse.
- Organized around a single business process.
- May or may not contain aggregates.
- Less expensive and much smaller than a full blown corporate data warehouse.
No comments:
Post a Comment