October 18, 2014 \ Ananth TM \ 1 Comment Types of Data Warehouse 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. Other Types: Types of Dimension Tables Types of Hashed Files Types of Dimensional Modeling