Data Management:Control modes

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.

DMS administrators, database administrators (DBAs), and regular users must be granted the logon permission on the database instance. Then, they can log on to the database instance by using an account and a password. For more information about how to obtain the permission to log on to a database instance, see Apply for permissions by submitting a ticket.

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.

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.

• 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.

Control mode

Billing method

Flexible Management

Free of charge

Stable Change and Security Collaboration

Specific fees are charged. Both subscription and pay-as-you-go billing methods are supported. For more information about pricing of DMS and how to purchase the DMS service, see Billable items and prices and Purchase the DMS service.

Category

Feature

Flexible Management

Stable Change

Security Collaboration

Instance management

Log on to a database instance

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)

Synchronize the data dictionary of a database instance

Y

Y

Y

Manage permissions on instances

N

N

Y

Configure an IP address whitelist

N

Y: Source IP addresses must be controlled one by one.

Y: This feature can be globally enabled only over office networks.

Enable metadata access control

N

N

Y

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

N

Y

Data export

Export SQL result sets

Y

Y

Y

Export databases

Y

Y

Y

Permission verification and process approval

-

-

Y

Maximum number of rows exported for free per day

1 million

20 million

Unlimited

Maximum number of tables per export

Unlimited

Unlimited

Unlimited

Maximum capacity of tables per export

10 GB

Unlimited

Unlimited

Security and specifications

Audit operations

Y: Only part of the feature is supported and SQL statements executed within seven days are audited.

Y: Only part of the feature is supported and SQL statements executed within seven days are audited.

Y: All operations in this module are audited.

Use data watermarks

Y

Y

Y

Manage sensitive data

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 enable this feature in the Sensitive Data module.

Manage security rules

N

N

Y

Database clone

Y

Y

N

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.

Schema changes

Design schemas

N

N

Y

Synchronize schemas

Y

Y

Y

Create shadow tables for synchronization

Y

Y

Y

Schema changes by using the lock-free DDL feature

N

Y

Y

Data changes

Change regular data

N

Y

Y

Perform lock-free DML operations

N

Y

Y

Historical data deletion

N

Y

Y

Change programmable objects by using stored routines

Y

Y

Y

Import data

Y

Y

Y

Risk identification before changes

N

Y

Y

Risk management after changes

N

Y

Y

Database stability assurance

Data tracking

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.

O&M management

Database grouping

N

N

Y

Metadata access control

N

N

Y

R&D efficiency improvement

Collaborative R&D

N

N

Y

Cross-instance query

N

N

Y

Automatic generation of test data

Y: A maximum of 1 million rows of data can be generated at a time.

Y: A maximum of 100 million rows of data can be generated at a time.

Y: A maximum of 100 million rows of data can be generated at a time.

R&D process approval

N

N

Y: Customization is supported.

Logical database configuration

N

N

Y

Operations on multiple tables

Y

Y

Y

Scheduling of recurring data development task

N

N

Y

SQL console

Query and change a schema

Y

-

Y

Use the super SQL mode

N

N

Y

Manage schema versions

Y

Y

Y

Adjust the sensitivity level of one or more fields

Y

Y

Y

Check the data quality

N

N

Y

Query data across multiple database instances

N

N

Y: This feature is supported after the cross-database query feature is enabled.

Database performance diagnosis and optimization

Y

Y

Y

SQL statements

Y

Y

Y

Execution plans

Y

Y

Y

Change of the character set

Y

Y

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

N

Y

Table size threshold for full-table scan

N

N

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

Maximum number of data dictionaries exported

5

Unlimited

Unlimited

Design specifications of table schemas

N

N

Y

R&D process of table schemas

N

N

Tables created by other accounts, in other databases, and in self-managed databases support this feature.

Manage schema versions

Three database versions can be retained.

Twenty database versions can be retained.

Fifty database versions can be retained.

Code generator

N

N

Y

Data dictionary synchronization

N

N

Y

Topologies

-

-

Y