All Products
Search
Document Center

Overview

Last Updated: Jun 07, 2019

This section describes how to operate and manage DMS in a relational database.

DMS console

The homepage of a relational database is displayed, as shown below:

Homepage overview

Function modules are listed in the following table.

No. Module Name Description
1 Top menu bar You can access the main function modules of Data Management Service (DMS).
2 Drop-down list for database switching You can select a database from the list to access the tables and data objects in that database.
3 Navigation buttons for database objects You can switch among tables, views, and programmable objects such as functions, stored procedures, triggers, and events.
4 Table search box You can quickly find the expected table through fuzzy match.
5 DMS object list You can view the details of database objects such as tables.
6 DMS function module menu You can use a specific function of the database.
7 Instance health status report The report shows the current health status of the database service.

Supported databases

  • DMS for MySQL

  • DMS for SQL Server

  • DMS for PostgreSQL/PPAS

Supported database operations

  • SQL operations

    • SQL window

    • SQL command window

    • Save work environments

    • SQL execution

    • SQL optimization

    • SQL formatting (SQL statement improvement)

    • View schedulers

    • SQL input prompt

  • Operations on database objects

    • Operate data tables.

    • Operate table structures: Add table, modify structure, and drop table.

    • Change table data: Insert, update, and delete data.

    • Query and edit table data visually.

  • Operations on views and programmable objects, such as functions, stored procedures, triggers, and events

    • Add

    • Modify

    • Delete

    • Enable or Disable

  • Data processing

    • Import Data

    • Export Data

    • Compare table structures

    • Analyze data and report

  • Performance and diagnosis

    • Real-time performance

    • Real-time session

    • Lock-wait analysis

    • Diagnostic report

  • Data processing tools

    • ER diagram

    • Statistics on table data volume

    • Batch table operations

    • Generate data dictionary documentation

  • Security & Audit

    • Authorization

    • Access audit

Effective user interaction

These operations are easy to perform. Even when an error occurs, you can still complete data operation by following improvement instructions.