All Products
Search
Document Center

Introduction

Last Updated: Dec 26, 2019

To use Data Management (DMS) Enterprise, click https://dms.alibabacloud.com.

  • Are your employees still using a database account to directly operate the database?

    • If so, you may have encountered the following issues:
      • Cannot figure out who has viewed or exported your sensitive data without authorization.
      • Unable to prevent online data from being tampered with.
      • Have to update the passwords of all related accounts once an employee leaves office.
      • Online data gets wiped out because of a misoperation.
      • A random data definition language (DDL) statement causes a sharp drop in database performance and leads to service unavailability.
  • Do all database changes in your enterprise need to be performed by database administrators (DBAs)?

    • If so, you may have encountered the following issues:
      • The version release is postponed because DBAs cannot perform database changes in a timely manner, resulting in complaints from the business party.
      • Unexpected issues occur after improper permissions are granted to R&D engineers, resulting in complaints from the business party.
      • DBA turnover due to low-value and repetitive work cuts off the support for your business, resulting in complaints from the business party.

Features of DMS Enterprise

    1. Users can use the DMS Enterprise console to access databases in a uniform way, freeing them from using a database account and password to log on to databases.
      • Users need to submit a ticket in the DMS Enterprise console to apply for the permission to query, export, or change the target database, table, or column. Permissions are granted only after the ticket is approved. All operations can be audited and backtracked.
      • For each user, you can flexibly specify the maximum number of rows returned in a single query, the maximum number of rows queried per day, and the maximum times of queries per day.
    1. DMS Enterprise automatically detects risks of database changes. DBAs can develop specifications based on statistics to manage database changes by risk level.
      • For database changes without risks, R&D engineers can configure the system to perform the changes at the scheduled time after the changes are directly approved or go through a lightweight approval process.
      • For database changes with risks, R&D engineers can configure the system to perform the changes at the scheduled time after the changes are audited and approved by DBAs.
      • The system supports automatic guarantee of syntax correctness, automatic identification of change types, timed scheduling, and intelligent generation of execution results.

DMS Enterprise allows you to manage various relational databases, such as MySQL, SQL Server, PostgreSQL, Oracle, MongoDB, and OceanBase, as well as NoSQL databases. It is an all-in-one data management service that supports data management, schema management, R&D, user management, permission management, and access control. It has the following features:

  • Provides a complete database R&D process from schema design in an offline environment, SQL review, and then to production and publishing.
  • Provides fine-grained control over operation permissions at the field level. All user operations are online and traceable.
  • Supports flexible customization of approval processes for business-specific operations, including schema design, data change, and data export.
  • Allows R&D engineers to interact with databases in a uniform way. Users no longer need to directly use a database account and password to log on to databases, nor do they need to frequently switch database connections.

As a crystal of more than ten years of accumulation in terms of database management, Alibaba Cloud DMS Enterprise supports database access and changes in large magnitude. It allows a maximum of tens of thousands of users to perform concurrent operations on databases and tables every day. In addition, database changes that require DBA intervention may not exceed 1% of the total. More than 99% of database changes can be executed by R&D engineers under the protection of security rules.

We recommend that you choose DMS Enterprise to manage your large-scale databases in a secure and efficient manner as Alibaba. To use DMS Enterprise, click https://dms.aliyun.com/.

You can scan the QR code below to join the official DingTalk group for support.DingTalk group QR code