Question

  Asked: Mar 21 2008   7:06 AM GMT
  Asked by: Pratap123


datamart & datawarehouse


Database Management Systems, Data mart, Data warehouse

What do you mean by DATAMART & DATAWAREHOUSE & what is the difference betwen two??

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0



A data warehouse in an Enterprise reporting solution. It will typically hold all historical data for the company for all time.

A datamart is a smaller version of the data warehouse. It's going to hold a year or two's worth of information, and may not hold all the tables in the data warehouse. While the data warehouse is for the enterprise, a datamart is typically for a departments use.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Database and DataManagement.

Looking for relevant Database Whitepapers? Visit the SearchOracle.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Pratap123  |   Mar 21 2008  7:15AM GMT

DATAMART & DATAWAREHOSE