Data Warehousing Community Forum
February 10, 2012, 12:57:19 am

Pages: [1]   Go Down
  Print  
Author Topic: Difference between Datamart & Data Warehouse ?  (Read 1133 times)
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« on: May 22, 2007, 10:38:20 am »

As per the definition, Both the Datamart & Data warehouse are one and the same.

But there are so many confusing and conflicting definitions of Data Mart and Data Warehouse around us. This was due to the famous mammoths of Data warehousing, i.e., Bill Inmon and Ralph Kimball.

But In genearl to say, there is no difference coming to design part of these two, where as a Data warehouse is used on Enterprise level, where as Datamart is used on a Business Division/Departmental level.

A Datamart only contains data specific to a particular Subject area, where as Data Warehouse is an integration of all different subject-areas.

               

By the above figure we can easily differentiate these two.
Logged

If most people said what’s on their minds, they’d be speechless.
alexa007
DW Fresher
*

Reputation: +1/-0
Offline Offline

Posts: 17


View Profile
« Reply #1 on: September 20, 2011, 03:37:22 pm »

Data warehouse: A Data Warehouse is a place where data can be stored for more convenient mining. It is a collection of data marts. It represents historical data.
Data mart: It is a sub set of data ware house.  It can provide the data to analyze query reporting and analysis.

___________________
Logged
Pages: [1]   Go Up
  Print  
 
Jump to: