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.

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