8.1 Data Modeling

Data Modeling refers to the process of replicating database objects from a source schema to a target schema. During this process, the structural definitions and metadata of the database objects are transferred to the target environment. This replication ensures that the logical design and structural components of the database are accurately maintained across schemas, supporting development activities for modelers. Database Objects are tables, views, functions, triggers, synonyms, Materialized views, procedures, packages, Sequences, and types.

Figure 8-1 Data Modeling tab


This image displays the Data Modeling tab.

  • Database Objects List menu
    • The interface displays a list of database object types. Users can select any object type to view the corresponding objects available within the schema.
  • Target Schemas Dropdown
    • The user can select the target schema from a dropdown menu. Based on the selected target schema, the system will display the corresponding list of database objects—filtered by the selected object type—in the left panel.
  • Database Objects List
    • A table displays the list of database objects based on the selected object type and schema. This table includes the source schema name, object name, and a View option.
      • The View option allows users to view the DDL (Data Definition Language) of the selected database object, along with a Generic View (applicable only for tables and views).

      Note:

      The Generic View presents a simplified tabular representation containing details such as column name, data type, nullability, and default value.

    • Figure 8-2 Data Definition Language View


      This image displays the Data Definition Language View

    • Figure 8-3 Generic View


      This image displays the Generic View.

  • Tree View and Add Item buttons
    • Tree View:
      1. Clicking this option opens a new tab within the Data Management UI, titled [TargetSchemaName] - Modeling.
      2. This view provides a hierarchical structure to assist users in creating and organizing new data models.
    • Add Item:
      1. This button opens a pop-up window that facilitates data modeling for the selected database object type (as chosen from the left panel).
  • Steps/Process of Data Modeling
    1. Launch any workspace where you wanted to do Data Modeling and go to Data Management tab from main menu.

      Figure 8-4 Data Management tab from main menu


      This image displays the Data Management tab from main menu.

    2. Click on Data Model sub-tab.

      Figure 8-5 Data Model sub-tab


      This image displays the Data Model sub-tab.

    3. Now user can see the list of Database objects on left panel, Tree View and Add Item options and a table (Refer to content on Data Modeling tab).
    4. Click on Manage button which will open a new tab within MMG- Data Management UI.

      Figure 8-6 Manage button tab


      This image displays the Manage button tab.

    5. When a new tab opens, it includes the following components:
      • Source Schema Drop down:
        1. Allows the user to select the desired source schema for Data Modeling. Users can switch between multiple Source Schemas and select the required database objects from each—all in a single Modeling session.
      • Left panel:
        1. Contains an object type drop down and a search bar for filtering.
        2. Displays a table listing the available database objects based on the selected type and schema.
      • Right panel:
        1. If the user is initiating Data Modeling for the first time, this panel will be empty.
        2. As the user selects database objects from the Left panel, they will be added to and displayed in the Right panel for further configuration.

        Figure 8-7 Left panel and Right panel


        This image displays the Left panel and Right panel.

    6. Now the user can choose source schema from where user wants to bring in the database objects.
    7. After selecting the Source Schema, the user can choose the desired database object type from the left panel. The table in the left panel will then display all available database objects that match the selected type and schema.

      Note:

      Each database object listed in the table includes an eye icon. Clicking this icon opens a pop-up that provides both the DDL View and the Generic View of the selected object.

      Figure 8-8 DDL and Generic View of the selected object


      This image displays the DDL and Generic View of the selected object.

    8. User can choose the required and the selected ones automatically comes into the right panel in following structure.
      1. Source Schema-Name1: DB object type 1, DB Object 1 2, DB Object 2.
      2. Source Schema-Name2: DB object type 1, DB Object 1 2, DB Object 2.

      Figure 8-9 Source Schema Name


      This image displays the Source Schema Name.

    9. Once all the required database objects are selected, the user can click the Apply Changes button to initiate the Data Modeling process. On triggering, a confirmation pop-up will be displayed, indicating that the Data Modeling process has started. This tab will automatically close after a few seconds.

      Figure 8-10 Apply Changes button


      This image displays the Apply Changes button.

      Figure 8-11 Confirmation message


      This image displays the Confirmation message on the Data Modeling process screen.

      Note:

      The user can choose database objects from multiple Source Schemas at a time. The user can also choose multiple database object types at a single time.

      Note:

      For a selected Target Schema, if any previous Data Modeling is in progress, the user is not allowed to do another Data Modeling.