What is the difference between a data warehouse and a data mart?
Parameter |
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 |
It helps to take a strategic decision. |
It helps to take tactical decisions for the
business. |
Objective |
The main objective of Data Warehouse is to
provide an integrated environment and coherent picture of the business at a
point in time. |
A data mart is mostly used in a business division
at the department level. |
Designing |
The designing process of Data Warehouse is quite
difficult. |
The designing process of Data Mart is easy. |
May or may not use in a dimensional model.
However, it can feed dimensional models. |
It is built focused on a dimensional model using
a start schema. |
|
Data Handling |
Data warehousing includes a 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. |
Focus |
Data warehousing is broadly focused on all the
departments. It is possible that it can even represent the entire company. |
Data Mart is subject-oriented, and it is used at
a department level. |
Data type |
The data stored inside the Data Warehouse are
always detailed when compared with the data mart. |
Data Marts are built for particular user groups.
Therefore, data is short and limited. |
Subject-area |
The main objective of Data Warehouse is to
provide an integrated environment and coherent picture of the business at a
point in time. |
Mostly hold only one subject area- for example,
Sales figure. |
Data storing |
Designed to store enterprise-wide decision data,
not just marketing data. |
Dimensional modelling and star schema design are employed
for optimizing the performance of the access layer. |
Data type |
Time variance and non-volatile design are
strictly enforced. |
Mostly includes the consolidation of data
structures to meet the 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. |
Datamart contains data, of a specific department
of a company. There are maybe separate data marts for sales, finance,
marketing, etc. Has limited usage |
Source |
In Data Warehouse Data comes from many sources. |
In Data Mart data comes from very few sources. |
Size |
The size of the Data Warehouse may range from 100
GB to 1 TB+. |
The Size of the Data Mart is less than 100 GB. |
Implementation time |
The implementation process of Data Warehouse can
be extended from months to years. |
The implementation process of Data Mart is
restricted to a few months. |
1 Comments
Data Warehouse is a "Subject Oriented, Integrated, Time-Variant, Nonvolatile collection of data in support of decision making.
ReplyDeleteData Mart is usually sponsored at the department level with a focused objective.