A data mart is a subset of the data warehouse, which concentrates on a specific business unit. A data mart, may or may not derived from a data warehouse and is aimed at meeting an immediate requirement. A Data Mart is the implementation of a Data Warehouse with a range restricted to a functional area, particular problem, department, subject or group of needs.
In addition to the main DW can be multiple Data Marts (DM). DMs may or may not dependent on other data marts in an organization. If the data marts have conformed dimensions and facts, then these data marts will be related to each other.
Benefits of data mart:
- Frequently needed data can be accessed very easily.
- Performance improvement.
- Data marts can be created easily.
- Lower cost in implementing data mart than a data warehouse.
Dependent data mart:
A dependent data mart is a subset (either logical subset or physical subset) of a large data warehouse which is isolated. Due to frequent refreshment of data, performance, security; the dependent data mart is isolated.
How can we improve? Please comment to let us know.
Check out popular data mart software