Data Warehouse Architectures

While Kimball's DW/BI architecture is the primary focus of this book, it is essential to understand the other prominent architectures that exist in the data warehousing landscape. Comparing these approaches clarifies why specific architectural decisions are made.

Four prominent data warehouse architectures are:

1. Independent Data Mart Architecture
2. Hub-and-Spoke Corporate Information Factory (Inmon Architecture)
3. Kimball's DW/BI Architecture
4. Hybrid Hub-and-Spoke and Kimball Architecture