I am sure all you guys who have worked in warehousing practice, have at least heard these words and many of them actually have implemented these concepts...Cube and a Data mart
Recently i was having discussion with my peers in BI/warehousing pratice, on what are the differences between Cubes and Data Marts...and to my surprise..the discussion as not so productive as we digressed to diferent terms like OLAP and ROLAP...as no one was clear which way to go for a particular scenario.
So basically i am asking is two questions
1) What are the differences between a Cube and Data mart?
I've also had folks tell me that a data mart is more than just a collection of cubes. I've also had people tell me that data mart is a reporting cube, nothing more...
2) In what scenario would you choose cube over Data Mart and vice versa?
Waiting for your inputs...
--Nilesh
It is my understanding that data marts are a way of logically categorizing one or more fact tables. A cube on the other hand is more on a technical level and is usually implemented by a software so as to allow quick multi-dimensional analysis.
ReplyDeleteWhen i think of data-marts it is more of a logical level or even diagramming level so that the business users can categorize the kind of information coming from that data-mart easily.
Yash i appreciate your inputs
ReplyDeleteSo you are saying cubes are used for multi dimensional analysis and Data marts single dimensional analysis for one or more fact tables.
I would agree with your syntax.
Have you implemented Cubes or Data Marts in your experience and in what scenario would you choose one over another?
--Nilesh
This is one of the finest blog regarding Benefits Data Management Services, which will be very much effective for us in the future. Thanks for sharing such great information. Keep it up.
ReplyDelete