All Products
Search
Document Center

Features

Last Updated: Jun 06, 2019

Data Management Service (DMS) allows you to manage Linux servers, NoSQL databases, and relational databases, such as MySQL, SQL Server, PostgreSQL, MongoDB, and Redis. It is an all-in-one data management service that supports data management, structure management, access control, data charts, data trends, data trace, performance trends and optimization, and server management.

Relational databases

  • Data management: supports SQL window, SQL command lines, table management, SQL syntax checker, SQL statement beautification, custom SQL scripts, SQL templates, SQL execution plans, and import and export.

  • Structure management: supports table structure comparison and object management based on databases, tables, views, functions, storage processes, triggers, transactions, sequences and synonyms.

  • Performance and optimization: supports displaying of performance, real-time SQL index suggestions, graphical lock management, instance session management, and diagnosis reports.

  • Data trace: supports more flexible row and column changes tracing and database, table, and row restoration.

  • Data trend: supports visualized real-time monitoring and historical data trend for operations including reading, adding, deleting, and updating of rows in tables.

  • Access control: supports 4-layer authentication, including login and operation audit, account authorization, IP address authrization, and feature-level authrization.

NoSQL

  • Data management: supports the query window and command window.

  • Structure management: supports object management, including databases, documents, and indexes.

  • Real-time performance displaying: collects performance metrics in real time.

Feature diagram

The features of DMS are shown in the following diagram:

Feature diagram