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