Jorge_Beteta
asked on
What is the difference between DataMart and Datawarehouse ?
Hello Experts!
I'm quite newbie about databases. Would anybody explain me what is the difference between a DataMart and a Datawarehouse ? Is it the same?
Thank you!
I'm quite newbie about databases. Would anybody explain me what is the difference between a DataMart and a Datawarehouse ? Is it the same?
Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
yes datamart and dataware house basically same
the only difference is that datawarehouse is composed of different datamart.
the only difference is that datawarehouse is composed of different datamart.
In Mart
>Designed for a Specific Business Purpose
Typically Smaller
>" Button-up" (from User)
>Flexible to User's Needs
>User's Can Often Design Own Analyses
While the warehouse is:
>Designed as General Warehouse for Corp. Data
Typically Larger
>Detail Data Often Maintain
>"Top-Down" (from Corporate)
>Massive Structure and Varied Demands Make Change Difficult
>May Compromise a Series of Data Marts
Hope this one can help you more understand the Datamart and DataWarehouse
>Designed for a Specific Business Purpose
Typically Smaller
>" Button-up" (from User)
>Flexible to User's Needs
>User's Can Often Design Own Analyses
While the warehouse is:
>Designed as General Warehouse for Corp. Data
Typically Larger
>Detail Data Often Maintain
>"Top-Down" (from Corporate)
>Massive Structure and Varied Demands Make Change Difficult
>May Compromise a Series of Data Marts
Hope this one can help you more understand the Datamart and DataWarehouse
Basically, a datamart is a small section of data that is specific to a department or a small group of people. The data warehouse is usually created to be used by the enterprise or the orginization.
Brett