Pages

Monday, 23 June 2014

Difference between data warehouse and an operational database ?

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