Data Mart

Describing a Data Mart

• A data mart is a subsection of a data warehouse
• It is designed for a particular department or business function

Describing the Types of Data Marts

1. Dependent Data Marts

   • A dependent data mart is constructed from an existing data warehouse

2. Independent Data Marts

   • An independent data mart is created without the use of a data warehouse and focuses on one business function

3. Hybrid Data Marts

   • A hybrid data mart integrates data from an already existing data warehouse and additional operational source systems

Describing the Benefits of Data Marts

• A data mart provides isolated security

  • It only contains data specific to a given department

• A data mart provides isolated performance

  • It only manages performance loads across different departments

Difference between Data Warehouses and Marts

• A data warehouse is a system used for broader applications
• Whereas, a data mart is a system used for specific applications
• A data warehouse stores data in a centralised archive
• Whereas, a data mart stores data decentrally in different archives
• A data warehouse consists of a detailed form of data
• Whereas, a data mart consists of more summarized data
• Development of a data warehouse involves a top-down approach
• Wheras, a data mart involves a bottom-up approach
• A data warehouse is thought of as more adjustable, information-oriented and longtime existing
• Whereas, a data mart is thought of as restricted, project-oriented, and has a shorter existence

References

• Defining a Data Mart