operational database:
1.It is designed to support business transnational processing.
2. Data is volatile .
3.Current Data .
4. Design for Running the business .
5. Normalization .
6. More joins .
Data warehouse :
1.It is designed to support Decision Making process.2. Data is Non-volatile .
3.Historical Data .
4. Design for Analyzing the business .
5. De-Normalization .
6. Few joins .
No comments:
Post a Comment