Difference between Operational DB and DW


Operational DB
DW
It is designed to support operational monitoring
It is designed to support decision making process
Data is volatile
Data is Non-Volatile
Current Data
Historical Data
Detailed data
Summarized data
Normalization
De-Normalization
Designed for support ER- Modeling
Designed for support  Dimensional Modeling
Designed for running business
Design for Analyzing Business
Designed for clerical access
Designed for managerial access
More no of Joins
Few Joins
Few indexes
More indexes

No comments:

Post a Comment

Popular Posts