According to the recent survey with our partners at The Data Warehousing Institute (TDWI), the most frequently implemented architecture is the data warehouse with attached data marts (43 percent of respondents). This corresponds most closely to what is also described as a hub-and-spoke architecture –­ a central data store with attached (dependent) data marts. Also of interest is a large group (19 percent) that is committed to centralized data warehousing pure and simple, and a significant number (11 percent) who are not sure what they have.

Interestingly, five percent of respondents report that "other" best describes their architecture. The first five options ­– federated data warehouse and marts through non-conformed data marts (highly distributed), etc. –­ are exhaustive distinctions. Therefore, if an enterprise claims to have a hybrid of these, it means it really does not know what to call the spaghetti-like structures that are its implied architecture.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access