All Products
Search
Document Center

Common user manual

Last Updated: Jun 28, 2020

Operations

  1. Apply for permissions on instances, databases, and tables. For more information, see Permission management.
  2. After you obtain the permissions, you can execute SQL statements in the SQLConsole. You can also visualize and edit result sets. For more information, see Single-database query and Cross-database query.
  3. Perform data operations including change, import, and export operations. For more information, see Data change and Data export.

Supported features for common users

Category Feature Description
Permissions Permission management You can apply for permissions on instances, databases, tables, and sensitive fields. You can also view permissions that you have.
SQLConsol Single-database queries You can write SQL statements to query data in a single database. This feature can be used to verify business code, analyze product effect, and locate issues in an online environment.
Cross-database queries You can perform relational queries across online heterogeneous data sources deployed in different environments.
Schemas Schema design When you develop or optimize a project or process a new business requirement, you often need to change schemas. For example, you can use this feature when you create a table or modify an existing table.
Table synchronization You can use this feature to compare and synchronize the schemas of tables located in different environments, such as the online and offline environments, to guarantee the consistency of schemas.
Optimization SQL review You can use this feature to avoid publishing SQL statements that do not use indexes or do not conform to database development standards. This feature helps protect against SQL injection attacks.
Data plans Data changes You can submit data change tickets to initialize data for a newly published project, clean up historical data, fix bugs, or conduct a test.
Data import You can use this feature to import a large amount of data to your databases at a time.
Data export You can use this feature to extract a large amount of data for analysis.
Data tracking If any data fails to meet your requirement due to reasons such as misoperations, you can use this feature to quickly trace historical data changes. Then, you can execute rollback statements to quickly restore data to the normal state.
Test data generation You can generate test data to guarantee data security and discreteness and improve production efficiency when you need to prepare data frequently.
Data warehouse development DMS uses databases as the main computing engine and integrates various tools and services in the database ecosystem, such as Data Transmission Service (DTS) and Data Lake Analytics (DLA), for data warehouse development. Therefore, you can easily develop and manage data warehouses in DMS.
Data service You can use this feature to export data at the field or row level, display data in a visualized manner, and publish data in Alibaba Cloud Marketplace for sale through API calls.
Database clone This feature allows you to clone MySQL databases.