All Products
Document Center

Data Management:Overview

Last Updated:Feb 22, 2024

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 manage all database resources within your enterprise in a centralized manner. 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.



Design schemas

Allows you to change schemas in a convenient and standardized manner.

Regular data change

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.

Lock-free schema changes

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 DDL operations.

Perform lock-free data change

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.

Use the operation audit feature

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 operation 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 the 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.



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.

Row-level access control

Provides row-level data protection for tables.

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.



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.