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

This topic describes the features available to database administrators (DBAs).

Getting started

Register a database instance. For more information, see Instance management.
Adjust security rules as needed, such as development standards, development flows, and approval flows for different instances. Only instances in the Security Collaboration control mode can be associated with security rules. For more information, see Security rules and Approval flows.
Grant database and table permissions to users. For more information, see Permission Management.

Overview of features for DBAs

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
	Data analysis	Provides typical datasets, dashboards, and large-screen models. Use a rich set of visual charts and widgets on dashboards or large screens to display data.
	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.