Overview of features for DBA users-Data Management-阿里云帮助中心

DMS provides database administrators (DBAs) with tools to register and govern database instances, define development standards, and grant controlled access to developers and O&M engineers.

Get started in the DMS console

Step 1: Register your database instances

Log on to the DMS console and register each database instance you want to manage. For details, see Instance management.

Step 2: Configure security rules

Security rules define your team's database development standards, allowed SQL patterns, and approval workflows. Configure rules for each instance based on your governance requirements.

Only instances managed in Security Collaboration mode support custom security rules.

See Manage security rules and Configure approval processes.

Step 3: Grant user permissions

Grant developers, O&M engineers, and other users access to specific databases and tables. For details, see Permissions.

Features available to DBAs

The following table lists all DMS features available to the DBA role, organized by category.

Category	Feature	Description
Data assets	Instance management	Register, view, and edit database instances.
Data assets	Asset categories	Classify tables to help administrators, developers, and O&M engineers better manage or use the data tables.
SQL Window	Single-database query	Manually write SQL statements to query a single database. This is useful for scenarios such as validating data after business code is published, analyzing product performance data, and troubleshooting online issues.
	Cross-database query	Provides timely join query services for online disparate data sources across different environments.
	Logical data warehouse	Provides fast data analytics, access services, and cross-database queries.
Database development	Schema design	Change schemas by creating or modifying tables for new projects, new requirements, or optimizations. Use the schema design feature in DMS for these operations.
	Database and table synchronization	Compare table schemas between different environments, such as staging and production environments, to ensure schema consistency.
	Data change	Change data to meet requirements such as data initialization for new releases, historical data cleanup, issue fixing, and testing.
	Data import	Import data to a database in batches.
	Data export	Export data for large-scale data analytics or data extraction.
	Data tracking	If data becomes incorrect due to misoperations, use data tracking to quickly restore the data to a normal state.
	Test data generation	Test data structures ensure data security, preserve data discreteness, and improve production efficiency in frequent Data Preparation processes.
	SQL review	Avoid SQL statements that have no indexes or are non-standard to reduce the risk of SQL injection.
	Database clone	Clone MySQL databases.
Integration and development (DTS)	Data warehouse development	Uses a database as the primary compute engine and integrates various tools and services in the database ecosystem, such as DTS and Data Lake Analytics (DLA). This lets you easily develop and manage a data warehouse.
	Task orchestration	Orchestrate various tasks for scheduled execution. Create a task flow that consists of one or more task nodes to implement complex task scheduling and improve data development efficiency.
	Offline integration	A low-code data development tool that combines various task nodes to form a data stream. Use recurring schedules to run the stream for data transformation and data synchronization.
	Offline integration
	DataService Studio	Provides features such as minimum granularity data output, visualization creation, and sales on Alibaba Cloud Marketplace.
Security and specifications	Security rules	Configure security rules to ensure that all SQL statements are checked against the rules before execution. Only the statements that pass the check can be executed.
	Approval flows	Approval flows are associated with security rules. Select different approval flows based on user behaviors.
	Operation logs	Operation logs save data change records. You can trace information such as the change time, the user who made the change, and the operation that was performed.
	Sensitive data management	Manage sensitive data in tables by adding algorithms, adjusting security levels, and performing other operations.
	Data watermarking	Embed watermarks in files or extract watermarks from files to trace the source during data distribution.
	Enable secure access proxy	Use standard protocols such as MySQL and HTTPS to directly connect to the proxy address of a database instance generated by the secure access proxy. This ensures secure access to the database.
	Data Security Guard	Data Security Guard periodically assesses the security of data assets from multiple perspectives and generates security reports.
	Permission Management	Request permissions on instances, databases, tables, and sensitive columns. You can also view your permissions.
Solutions	Data archiving	Archive data from large tables to other databases on a schedule. This feature also supports source table data deletion, tablespace cleanup, and space reclamation.
	One-click data warehousing	Create a real-time data warehouse with one click. Data is synchronized to an AnalyticDB for MySQL database with a latency of seconds.
	Database migration	Create a ticket to implement a closed-loop operation of database migration, checksum, and cleanup.
Operations management	Notification management	Subscribe to message events of different feature modules and specify notification recipients and scopes for different features and events as needed.
	Database groups	Quickly load all databases in a created database group during a SQL change or schema design.
	Task management	Create, start, stop, and perform other operations on tasks.
	Intelligent O&M	View overall information about tickets, queries, users, and metadata.
Tickets	Ticket Management	DMS provides in-product ticket approval and ticket execution status notifications. Notifications can be sent through DingTalk and email.