Data Management (DMS) provides three control modes for you to manage instances. You can configure the control mode for each database instance.

Overview

Control mode Description Scenario Access method
Flexible Management
  • Allows you to manage data and schema for over 27 types of databases in a visualized manner.
  • Allows you to modify data and schema by using SQL statements or by performing visualized operations on the SQL Console page.
  • Has limits on data management features. For more information, see Features supported by each control mode.
  • The database instance does not require strict control.
  • The database instance is used by a single user.
Log on to the database instance by using an account and a password.
  • DMS administrators and database administrators (DBAs): Log on to the database instance by using an account and a password.
  • Regular users: Before you log on to the database instance by using an account and a password, you must have the logon permissions on the database instance. For more information, see Permission management.
Note The account and password are managed by relevant persons in your enterprise.
Stable Change
  • Supports all features that are included in Flexible Management mode and reduces limits on features such as data change. For more information, see Features supported by each control mode.
  • Provides solutions to allow databases to run more stably, such as lock-free changes and SQL review.
  • The database instance requires stability and a high level of continuous availability.
  • The database instance is used by a small-sized group that includes multiple users.
Log on to the database instance by using an account and a password.
  • DMS administrators and DBAs: Log on to the database instance by using an account and a password.
  • Regular users: Before you log on to the database instance by using an account and a password, you must have the logon permissions on the database instance. For more information, see Permission management.
Security Collaboration
  • Supports all features that are included in Flexible Management and Stable Change modes.
  • Provides the DevOps feature to help you customize design specifications, R&D processes, and approval processes.
  • Allows you to manage three fields of medium or high sensitivity level for free. You can manage sensitivity levels, configure de-identification rules, and grant users permissions on the fields.
  • The data security of the database instance needs to be ensured.
  • Strict control over development and change processes is required.
  • Compliant management is required for enterprises.
The database instance can be accessed without a logon if you have the required permissions.
  • DMS administrators and DBAs: Directly access the database instance.
  • Regular users: Before you access the database instance or a database or table of the database instance, you must have the access permissions.

Billing method

  • If a database instance is managed in Flexible Management mode, you can use it free of charge.
  • If a database instance is managed in Stable Change or Security Collaboration mode, specific fees are charged. Both subscription and pay-as-you-go billing methods are supported.

Configure the control mode of an instance

Features supported by each control mode

Category Feature Flexible Management Stable Change Security Collaboration
Data export Permission verification and process approval - - Y
Maximum number of rows exported for free per day 1 million 20 million Unlimited
Maximum number of concurrent tasks 1 Unlimited Unlimited
Maximum number of tables per export Unlimited Unlimited Unlimited
Maximum capacity of tables per export 10 GB Unlimited Unlimited
Task queue type Globally shared queue Exclusive queue Exclusive queue
Data import Maximum file size per import 0.1 GB 1 GB Unlimited
Task queue type Globally shared queue Exclusive queue Exclusive queue
Data security Access method The account and password that are used to connect to the database The account and password that are used to connect to the database Alibaba Cloud account authentication (without using database accounts or passwords)
Resource authorization granularity Permissions on the database instance and database accounts Permissions on the database instance and database accounts Permissions on databases, tables, columns, and rows
Operation authorization granularity - Permissions on features Permissions on the query, export, and change operations
Authorization period - - The authorization period can be customized. Permissions are automatically revoked after they expire.
Row-level data permission management N Y Y
Control over source IP addresses N Y: Source IP addresses must be controlled one by one. Y: This feature can be globally enabled only over office networks.
Operation audit Y: Only part of the feature is supported and SQL executions in the last week are audited. Y: Only part of the feature is supported and SQL executions in the last week are audited. Y: All operations in this module are audited.
Security rules N N Y
Sensitive data management Y: You are charged for using this feature. Fine-grained permission management is not supported. Y: You are charged for using this feature. Fine-grained permission management is not supported. Y: You are charged for using this feature. You can manage three fields of medium or high sensitivity level for free.
Data classification Y: You are charged for using this feature. You can enable this feature in the Sensitive Data module. Y: You are charged for using this feature. You can enable this feature in the Sensitive Data module. Y: You are charged for using this feature. You can enable this feature in the Sensitive Data module.
Proxy endpoints in data security protection Y Y Y
Risk identification before changes N Y Y
Risk management after changes N Y Y
Database stability assurance Data changes without locking tables N Y Y
Data tracking and rollback Binary log files in the past hour Unlimited. Batch download is supported. Unlimited. Batch download is supported.
SQL review N Y: Review rule configurations are supported, whereas process approvals are not supported. Y: Review rule configurations and process approvals are supported.
Database performance diagnosis and optimization Y Y Y
R&D efficiency improvement Collaborative R&D N Y Y
Cross-instance query N N Y
Automatic generation of test data Y: The upper limit per day is 1 million rows. Y: The upper limit per day is 20 million rows. Y: The upper limit per day is 20 million rows.
R&D process approval N Y Y: Customization is supported.
Logical database configuration N N Y
Database grouping N N Y
Operations on multiple tables Y Y Y
Scheduling of recurring data development task N N Y
SQL statements Y Y Y
Execution plans Y Y Y
Change of the character set Y Y Y
SQL console Table size threshold for full-table scan N N Y
N N Y
SQL query timeout and interruption N N Y
Limits on the number of rows queried per day N N Y
Limits on the number of queries per day N N Y
SQL statements that can be saved Y Y Y
Maximum number of rows returned per query 3,000 rows. Pagination is supported. 3,000 rows. Pagination is supported. 3,000 rows. You can specify whether to enable pagination.
Visualization of data query results Y Y Y
SQL formatting Y Y Y
Smart SQL completion Y Y Y
Schema management Schema comparison Y Y Y
Schema editing Y Y Y
Table schema synchronization Y Y Y
Database cloning Y Y N
Maximum number of data dictionaries exported 5 Unlimited Unlimited
Design specifications of table schemas N N Y
R&D process of table schemas Only tables in databases on which the current account has permissions support this feature. Only tables in databases on which the current account has permissions support this feature. Tables created by other accounts, in other databases, and in self-managed databases support this feature.
Schema version management Only tables in databases on which the current account has permissions support this feature. Only tables in databases on which the current account has permissions support this feature. Tables created by other accounts, in other databases, and in self-managed databases support this feature.
Code generator N N Y
Data dictionary synchronization N N Y
Topology - - Y
  • N: not supported
  • Y: supported
  • -: N/A