+25 Warehouse Architecture References. A data warehouse (dw or dwh) is a complex system that stores historical and cumulative data used for forecasting, reporting, and data analysis. All data warehouses share a basic design in which metadata, summary data, and raw data are stored within the.
The bottom tier, where data is collected and stored; The middle tier, where data is analyzed; There are 3 approaches for constructing data warehouse layers:
