- structured, historical and aggregated data
- Example: Amazon Redshift, Google BigQuery, Azure Synapse
A Data Warehouse is separate from DBMS, it stores a huge amount of data, which is typically collected from multiple heterogeneous sources like files, DBMS, etc. The goal is to produce statistical results that may help in decision-making. For example, a college might want to see quick different results, like how the placement of CS students has improved over the last 10 years, in terms of salaries, counts, etc
- system used for reporting and data analysis and is a core component of business intelligence
- central repositories of data integrated from disparate sources