How do I know if I will benefit from a data mart (in addition to my data warehouse) and how do I determine what data goes where?
Well, I guess it all depends on how you define data mart, doesn't it? Let's start with one popular definition of a data mart as a smaller-scale data warehouse (not my favorite definition). The benefit of a data mart is that it can be implemented more quickly and can deliver quick payback, so the initial ROI of this "type" of data mart can be compelling. The problem is that it is almost like replicating the stove-pipe architecture that causes us all those problems in our operational systems. So you wind up with multiple departmental data marts with no integration or sharing between them. And what if multiple data marts use the same data (e.g.. customer or sales) but different sources or with different latency? One data mart gives one answer and the other gives another. So you've caused problem – at least when viewed at the macro level.
Another definition of data mart is a departmental spin-off from the data warehouse or ODS. This can help to rectify the stove-pipe problem while giving the benefits discussed above. So it is not really an issue of whether you "need a data mart" as much as it is an issue of ensuring the reliability and accuracy of the source for your analytical data, whether it be in departmental data marts, or a central data warehouse.
Of course, there are multiple additional issues we could discuss, but a Q&A forum such as this is not necessarily the place to discuss issues in extreme depth. I would suggest that you read up on data marts and here are some interesting links for doing so:
- Definition: Data mart
- Sample chapter: The data warehouse toolkit, by Ralph Kimball
- Article: Daniel Graham on data mart vs. data warehouse
- Article: Data mart vs. data warehouse - The great debate
- Or, look into one of these books on data warehousing
And even if you do read all of this it still can be confusing. Good luck.
Dig Deeper on Data warehouse software
Related Q&A from Craig S. Mullins
To export data from a DB2 table to a flat file, you need to run an export specifying the proper file format. The export utility exports data from a ... Continue Reading
Craig Mullins recommends two specific resources for learning how to create and support Binary Large Objects (BLOB) in DB2. Continue Reading
There are reasons to convert from VSAM to DB2 -- and there are reasons not to. Find out what Craig Mullins has to say about a VSAM to DB2 migration ... Continue Reading