A series of step-based solutions for R&D processes, data security, and data development are provided in the Data Management (DMS) console to get you started with DMS.

Solutions for R&D processes

DMS is an online process system that allows you to centralize all database resources within your enterprise. You can interact with the databases in the DMS console. You can design and use different development standards, development processes, and approval processes for database instances that serve different business purposes. Then, you can build a flexible and secure database development process and an enterprise-specific database DevOps process.

Feature Description
Design schemas Allows you to change schemas in a convenient and standardized manner.
Change data Allows you to execute SQL statements on the SQLConsole tab or submit tickets to change data.
Generate test data Allows you to generate a large amount of information at a time, such as random values, region names, and virtual IP addresses. This offloads your burdens of preparing test data.
Change schemas without locking tables Helps you prevent your business from being affected by table locks due to schema changes. This also minimizes the latency in synchronization between primary and secondary databases that occurs when schemas are changed by using native online data definition language (DDL) operations.
Change data without the need to lock tables Allows you to change data in batches based on the primary key or a non-null unique index in a table. This ensures high execution efficiency and minimizes the impact on database performance and capacity.
Audit operations Allows you to query a list of operations that are performed on a database or the details of each operation. The details of each operation contain information about the user who performed the operation and the time at which the operation was performed. DMS stores all the records of data queries and changes in operations logs.

Data security solutions

Data is the core asset of an enterprise. As such, data security is a top priority for enterprise management. Traditional data security solutions have the following issues:
  • A large number of developers use accounts and passwords to connect to databases.
  • Database passwords must be regularly updated to meet security and compliance requirements because employees may resign or are assigned to different jobs. This increases management costs.
  • Business data is easy to export, which puts the data at risk of being leaked.
  • Slow SQL queries compromise the efficiency of databases or even cause database failures.
  • Operation audit is costly and difficult.

To resolve the preceding issues, DMS data security solutions provide the features that are described in the following table.

Feature Description
Manage permissions Allows you to implement fine-grained permission management and limit access to database accounts and passwords.
Manage sensitive data Allows you to define fields that contain sensitive and confidential data, such as mobile phone numbers, as sensitive fields. This provides column-level data protection for tables.
Enforce row-level access control Provides row-level data protection for tables.
Perform access control Allows you to grant different permissions to users. Users have access only to the databases or instances on which they have permissions. This minimizes unnecessary data exposure.
Customize approval processes for permission applications Allows you to customize approval processes for different permission applications.

Data development solutions

DMS provides powerful kernel features to help you develop, analyze, and visualize data and perform data mining with ease.

Feature Description
Task orchestration Allows you to create one or more task nodes to form a task flow. You can use this feature to perform data archiving, data integration, data development in data warehouses, and data mining.
Data service Allows you to call API operations to export the data that is managed by DMS to external environments.
Data visualization Allows you to use custom layouts and styles and provides bountiful visualization components and built-in auxiliary widgets. This helps you visualize data with ease.