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