We found understanding of “Data Warehouse Vrs Data Mart ” among the business intelligence solutions providers, it is presented below;
There are many fundamental differences between a data warehouse and a data mart. Some of the differences are as follows:
| Data warehouse | Data Mart |
| Corporate | Departmental |
| Highly detailed | Summarized / aggregated |
| Normalized-efficient storage – non duplication of data. | De-normalized, star joined design-less efficient storage but faster retrieval. |
| Robust history | Limited history |
| Large volumes of data | Limited volumes of data |
| Data model driven | Requirement driven |
| Versatile | Focused on departmental needs |
| General purpose DBMS (database management system) | Multi-dimensional DBMS technology |
