DatawareHouse(DW)

OLTP - OLAP (online analyical processing)

ft → be → dbms → staging → ods → dw → dm

OLTP


transaction

OLAP


Analytical

staging → ods → dw(cube) → dm(cube)

read data ⇒ ETL (Extract - Transform - Load)

Data E2E Pipeline