Data Management (DMS) allows you to manage databases in a centralized manner. In DMS, you can manage relational databases such as MySQL, SQL Server, PostgreSQL, PolarDB for MySQL, PolarDB for PostgreSQL, PolarDB O Edition, PolarDB-X, OceanBase, and Oracle databases. You can also manage online analytical processing (OLAP) databases such as AnalyticDB, Data Lake Analytics (DLA), and ClickHouse databases, and NoSQL databases such as MongoDB and Redis databases. DMS is a comprehensive data management service that integrates data management, schema management, user authorization, security audit, trend analysis, and data tracking. You can use DMS to manage databases with ease. It enhances data security, improves management efficiency, and maximizes data value.

Scenarios

If employees in your enterprise use database accounts to connect to and manage databases, you are probably familiar with the following issues:

  • A user has queried your sensitive data or exported the data, but you cannot find out the exact user.
  • You cannot figure out how to prevent the data in an online environment from being tampered with.
  • Every time an employee quits the job, you must update all the user accounts and passwords.
  • A single misoperation causes deletion of all the data in an online environment.
  • A data definition language (DDL) statement that is poorly written impairs the performance of a database and interrupts business operations.
  • Database administrators (DBAs) do not have enough time to process data changes in databases. Therefore, the publishing of databases to the online environment is delayed. This results in complaints from business groups.
  • Inappropriate permissions are granted to database developers. This leads to operational faults and results in complaints from business groups.
  • DBAs who do low-value and repetitive work tend to quit their jobs. This leaves the databases unattended and results in complaints from business groups.

DMS allows tens of thousands of users to frequently query and update large numbers of tables in databases each day. Less than 1% of the operations require the approval of DBAs. The built-in rules of DMS ensure that more than 99% of the operations can be properly performed without the approval of DBAs.

Features

  • DMS supports the entire database development process. You can use DMS to design schemas in an offline environment, review SQL statements, and publish databases to an online environment.
  • DMS allows you to manage permissions at the field level. All operations on databases are synchronized to online environments and can be traced.
  • DMS allows you to configure different approval processes for different operations, such as schema design, data changes, and data export.
  • DMS integrates database development and interaction. When you manage databases in DMS, you do not need an account and a password to connect to a database or switch between multiple databases.
  • Employees can access databases after they log on to the DMS console and do not need an account for each database.
    • In the DMS console, employees can apply for the query, export, and change permissions on databases, tables, and fields. All the operations in the DMS console are recorded and can be audited and traced.
    • DMS allows you to set upper limits on user operations. For example, you can specify the maximum number of data rows that can be returned for each query. You can also specify the maximum number of data rows that each user can query per day or the maximum number of queries that each user can submit per day.
  • DMS automatically detects operational risks. DBAs can classify operations into safe and risky operations based on their approval experience, and configure different approval processes for these two types of operations.
    • Safe operations require simple or no approval processes. These operations are automatically scheduled for execution after relevant tickets are submitted or automatically approved.
    • Risky operations must be approved by DBAs before the operations are scheduled for execution.
    • DMS ensures correct SQL statements, identifies types of operations, schedules tasks for execution, and returns execution results, all in an automatic manner. DBAs do not need to monitor the system around the clock.

URL of the DMS console

dms.alibabacloud.com

DMS support group on DingTalk

For more help, scan the following QR code to join the DMS support group on DingTalk.

QR code