[ADP] #4-3. Data Marts

1. Definition of Data Marts

  • A data mart is a small data warehouse designed for a specific department or business line.
  • It is designed to meet the specific needs of its users.

2. Types of Data Marts

  • Independent Data Marts: Operate independently from a data warehouse. Collect data from their own sources.
  • Dependent Data Marts: Use data drawn from a data warehouse. Data is cleansed and transformed before loading into the data mart.

3. Components of Data Marts

  • Data Sources: Collect data from various sources such as internal systems, external sources, ERP systems, CRM systems.
  • ETL Process: The process of Extracting, Transforming, and Loading data. Includes data cleansing and transformation.
  • Data Storage: Space for storing data, such as databases, data warehouses, and cloud storage.
  • Query and Reporting Tools: Tools for analyzing data and generating reports, such as SQL, BI tools, and data visualization tools.

4. Advantages and Disadvantages of Data Marts

  • Advantages:
    • Designed to meet the specific needs of users, providing quick access to needed data.
    • Improved data accessibility and performance.
    • Enables customized analysis for specific business lines.
  • Disadvantages:
    • Potential data redundancy, leading to wasted storage space.
    • Maintaining data integration and consistency can be challenging.
    • Managing and updating data can be complex, especially for independent data marts.

답글 남기기

이메일 주소는 공개되지 않습니다. 필수 필드는 *로 표시됩니다