Add

Difference between ODS and Data Warehouse

Share:

Difference between ODS and Data Warehouse

Operational data store
ODS uses current data.
Run the business on a current basis.
Design goal is performance throughput.
Frequent small updates.
ODS does not support summary data.
Supports simple queries on a few rows.

Data warehouse
Data warehouse uses historical data.
Support managerial decision making.
Design goal is easy reporting and analytics.
and administrators.
Period batch updates.
Data warehouse support summary data.
Supports complex queries on several rows.

No comments