What is difference between data mart and data warehouse?
Data Warehouse is a big central repository of historical data. This data is assembled from different departments and units of the company. Data Mart can be considered as a subset of data warehouse or simply a data repository which is generally focused on a single functional area. They both primarily vary in their scope and usage area.
Data Mart vs Data warehouse :
Data warehouse Data mart Data warehousing is subject oriented, time variant, non-volatile collection of data which is used for creation of transactional reports as well as historical reports. Data Mart is simply a subset of Organization’s Data warehouse .These are most important concepts of data mining.
Definition:
The Data Warehouse is a large repository of data collected from different organizations or departments within a corporation.
Definition:
The data mart is an only subtype of a Data Warehouse. It is designed to meet the need of a certain user group.
Focus:
Data warehouse focuses on multiple business areas.
Focus:
Data mart focuses only on single subject area.
Usage:
It helps to take a strategic decision.
Usage:
The data mart is used to take tactical decisions for growth of business.
Type of system :
This is centralized system where one fact is at center surrounded by dimension tables.
Type of system :
Data mart system is de centralized system
Scope of Business:
The Data warehouse will cover all business areas.
Scope of Business:
The scope of Data mart is within the line of the Business.
Data Model:
Data warehouse always follows top-down model
Data mart always follows bottom-up model.
Data Size:
Data warehouse contains all historical data so the database size is large.Approximate size of data warehouse is greater than 100 GB.
Data Size:
Data mart contains data with only one business area so the size of database is smaller than data warehouse.
Source:
Data warehouse data comes from multiple heterogeneous data sources.
Source:
Data mart data is data of only one business area.Many times it will come from only one data source.
Implementation Time:
Data warehouse contains all data which will come from multiple data sources. It will take time to build data warehouse. The Time to build data warehouse is months to years.
Implementation Time:
Data mart is small data warehouse which will contain the data of only a single business area. The implementation time to build data mart is in months.
Hope you like this Data Mart vs Data warehouse article. If you have any suggestions about Data Mart vs Data warehouse article kindly comment in comment section.