This topic describes database engines and features that Data Management (DMS) supports.

Database engines

DMS supports the following database engines:
  • Relational databases:
    • MySQL series: native MySQL, ApsaraDB RDS for MySQL, and PolarDB for MySQL
    • SQL ServerL series: native SQL Server and ApsaraDB RDS for SQL Server
    • Oracle series: native Oracle and ApsaraDB OceanBase for Oracle
    • MariaDB series: native MariaDB and ApsaraDB RDS for MariaDB
    • OceanBase MySQL
    • PostgreSQL
    • PolarDB-O
    • PolarDB PostgreSQL
    • PolarDB-X
    • PPAS
  • NoSQL databases:
    • Redis
    • MongoDB
    • HBase
    • Lindorm
    • Cassandra
  • Data warehouses:
    • AnalyticDB MySQL
    • AnalyticDB PostgreSQL
    • Data Lake Analytics (DLA)
    • ClickHouse
    • MaxCompute

Symbol description

This section describes the symbols that are used in the tables of this topic:

  • ✔️ Indicates that the feature is supported.
  • ➖ Indicates that the feature will be supported soon.
  • ❌ Indicates that the feature is not supported.

Relational databases

The following table describes the features that are supported by relational databases.

Database engine and feature MySQL series SQL Server series Oracle series PostgreSQL PolarDB-X (formerly known as DRDS) OceanBase MySQL PolarDB-O PolarDB PostgreSQL MariaDB series
Query ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Query on logical databases or tables ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Cross-database query ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Result export ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Table data export ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data change ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data cleaning ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Lock-free data change ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data import ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Test data generation ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data tracking ✔️
Database cloning ✔️ ✔️ ✔️ ✔️
Schema change ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Visualized schema editing ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Schema synchronization ✔️ ✔️ ✔️ ✔️
Empty database initialization ✔️ ✔️ ✔️ ✔️
Programmable object ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Schema export ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Schema design pro ✔️ ✔️ ✔️
Lock-free schema change ✔️
Database creation ✔️ ✔️
Database user creation ✔️ ✔️
SQL review ✔️ ✔️ ✔️ ✔️
SQL and instance diagnostics ✔️ ✔️ ✔️ ✔️
Sensitive data management ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Access control system ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Operations log ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data service ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data visualization ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Task orchestration ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data warehouse development ✔️ ✔️
Ticket system ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Security rule ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Approval process ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️

NoSQL databases

The following table describes the features that are supported by NoSQL databases.

Database engine and feature MongoDB Redis Hbase Lindorm Cassandra
Query ✔️ ✔️ ✔️ ✔️ ✔️
Cross-database query ✔️
Result export ✔️ ✔️ ✔️ ✔️
Table data export
Data change ✔️ ✔️ ✔️ ✔️ ✔️
Schema change ✔️ ✔️
Database creation ✔️
Database user creation ✔️
SQL review ✔️ ✔️
SQL and instance diagnostics ✔️ ✔️
Sensitive data management ✔️ ✔️ ✔️
Access control system ✔️ ✔️ ✔️ ✔️ ✔️
Operations log ✔️ ✔️ ✔️ ✔️ ✔️
Ticket system ✔️ ✔️ ✔️ ✔️ ✔️
Security rule ✔️ ✔️ ✔️ ✔️ ✔️
Approval process ✔️ ✔️ ✔️ ✔️ ✔️

Data warehouses

The following table describes the features that are supported by data warehouses.

Database engine and feature ADB2.0 ADB3.0-MySQL ADB-PostgreSQL Clickhouse DLA MaxCompute
Query ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Query on logical databases or tables ✔️ ✔️
Cross-database query ✔️ ✔️
Result export ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Table data export ✔️ ✔️
Data change ✔️ ✔️ ✔️ ✔️ ✔️
Data import ✔️ ✔️ ✔️
Test data generation ✔️ ✔️ ✔️
Database cloning
Schema change ✔️ ✔️ ✔️ ✔️
Visualized schema editing ✔️ ✔️
Schema synchronization ✔️
Empty database initialization ✔️
Programmable object ✔️
Schema export ✔️ ✔️ ✔️ ✔️
Schema design pro
Database creation
Database user creation
SQL review
Sensitive data management ✔️ ✔️ ✔️ ✔️
Access control system ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Operations log ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data service ✔️ ✔️ ✔️ ✔️
Data visualization ✔️ ✔️ ✔️ ✔️
Task orchestration ✔️ ✔️ ✔️ ✔️
Data warehouse development ✔️ ✔️ ✔️
Ticket system ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Security rule ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Approval process ✔️ ✔️ ✔️ ✔️ ✔️ ✔️