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 |
|
|
Log on to the database instance by using an account and a password.
Note The account and password are managed by relevant persons in your enterprise.
|
Stable Change |
|
|
Log on to the database instance by using an account and a password.
|
Security Collaboration |
|
|
The database instance can be accessed without a logon if you have the required 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.
- Subscription: For more information, see Subscription.
- Pay-as-you-go: For more information, see Billing items.
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