Data warehouse architecture that’s too narrowly focused

Learn WHY you should design a data warehouse a certain way
November 19, 2008
Upgrading your data integration efforts to enable Business Intelligence (BI) 2.0
November 25, 2008
Show all

Data warehouse architecture that’s too narrowly focused

published in Information ManagementIn my DM Review columns, “The Accidental Architecture” and “Recovering from the Accidental Architecture,” I discussed whether people understood the “why” of best practices, such as dimensional modeling and hub-and-spoke architecture. In “Don’t Stop at How, Learn Why,” I discussed the most common problems when people are too hub myopic, cloning their source systems or assuming the hub will support all reporting and analytic needs.

There are also dangers with being too spoke-centric (with data marts or cubes) and failing to establish the hub, or data warehouse (DW), as the enterprise data backbone.

>>> Read the rest of my article “Too Narrowly Focused” on the DM Review website.

Leave a Reply

Your email address will not be published. Required fields are marked *