Understanding of data warehouse ODS, DW and DM concepts in data governance platform

Data warehouse ODS、DW and DM Conceptual understanding

I've been working on data governance projects recently , There are some professional terms in it , Such as ODS、DW、DM, Now it is specially sorted out , Easy to master

ODS—— Operational data

DW—— Data warehouse

DM—— The data mart

1. The overall architecture of the data center

The overall architecture of the data center

The organization structure of data warehouse , Metadata of each system is passed through ETL Synchronization to operational data warehouse ODS in , Yes ODS The data is modeled for the topic domain DW（ Data warehouse ）,DM It's about modeling a business domain , Specific users （ Decision makers ） see DM Generated reports .

2. Data warehouse ODS、DW and DM Concept

ods、dw、dm distinguish

3.ODS、DW、DM Collaboration hierarchy diagram

Collaboration levels

4. Look at these layers of collaboration through a simple example

5.ODS To DW Integration examples for

                Integration example