To first understand various Data Warehouse architectures, we need to understand the various components in the enterprise that would contribute to the Data Warehouse.
Components of Data Warehouse Architecture
Various architectures noted
Depending on how the data is stored and accessed, the various architectures are:
- Independent data marts (IDM)
- Data mart bus architecture with linked dimensional data marts (DBA)
- Hub and Spoke Architecture (HAS)
- Federated architecture (FED)
- Centralized Architecture
One other way of classifying various Data warehouse architectures is by the number of middleware between the operational systems and the analytical tools. These would be – the single-layer architecture and the N-layer architecture.