Monday, April 9, 2012

What is Data Warehouse?

Definition #1
A data warehouse is a system that retrieves and consolidates data periodically from the source systems into a dimensional or normalized data store. 


Definition #2
A Data Warehouse is a database that is designed for facilitating querying and analysis. These database contain read-only data that can be queried and analysed.


Conclusion:
So what is difference between database and data warehouse?
Database is designed to record data and Data Warehouse is designed to analysis data.

No comments:

Post a Comment