A data mart is a data organization that is based on a business category. You can use data marts to organize data for a specific product or scenario. In most cases, a data mart belongs to an application layer and depends on the aggregate data in one or more common layers. This topic describes how to create a data mart and manage subject areas that are associated with a data mart.

Prerequisites

A business category is created to differentiate business data based on specific scenarios. For more information, see Business category.

Background information

A data mart defines business subjects for a business category. You can categorize data in a data mart into different subject areas based on various analysis perspectives. Data marts are used to collect statistics on business applications and analyze the statistics. For example, you can create a data mart to collect statistics on an operations platform and analyze the statistics.

Create a data mart

  1. Go to the Data Modeling page.
    1. Log on to the DataWorks console.
    2. In the left-side navigation pane, click Workspaces.
    3. In the top navigation bar, select the region where the workspace that you want to manage resides. Find the workspace and click Data Analytics in the Actions column.
    4. On the DataStudio page, click the Icon icon in the upper-left corner and choose All Products > Data Modeling.
  2. In the left-side navigation pane of the Data Warehouse Planning page, choose Application layer > Data Mart to go to the Data Mart page.
  3. Create a data mart.
    1. On the Data Mart page, move the pointer over the Create icon and click Create First-level Data Mart.
    2. In the Create First-level Data Mart dialog box, configure the parameters.
      Create First-level Data Mart
      Parameter Description
      Abbreviation The abbreviation for the name of the data mart.

      The abbreviation can be a maximum of 128 characters in length. The abbreviation can contain lowercase letters, digits, and underscores (_) and must start with a lowercase letter.

      Mart Name The name of the data mart.

      The name can be a maximum of 2,048 characters in length. The name can contain letters, digits, underscores (_), ampersands (&), and parentheses () and must start with a letter or digit.

      Mart Type The type of the data mart. Valid values:
      • Business Mart: a type of data mart that is oriented to business requirements.
      • Data Application Mart: a type of data mart that is oriented to requirements for data products.
      • Common Mart: a type of data mart that can be used for general purposes at application layers.
      Business Category The business category to which the data mart belongs. For more information, see Business category.
      Owner The owner of the data mart. The default value of this parameter is the Alibaba Cloud account that is used to log on to the DataWorks console.
      Description The description of the data mart.

      The description can be up to 2,048 characters in length.

  4. Click OK. The data mart is created.
    If you want to modify or delete a data mart, you can find the name of the data mart in the left-side navigation tree of the Data Mart page, right-click the name, and then select Edit or Delete.
    Note Before you delete a data mart, you must remove all association relationships of the data mart.

Manage subject areas associated with a data mart

A subject area is a collection of business subjects and is used to categorize data in a data mart from various analysis perspectives. You can view the subject areas that are associated with a data mart in the Subject Domain Management section of the details page of the data mart. You can also modify or delete the association relationship between a subject area and the data mart based on your business requirements.
Note If you click Delete in the Actions column to delete the association relationship between a subject area and the data mart, the subject area is also deleted. Proceed with caution.
Manage subject areas associated with a data mart

Create a child data mart

You can create child data marts for each data mart. The method used to create a child data mart is the same as the method used to create a data mart. Create a child data mart

What to do next

After a data mart is created, you can associate the data mart with an application table when you create the application table for business analysis.