Using SQL Server to Build a Hub-and-Spoke Enterprise Data Warehouse Architecture
Scalable, cost-effective Enterprise Data Warehouse (EDW) implementation is an elusive goal for many large organizations. Three common approaches include centralized EDW – the “monolithic” approach, decentralized collections of data marts, and attempts at hub-and-spoke architectures that combine the previous two. This whitepaper describes Microsoft’s unique and compelling Massively Parallel Processing (MPP) data warehouse solution that combines the best features of both EDW and decentralized data marts, providing the basis for solving one of the most intractable problems in large-scale data warehousing.