This topic describes the release notes for Data Management (DMS) in 2020 and provides links to the relevant references.

December 2020

Feature Type Description References
The features in the top navigation bar can be customized. New You can add your frequently used features to the top navigation bar. This allows you to use these features with ease. Configure the DMS console based on your business requirements
The shadow table synchronization feature is supported. New DMS provides the shadow table synchronization feature to automatically create a shadow table based on the schema of a source table. DMS generates the name of the shadow table by attaching a prefix or suffix to the name of the source table. You can use this feature for end-to-end stress testing. Synchronize shadow tables
Validity periods can be configured for the maximum number of queries and the maximum number of rows that can be queried. Optimized When you manage users, you can configure the validity periods for the maximum number of queries that a user can perform and the maximum number of rows that can be queried. This allows you to restrict queries in a short time period. Manage users
SQL templates are provided. Optimized SQL templates are provided in the right-side panel of the SQLConsole tab. A large number of common scripts such as SQL statements, programmable objects, and functions are provided.SQL Template Overview
User permissions on MariaDB databases can be managed in DMS. New DMS allows you to manage user permissions on MariaDB databases. Manage user permissions on MySQL databases
User permissions on AnalyticDB for MySQL databases can be managed in DMS. New DMS allows you to manage AnalyticDB for MySQL databases and user permissions on the databases. Manage user permissions on MySQL databases
The schema design feature is optimized. Optimized The GUI that is used for schema design is improved. N/A
The task orchestration feature is optimized. Optimized You can view the status statistics about task flows and the task flow list on the homepage of the Task Orchestration tab. You can also create a task flow from a template. Configure a task flow
The notification feature is optimized. Optimized By default, the notification feature is enabled. This allows relevant contacts to receive notifications at the earliest opportunity. Manage notification rules

November 2020

Feature Type Description References
The operation audit feature is optimized. Optimized DMS provides the operation audit feature in addition to the basic features of operation log management. You can use the operation audit feature to view and manage tickets, logon information, operation logs, and the SQL statements that were executed in the SQLConsole. You can also use the operation audit feature to troubleshoot database issues with ease and audit the operations that were performed on databases. Audit operations
Optimization suggestions are provided in the SQL review feature. New After you submit SQL statements for data changes or on the SQLConsole tab, DMS reviews the submitted SQL statements based on the specifications in security rules and provides optimization suggestions. This can help you review SQL statements and optimize the submitted SQL statements before data changes are submitted. This can also prevent database exceptions from being caused by SQL statements that have potential issues. SQL review optimization
ApsaraDB for Lindorm and ApsaraDB for Cassandra databases are supported. New DMS allows you to manage ApsaraDB for Lindorm and ApsaraDB for Cassandra databases in a centralized manner. You can register ApsaraDB for Lindorm and ApsaraDB for Cassandra instances with DMS. You can also manage permissions and sensitive fields, query data by executing SQL statements, and update data in the databases. Supported database types and features
DMS can be accessed by using Alibaba Cloud Security Token Service (STS) tokens. New You can use STS to assign a token to a self-managed O&M platform. Then, the platform can access databases that are managed in DMS without logon. N/A

October 2020

Feature Type Description References
The data import feature is optimized. Optimized You can select the import mode, the type of CSV file, or the execution policy as needed. This can improve the efficiency of data import. Import data
DMS Database Lab is available on the Alibaba Cloud International site (alibabacloud.com). New DMS Database Lab is available on the Alibaba Cloud International site (alibabacloud.com). Overview of DMS Database Lab

September 2020

Feature Type Description References
The notification feature is supported. New
  • DMS supports a variety of notification methods, such as DingTalk notifications, text messages, emails, and DingTalk chatbot messages.
  • DMS can send notifications about the status updates of tickets and task flows to users.
Manage notification rules

August 2020

Feature Type Description References
The metadata access control feature is supported. New After you enable the metadata access control feature for an instance or a database, only authorized users can view metadata of the instance or database. This further enhances data security. Metadata access control
Tickets and the SQLConsole tab of databases can be shared. Optimized DMS allows you to share the SQLConsole tab of a database or a ticket with other users by generating a share link. This enhances the efficiency of a business team. Share the SQLConsole tab or a ticket
The database grouping feature is supported. New DMS allows you to add databases that are of the same engine type and deployed in the same environment to a database group. Then, you can apply a data change or a schema change to the databases at a time. Database grouping