An organization collects data, suppose operational data (everyday transactions/business processes) through database systems and utilize data modeling to create a well defined structure.
A Data warehouse is a centralized data repository that aggregates, stores, and processes large amounts of data from multiple sources.
It separates the data analysis workload from the standard transaction workload of a regular database management system.
There are four key characteristics of a data warehouse.
- Subject-oriented — When building a data warehouse, one should have in mind one or more subject areas to explore, meaning what business process they want to store and analyze. It makes it is easier to store all the relevant data related to a subject in the data warehouse.
