Data Warehouse - Layer (Architecture)

Data System Architecture

Layer Properties

Name Properties
Stage Layer Real-Time, CDC, continuous refresh
DataWarehouse Layer / ODS Normalized, Data History, refresh: 2-6 daily
Data Mart Performance, Access layer, Star schema, refresh: 1-4 daily

Dw Layers


See also: Data Warehousing - 34 Kimball Subsytems


Data Warehouse Fundamental Architecture


Data Warehouse Traditional Architecture

Back Room / Front Room

Be careful with this one, you have a fork from the staging area to the datawarehouse and ODS. This fork is a bad design because you publish twice the same data and then bring inconsistency

Datawarehouse Bi

Data Model by Layer

See Data Warehouse - Data Models

Documentation / Reference

Discover More
Martin Kleppmann Data Hierarchy Of Needs
Data Processing - Architecture

Fault tolerance Parallelism High Latency Delivery semantics Operations and monitoring Schema management forward-compatible data architecture: the ability to add more applications that need...
Data System Architecture
Data Warehouse

A data warehouse is a large central data repository of current, history and summarised data coming from operational and external sources used primarily for analysis. s is large historical databases for...
Data System Architecture
Data Warehouse - Persistent layer (Fundamental Layer | Operational Data Store - ODS)

A persistent layer is a data warehouse layer where data is persisted (ie never deleted). A persistent layer is also known as: a fundamental layer an operational data store (ODS) an enterprise...

Share this page:
Follow us:
Task Runner