The database development module of Data Management (DMS) covers the full lifecycle of database changes — from designing and synchronizing schemas to modifying data, reviewing SQL, and orchestrating multi-step deployments through DevOps pipelines.
Feature categories
| Feature | Subfeature | Description |
|---|---|---|
| Schema change | Design schemas | Design table schemas based on R&D standards to keep schemas consistent across environments such as development, test, and production environments. |
| Synchronize schemas | Compare schemas between two databases or specific tables and generate SQL statements for schema synchronization. | |
| Create shadow tables for synchronization | Automatically create a shadow table based on the schema of a source table. Regular synchronization is supported. | |
| Initialize empty databases | Synchronize the schemas of a source database to an empty database. | |
| Repair table inconsistency | Compare table schemas, identify differences, and generate SQL statements to bring the destination table into sync. | |
| Perform lock-free DDL operations | Run DDL operations without locking tables, preventing business interruptions and avoiding the replication latency that native online DDL can introduce between primary and secondary databases. | |
| Data change | Change regular data | Update data in databases. |
| Perform lock-free DML operations | Run DML operations in batches based on a primary key or a non-null unique key, maintaining high execution efficiency with minimal impact on database performance and storage. | |
| Clear historical data | Create a scheduled task to delete historical data automatically based on configured rules on a regular basis. | |
| Change programmable objects by using stored routines | Submit tickets to change programmable objects such as stored procedures, triggers, functions, and views. | |
| Import data | Import large volumes of data into a database. | |
| Data export | Export SQL result sets | Export SQL result sets. |
| Export databases | Export databases and tables. | |
| SQL review | N/A | Reviews submitted SQL statements and provides suggestions to optimize the statements. SQL review checks for: conformance to database development standards, whether indexes are used for queries, and SQL injection risks — helping maintain high-quality code. |
| Environment setup | Clone databases | Replicate the schema and data of a database or table to another database or table, and initialize databases across multiple environments. |
| Generate test data | Generate test data based on specified field types and rules. | |
| Data tracking | N/A | Parse database binary logs, query data change records, and generate SQL statements for data restoration. |
| DevOps | N/A | Combine multiple data change tickets — including Normal Data Modify, Lockless change, and Data Import — into a single process. DevOps lets you mix DML and DDL operations to meet your business requirements. |