In this article, I will COMPARE DATA MART AND DATA WAREHOUSE
What is data mart?
DATA MART can be defined as the subset of a data warehouse of an organization that is limited to a specific business unit or group of users.
What is a Data Warehouse?
A data warehouse is a repository of information collected from multiple sources, stored under a unified schema, and usually residing at a single site
Comparison of data mart and data warehouse
|Parameter||DATA WAREHOUSE||DATA MART|
|Subjects||Holds data from multiple subject point of view||Holds data from the specific subject (Mostly one subject area) E.g. marks, sales, etc|
|Data Source||Has concentrated data from multiple sources and multiple subject areas.||It has a specific form of data and a single data source.|
|Data Perspective||Holds detailed information and data||Holds summarized data only|
|Dimensional Models||Contains all data no dimensional models are applied||It contains summarized data available after applying the dimensional model.|
|Characteristics||Flexible Data Orientation Durable||Restrictive Project Orientation Tactical|
|Scope||Application Neutral Centralized||Specific Application Department specific|
GOOD JOB DONE BY THIS WEBSITE THAT HAS GIVEN THE CALCULATOR FOR FIVE-NUMBER SUMMARY.
IF YOU LIKE TO DO SOME PROJECTS VISIT HERE FOR SMALL AND RELIABLE PROJECT.