You can add a checker on the details page of the created data layer to specify the naming conventions of tables at the data layer. This facilitates subsequent table management. This topic describes how to view details about a data layer and how to add a data layer checker in Data Modeling.

Prerequisites

A data layer for which you want to configure a checker is created. For more information about how to create a data layer, see Create a data layer.

Background information

A data layer checker is used to specify the naming conventions of tables at the data layer. This way, you can use a table name to easily obtain the following information about the table: business type, functionality, and data granularity. The data layer checker also helps reduce operations and maintenance (O&M) costs.

You can add and configure a checker for a default data layer created by the system or for your custom data layer.

Note You can repeat the following steps to add and configure a checker for each data layer.
  1. On the Data Layer page, click the created data layer to go to the details page of the data layer.
  2. Configure a data layer checker.
    On the details page of the data layer, add and configure a checker for the data layer:
    Note A data layer checker is used to specify the naming conventions of tables at the data layer. This way, you can use a table name to easily obtain the following information about the table: business type, functionality, and data granularity. The data layer checker also helps reduce operations and maintenance (O&M) costs.
    1. In the Checker Management section, click Add.
    2. Configure parameters for the checker.
      Checker Management
      Parameter Description
      Abbreviation The abbreviation of the checker.

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

      Name The name of the checker.

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

      Type You can set Type only to Table Name Checker. The parameter is used to check whether the names of tables at a data layer conform to the naming conventions of the data layer.
      Rule Definition The rules against which the names of tables at a data layer are checked. You can enter a table name prefix to define a rule. For example, a data layer must start with dim. You can also click the Icon icon to define a rule by entering the abbreviation of a business category, data domain, business process, root, multi-root, storage strategy, dimension definition, or period, or entering a custom definition.
      Default Specifies whether the checker is configured as the default checker.
      Enabled Specifies whether the configured checker takes effect. By default, the configured checker is enabled.
      Real-time Check Specifies whether to enable real-time check. By default, real-time check is disabled.
      • Real-time check is enabled: The table name is automatically checked in real time when the table is being created or modified.
      • Real-time check is disabled: The table name is not checked in real time when the table is being created or modified. You need to click Start Check on the details page of the data layer to check the table name after the table is created or modified.
      Description The description of the checker.
    3. Click Save to save the settings of the checker.
    4. Start the checker and view the check result.
      1. After the checker is configured, click Start Check. The system starts all checkers at the data layer to check whether the names of all tables at the data layer conform to the naming conventions of the data layer based on the checker settings.
      2. After the check is complete, click View Results to view the check results in the View Result dialog box.
      • Example 1: Set the Rule Definition parameter to ^dim_.* for the configured checker in the Checker Management section if an enterprise requires that the names of tables at a data layer start with dim_. The following table describes the check results after you click Start Check for tables dim_sku, dim_store, dimension_warehouse, and fact_order.
        Table name Naming conventions observed
        dim_sku Yes
        dim_store Yes
        dimension_warehouse No
        fact_order No
      • Example 2: An enterprise requires that tables at the DWD layer be named in the format of Abbreviation of data layer_Data domain of the table_Abbreviation of custom table name tag_df/di. The following table describes the check results after you click Start Check for tables dwd_sale_order_df, dwd_sale_order_di, dwd_sale_order, and dws_sale_order_df.
        Table name Naming conventions observed
        dwd_sale_order_df Yes
        dwd_sale_order_di Yes
        dwd_sale_order No
        dws_sale_order_df No

What to do next

After the data layer is created and configured, you can continue to plan and create data domains, business processes, and business categories in Data Warehouse Planning. For more information, see Data domain, Business process, and Business category.