All Products
Search
Document Center

Schema design

Last Updated: Jun 03, 2020

This topic describes the Schema design of Data Management Service (DMS) and its operation steps.

Background

In business scenarios such as creating new projects, mapping new business requirements, or optimizing business operations, it would involve the operation of creating new tables and modifying table structures (addition and subtraction of fields, addition and subtraction of indexes, adjustment of field attributes, and adjustment of index composition). At this time, DMS comes in handy with its object structure design function:

-Support multi-person collaboration to change the data structure on the Web page.-Support one-click sending of verified scripts to other environments to ensure the structural consistency of related tables between environments.

Prerequisites

The database type must be MySQL, DRDS, OceanBase .

we will gradually support other database types in the near future.

Limits

-It is currently not supported to delete a table created before the creation of a support ticket.-After executing the change to a target database, metadata information will be automatically synchronized. You can go to the SQLConsole query window to verify whether the change takes effect. The command is show create table table_name ordesc table_name.

Steps

  1. Log on DMS.
  2. Select Database/Table Structure > Structure Design above. schema
  3. Click Schema Design in the upper right.
  4. Enter the following parameters:
    • Project name : The name of the project.
    • Business background : Describe the business background information of the project, such as the purpose of changes and expected goals.
    • Change Base Library : It can be a combination of permissions for queries, exports, and changes. You can filter by the library name prefix, but only the databases to which you have the right permissions would show up
    • Change related personnel : All related persons can view the support tickets and collaboratively work on them. Non-related persons cannot view the support tickets (except administrators and DBAs)
  5. Click Create Ticket .
  6. You can perform corresponding DDL operations according to your needs, for example:
    • When you need to create a new table, click New Physical Table directly.
    • When you need to modify the table, left-click on target table on the left-hand side, and select Design Table .
  7. Click Execute Change to Base Library .
  8. Select the execution time and click Submit to execute .
  9. Wait for the approval to complete.

    You can track the chain of approval, and who have the authorizations to approve your requests.

  10. Click enter the next node .
    • After approval, the platform executes the changes according to the specified time window (changes that do not specify an execution time will be automatically triggered after the last approval node is passed), you can view the execution status and execution logs. At this time, you can choose to enter the design modification again to repeat the entire execution process, or end the design structure to enter the next node.
      • The specifications set in advance will determine whether you can go back and revise after entering the next node.
  11. Click Execute the changes to your target library .
  12. Select the target library and execution time, and click Submit to execute .

    The target library must be in production environment

  13. Wait for approval and execution to be completed.
  14. Click enter the next node .

    The whole process is now completed and the support ticket will be closed.

Related documents