Data Management

An integrated data management solution supporting structure management, user authorization, security auditing, trend analysis, and data tracing.

Data Management (DMS) provides an integrated solution for data management, which includes features such as data management, structure management, user authorization, security auditing, trend analysis, and data tracing. The service supports relational databases such as MySQL, SQL Server, PostgreSQL, PPAS, and Petadata, NoSQL databases such as MongoDB and Redis, OLTP databases such as DRDS, and OLAP databases such as AnalyticDB and Data Lake Analytics (DLA). Using DMS, you can efficiently manage your data and discover data values.

Benefits

Secure Data Communication
Supports managing large volumes of data and offers security mechanisms such as cloud account authorization and security auditing.
Multiple Data Sources
Supports relational databases, NoSQL databases, and OLAP databases.
Improved R&D Efficiency
Provides a graphical interface for data management. Allows you to reuse SQL statements and save SQL windows.
Powerful Analytical Capability
Supports data tracing and rollback of MySQL databases to a specified time.

Features

Easy to Use GUI

View and edit your data through a GUI

Easy table management

You can edit tables using an Excel-like interface. No SQL coding is required to modify tables or perform analytical tasks.

Table Structure Visualization

Efficient metadata management

Document generation

You can easily generate all table structures in the database and export them to Word, Excel, or PDF files.

SQL Statement Reuse

You can save SQL windows and commonly used SQL statements for future use.

SQL statement management

You can save commonly used SQL statements and reuse them when you are managing other databases.

SQL window management

The SQL window you are working on is automatically saved in real time. You can close it and continue to edit your code later.

Scenarios

  • Database Clone
  • Table Structure Comparison
Data Tracing and Rollback

Data Tracing and Rollback

Provides data change history to help data recovery

Data is an important asset of any business. Programming bugs and misoperations can easily lead to unexpected data changes when you perform data operations. Previously, it was difficult to determine when changes occur for data recovery. DMS supports data tracing and rollback features, which allow you to find out logs that are related to changes to the entire database, certain tables, or even certain data records. You can then restore the data to its original status before the misoperation.

Benefits

  • Accidental updates

    DMS allows you to rollback the database to a specified time if accidental updates occur.

  • Accidental deletion

    DMS allows you to restore your data if accidental deletion occurs.

  • Data change history

    The data tracing feature enables you to find the operations that have been performed on your data.

Database Clone

Database Clone

Quickly copy table structures or data from the source database to the target database

When you set up a new testing or production environment, you need to copy table structures and initial data from the source database to the target database. Previously, you needed to log on to different databases multiple times to export and import data. Now, you can use the graphical interface provided by DMS to efficiently perform data migration.

Benefits

  • Set up a testing database

    DMS allows you to copy table structures so that you can quickly set up database environments.

  • Deploy databases in new regions

    As your business grows, you need to deploy your application and database service in new regions. You can use DMS to speed up the deployment process.

Table Structure Comparison

Table Structure Comparison

Maintain consistent table structures across multiple environments

The functionalities of a database service must be verified in the testing environment before you can deploy the service to the production environment. If the test and production databases have different table structures, failures may occur. DMS provides the table structure comparison feature, which allows you to quickly find the differences between table structures.

Benefits

  • Table structure comparison between the production and test database

    You can use DMS to check whether the production and test database have different table structures after the system has been running.

  • Table structure comparison between the development and test database

    After new features are introduced for testing, you can use DMS to maintain consistent table structures between the test and development database.