|
| |
simplicable technology guide
»
architect's toolkit
»
reference architectures
»
enterprise data warehouse reference architecture
Enterprise Data Warehouse Reference Architecture
posted by Anna Mar, December 22, 2011
Enterprise Data Warehouses (EDW) provide the core infrastructure that drives enterprise decision making for business processes. EDW hold analytical and historical data structured by functional domains (datamarts) such as customer, bill, finance and human resources.
The logical architecture of a typical EDW looks something like this.
(click to enlarge)
Data SourcesData Warehouses load operational data from legacy data sources, enterprise systems, LOB applications, third party data services and operational data stores.
Internal ArchitectureData Warehouses have three functional layers: integration and loading, database management and data access.
ConsumersTypical consumers of a data warehouse include analytics, business intelligence (reporting), BPM, SOA services, enterprise applications and query tools.
Any system that supports business processes may require decision support data from a DWH.
|
ESB vs. ETL — what you need to know to make an informed choice.
|
|
It's all about engaging customers, partners and employees.
|
|
The 90 second version of TOGAF — a popular enterprise architecture framework.
|
|
Tales of architecture dread.
|
Recently on Simplicable
| |
posted by John Spacey
The exciting world of ITIL metrics.
|
| |
posted by John Spacey
Understanding your vulnerabilities is the first step to managing risk.
|
| |
posted by John Spacey
Understand the threats to your organization.
|
| |
posted by Anna Mar
Enterprise Architecture (EA) is supposed to help manage IT risks
— but is it possible that EA itself introduces new risks?
|
|
