A data warehouse is an analytical database that centralizes structured, modeled and historized data coming from several systems. It is optimized for heavy read queries (aggregations, joins) and is queried in SQL. It serves as the single reference for reporting and analysis.
Example
SELECT region, SUM(montant) FROM ventes GROUP BY region;