0

810views

Explain difference between Data Warehouse and Data Mart.

written 2.6 years ago by pradnyanabar2613 ★ 5.2k

modified 2.6 years ago by Krishna_Agrawal • 2.7k

data warehouse and mining

ADD COMMENT FOLLOW SHARE EDIT

1 Answer

0

31views

written 2.6 years ago by Krishna_Agrawal • 2.7k

BASIS FOR COMPARISON	DATA WAREHOUSE	DATA MART
Definition	A Data Warehouse is a large repository of data collected from different organizations or departments within a corporation.	A data mart is an only subtype of a Data Warehouse. It is designed to meet the need of a certain user group.
Usage	Used for data integration and in the decision making processes.	Used for concrete strategic decisions.
Aim	Provides an integrated and consistent environment for all enterprise data assests.	Provides an integrated environment for data about a concrete business area or department.
Design	The designing process of Data Warehouse is quite difficult.	The designing process of Data Mart is easy.
Focus	General, Company-wide information.	Specific, information related to a specific department.
Size	Usually from 100GB to 1TB.	Usually less than 100 GB.
Data Handling	Data warehousing includes large area of the corporation which is why it takes a long time to process it.	Data marts are easy to use, design and implement as it can only handle small amounts of data.
Data Storing	Designed to store enterprise-wide decision data, not just marketing data.	Dimensional modeling and star schema design employed for optimizing the performance of access layer.
Data Type	Time variance and non-volatile design are strictly enforced.	Mostly includes consolidation data structures to meet subject area’s query and reporting needs.
Data Value	Read-Only from the end-users standpoint.	Transaction data regardless of grain fed directly from the Data Warehouse.
Scope	Data warehousing is more helpful as it can bring information from any department.	Data mart contains data, of a specific department of a company. There are maybe separate data marts for sales, finance, marketing, etc. Has limited usage.
Implementation Time	The implementation process of Data Warehouse can be extended from months to years.	The implementation process of Data Mart is restricted to few months..

ADD COMMENT SHARE EDIT