All Products
Search
Document Center

Overview

Last Updated: Aug 28, 2020

This topic describes the graphical user interface (GUI) elements in the Data Management Service (DMS) console and features supported by DMS.

GUI elements

The following figure shows the GUI elements in the DMS console. GUI elements

The following table describes the GUI elements.

No. Element Description
1 Top navigation bar You can go to various functional modules of DMS.
2 Top search box You can enter a database or table name to search for the target database or table. You can use the percent sign (%) as placeholders to search for the database or table in fuzzy match mode.
3 Search box at the top of the left-side navigation pane You can enter the name, endpoint, or database link of an instance to quickly find the instance.
4 Positioning icon You can click this icon and set filter criteria to hide the instances that do not meet the filter criteria.
5 Add instance button You can select Add instance or Sync DMS instances to add your database.
6 DMS object list You can view the databases or tables that meet the specified filter criteria.
7 My Tickets section This section displays the information about tickets under your account.
8 Favorite Databases/Tables section This section displays the information about the databases and tables that you follow.
9 Owned Databases/Tables section This section displays the information about the databases and tables under your account.
10 Recently Used Databases section This section displays the information about recently used databases.
11 Accessible Databases/Tables section This section displays the databases and tables on which you have operation permissions.
12 Updates and Notifications section This section displays the latest news of DMS.
13 Quick Access section This section displays entrances to common database operations.

Supported database types

Online transaction processing (OLTP) databases, such as MySQL, SQL Server, PostgreSQL, PolarDB, Distributed Relational Database Service (DRDS), OceanBase, and Oracle

  • Online analytical processing (OLAP) databases, such as AnalyticDB

  • NoSQL databases, such as Redis and MongoDB

Supported database operations

  • SQL operations

    • SQL window.

    • SQL command window.

    • Save operating environment settings.

    • Execute SQL statements.

    • Optimize SQL statements.

    • Format and improve SQL statements.

    • View execution plans.

    • Provide SQL input prompts.

  • Operations on database objects

    • Operations on tables.

    • Operations on schemas: Create and delete tables and change schemas.

    • Changes to table data: Insert, update, and delete data.

    • Query and edit table data on the GUI.

  • 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 schemas.

    • Analyze data and generate reports.

  • Performance and diagnosis

    • Real-time monitoring

    • Instance sessions

    • Lock wait analysis

    • Diagnostic report

  • Data processing tools

    • E-R diagram

    • Statistics on table data volume

    • Operations on multiple tables

    • Generation of data dictionary documentation

  • Security and audit

    • Account and access source authorization

    • Access audit

User-friendly interactions

DMS provides user-friendly tips. When an error occurs, DMS displays suggestions on how best to complete your goal.