|
Data Warehouse -> Data Mart 1, 2, 3 ...
Recommended by Bill Inmon. Transfer all OLTP data to data warehouse. Data marts are sub sets of DW.
Data flow:
OLTP data -> Staging -> Operational Data Store (ODS) -> Aggregation, Summarization -> Data Warehouse -> Staging -> Transformation -> Data Marts
OLTP data -> Staging -> Data Warehouse (atomic level)
Data Mart 1 - Data Mart 2 - Data Mart 3 - ...
Recommended by Ralph Kimball. Data Marts connected with a bus structure to form a data warehouse.
Data Flow:
OLTP data -> Staging -> Operational Data Store (ODS) -> Data Mart -> Staging -> Aggregation, Summarization -> Data Warehouse
Data Flow:
OLTP data -> Staging -> Aggregation, Summarization -> Data Mart (contains both atomic and summary data) -> Staging -> Data Warehouse
Query tools are reprogrammed to request summary data from the marts and atomic data from the data warehouse.
Hub-and-spoke architecture
Integration of heterogeneous data warehouses, data marts that already exist in the enterprise.
|
