Limit Personnel Access of the Database

After logging on to DMS, permissions can be applied as needed. Therefore, operations will be sent to the database after initiation and authorization, personnel no longer use the database account and password.

Fine-grained Permission Management

Support on-demand application of database, table, field, and row-level data object operation permissions. Apply for query, export and change permissions according to different scenarios for related operations, which can be automatically recycled upon expiry, and rejected at source without permissions.

Data Security Assurance

The number of rows returned by each query, the total number of queries per day, and the total number of rows queried per day are controllable and auditable on demand to avoid the outflow of a large amount of data. Sensitive fields are marked on demand to avoid unnecessary data contact.

Data Query Performance Security

The query timeout and the full table scan threshold for large tables are configured on demand to avoid slow queries affecting the provision of database services.

Change Ability Without Table and Table Structure Locking

All DDL operations before MySQL5.6 and some operations after 5.6 cannot be changed without locking the table. Once the table is locked, it will directly affect the business. For historical data cleansing scenarios such as large batches, each business generally develops its own cleansing logic to avoid disrupting the business. While DMS solves the problem of wasted R&D and the difficulty of uniform management.

SQL Audit Preventing Bad SQL from Going Online

Before the code is tested, SQL text and XML files can be submitted for review to identify and deal with SQL injection, non-indexed SQL, and SQL that does not meet the writing specifications such as queries with non-specified field return and write non-specified fields, so as to avoid production failures caused by such bad SQL.

Change Stability Assurance

When the database is under high load, continuing to issue changes may cause the database to perform abnormally or even be unserviceable. Detection and protection before, during and after the change is the core guarantee for the smooth implementation of each change.

Data Tracing and Rollback

The DMS Security Collaboration control mode can easily manipulate million-class abnormal data recovery. It supports fast retrospective recovery of mastakenly updated data, which can effectively avoid erroneous data erasure and wrong update.

Development of Table Structure Design Specification and Multi-environment Table Structure Consistency Release Process

Support four types of databases: MySQL, PolarDB-MySQL, DRDS, and OceanBase, and can formulate design specifications and release processes that are flexible to the instance level ensuring that the table structure between multiple environments is completely consistent and avoiding faults caused by inconsistency.

Field-level Concurrent Collaboration Management

Different projects or daily iterations of the same business may have adjustment requirements for different fields. Compared to the traditional solution, A update affects B, B update affects A. The DMS Security Collaboration control mode enables "structural design", which supports A and B to be managed in separate tasks in complete isolation, without interfering with each other, and can be scheduled according to their respective needs, and can be released in iterations without hindrance.

Instance-level Security Rules

For traditional database management solutions, strictness can lead to a large number of approval operations for controllers, which can lead to errors and omissions due to approval fatigue. While looseness can lead to changes for everyone, resulting in completely uncontrollable production stability. The DMS Security Collaboration control mode ensures both the safe use of the database and the R&D efficiency of the enterprise. Support on-demand customization of design specifications, operating specifications and approval processes according to different database instances.

New Working Mode

It is difficult to train a full-time DBA, but with DMS, managers without a database related technical background can be easily empowered to be like a professional DBA by product's default configuration. Research and development personnel submit operations on demand using the product, automatic detection will be done according to security rules, to ensure the approval process and the stable implementation of changes, significantly reduce personnel costs and can effectively improve the R&D efficiency of enterprises.