Difference Between Data Warehouse and Data Mart

Data Structure AlgorithmsBusinessEnvironment

In this post, we will understand the difference between data warehouse and data mart.

Data Warehouse

  • It is a large repository of data that is collected from different organizations within a corporation.

  • It helps make a strategic decision.

  • The main objective is to provide an integrated environment and coherent image of the business.

  • The designing process is tough.

  • It may or may not be used in a dimensional model.

  • It can feed dimensional models.

  • It includes large areas of the corporation, hence it takes a long time to process it.

Data Mart

  • It is a subtype of data warehouse.

  • It is designed to meet the requirement of a specific user group.

  • It helps make tactical decisions for business.

  • It is generally used in the business division at the departmental level.

  • The process of designing it is easy.

  • It is built by focusing on a dimensional model.

  • They are easy to use, and implement.

  • They can only handle small amounts of data.

Updated on 25-Mar-2021 06:13:27