Data Management:Control modes

Control mode

Description

Scenario

Billing rule

Flexible Management

• Allows you to manage data and schema for over 30 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.

• The database instance does not require strict control.

• The database instance is used by a single user.

• Tickets are exempt from approval.

Free of charge.

Stable Change

• Supports all features that are included in Flexible Management mode and reduces limits on features such as data change.

• 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 managed by a small group of developers.

Fees are charged.

Both subscription and pay-as-you-go billing methods are supported. For more information, see the Billable items and prices section of the "Pricing" topic and Purchase the DMS service.

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 R&D and change processes is required.

• The database instance is managed by a large group of developers.

• Compliant management is required for enterprises.

Type

Feature

Flexible Management

Stable Change

Security Collaboration

Instance management

Instance logon

A database account and password are required for instance logon.

Alibaba Cloud account authentication is supported for password-free logon.

Data dictionary synchronization

Y

Y

Y

Instance permission management

N

Y

Access IP whitelist

Y

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

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

Metadata access control

N

N

Y

Resource authorization granularity

You can grant permissions to database accounts on database instances.

You can grant permissions on databases, tables, columns, and rows.

Operation authorization granularity

-

You can grant permissions on features.

You can grant 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

SQL result set export

Y

Y

Y

Database export

Y

Y

Y

Permission verification and process approval

-

-

Y

Maximum number of rows exported for free per day

One 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

Operation audit

Y: You can view logs of the previous day.

Y: Logs are retained for three years. You can access and view logs at any time during the three-year period.

Data watermark

Y

Y

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

Security rule management

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 change

Schema design

N

N

Y

Schema synchronization

Y

Y

Y

Shadow table synchronization

Y

Y

Y

Lock-free DDL operations

N

Y

Y

Data change

Normal data change

N

Y

Y

Lock-free DML operations

N

Y

Y

Historical data deletion

N

Y

Y

Programmable object change

Y

Y

Y

Data import

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 within the previous 1 hour can be tracked and downloaded.

Unlimited. Batch download is supported.

Unlimited. Batch download is supported.

SQL review

Y: Review rule configurations are supported, whereas process approvals are not supported.

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 one 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: You can customize an approval process based on your business requirements.

Logical database configuration

N

N

Y

Operations on multiple tables

Y

Y

Y

Scheduling of recurring data development task

N

N

Y

SQL console

Schema query and change

Y

-

Y

Super SQL mode

N

Y

Y

Schema version management

Y

Y

Y

Field sensitivity level adjustment

Y

Y

Y

Data quality check

N

N

Y

Cross-database query

Y

Y

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

SQL result set copies

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

Frequently used SQL statement management

Y

Y

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

Intelligent SQL prompts

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.

Schema version management

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

Topology

-

-

Y