Data warehouse versus data marts

Most data warehousing initiatives fail (mainly because this level of standardization slows down an agency/company enough that the project gets derailed; boiling the ocean phenomenon).

Avoid building a Data Warehouse right away, but approach it in a slightly different manner. 

Build individual data marts instead; each department gets to own its own data mart. These individual data marts would still follow a common standardized technical architecture; and would be able to talk to each other.

For e.g. definitions and metadata in each data mart should follow the same convention.

This paves the way for a final data warehouse – which could simply be a loosely coupled conglomerate of these independent data marts.

Specializing in high volume web and cloud application architecture, Anuj Varma’s customer base includes Fortune 100 companies (dell.com, British Petroleum, Schlumberger).
Anuj’s training as a mathematical physicist followed by years of advanced computer programming is unique in the industry.

For Anuj’s popular technology seminars and science and scientific computing seminars, please visit ANUJ.COM

For Anuj’s Mathematical Models and Math Modeling related consulting , please visit anuj.com.

All content on this site is original and owned by AdverSite Web Holdings, Inc. – the parent company of anujvarma.com. No part of it may be reproduced without EXPLICIT consent from the owner of the content.

Anuj Varma – who has written posts on Anuj Varma, Technology Architect.


Leave a Reply

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