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