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:
