Data Management (DMS) unifies database development, security, and operations in one console with standardized change processes, approval workflows, and fine-grained access controls.
Database change management
Define development standards, change processes, and approval workflows per database instance based on its business role.
|
Feature |
Description |
|
Make schema changes through a standardized process. |
|
|
Run SQL statements on the SQLConsole tab or submit change tickets to modify data. |
|
|
Apply schema changes without table locks, reducing replication latency compared to native online DDL. |
|
|
Run data changes in batches by primary key or unique index to minimize performance and storage impact. |
|
|
Bulk-generate test data such as random values, region names, and virtual IP addresses without manual preparation. |
|
|
Track who performed each database operation and when. DMS logs all queries and changes. |
Data security
DMS mitigates common data security risks: credential exposure, unrestricted exports, performance-degrading queries, and costly manual auditing.
|
Feature |
Description |
|
Enforce fine-grained permissions and limit direct access to database accounts and passwords. |
|
|
Limit each user's access to specific databases or instances. |
|
|
Restrict data visibility at the row level within tables. |
|
|
Mark fields as sensitive to enable column-level protection. |
|
|
Define approval workflows for different types of permission requests. |
Data development
DMS includes a data development engine for analysis, visualization, and data mining.
|
Feature |
Description |
|
Compose task nodes into a flow for data archiving, integration, warehouse development, and mining. |