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