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