Differences Between Data Warehouse and Data Mart

 

Key Differences Between Data Warehouse and Data Mart

1.    Data warehouse is application-independent whereas data mart is specific to decision support system application.

2.    The data is stored in a single, centralized repository in a data warehouse. As against, data mart stores data decentrally in the user area.

3.    Data warehouse contains a detailed form of data. In contrast, a data mart contains summarized and selected data.

4.    The data in a data warehouse is slightly denormalized while in the case of Datamart it is highly denormalized.

5.    The construction of a data warehouse involves a top-down approach. Conversely, while constructing a data mart the bottom-up approach is used.

6.    Data warehouse is flexible, information-oriented, and longtime existing nature. On the contrary, a data mart is restrictive, project-oriented, and has a shorter existence.

7.    Fact constellation schema is usually used for modeling a data warehouse whereas in data mart star schema is more popular.