This topic describes the database types that are supported by Data Management (DMS) and the DMS features that are supported by each database type.

Supported database types

  • Relational databases:
    • MySQL: ApsaraDB RDS for MySQL, PolarDB for MySQL, MyBase for MySQL, PolarDB-X, and other MySQL databases
    • SQL Server: ApsaraDB RDS for SQL Server, MyBase for SQL Server, and other SQL Server databases
    • PostgreSQL: ApsaraDB RDS for PostgreSQL, PolarDB for PostgreSQL, MyBase for PostgreSQL, and other PostgreSQL databases
    • MariaDB: ApsaraDB for MariaDB TX and other MariaDB databases
    • OceanBase: ApsaraDB for OceanBase in MySQL mode, ApsaraDB for OceanBase in Oracle mode, and self-managed OceanBase databases
    • PolarDB-O
    • Self-managed Oracle
    • DamengDB
    • IBM Db2
  • NoSQL databases:
    • Redis: ApsaraDB for Redis, MyBase for Redis, and other Redis databases
    • MongoDB: ApsaraDB for MongoDB and other MongoDB databases
    • ApsaraDB for Lindorm
    • ApsaraDB for Cassandra
    • Graph Database
  • Data warehouses, Hologres, and OSS:
    • AnalyticDB for MySQL
    • AnalyticDB for PostgreSQL
    • Data Lake Analytics
    • ClickHouse: ApsaraDB for ClickHouse and other ClickHouse databases
    • MaxCompute
  • Hologres
  • Object Storage Service
Note Other databases refer to databases from other cloud service providers or self-managed databases.

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.

Feature MySQL (except PolarDB-X) PolarDB-X SQL Server PostgreSQL (except PolarDB for PostgreSQL) PolarDB for PostgreSQL MariaDB ApsaraDB OceanBase for MySQL Self-managed Oracle and ApsaraDB OceanBase for Oracle PolarDB-O DM Db2
Query ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Query on logical databases or tables ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Cross-database query ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
SQL result set export ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Table data export ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data change ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Historical data cleaning ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Lockless data change ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data import ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Test data generation ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data tracking ✔️
Database cloning ✔️ ✔️ ✔️ ✔️
Schema change ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Visualized schema modification ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Schema synchronization ✔️ ✔️ ✔️ ✔️
Empty database initialization ✔️ ✔️ ✔️ ✔️
Programmable object ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Schema export ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Schema design pro ✔️ ✔️ ✔️
Lockless schema change ✔️
Database creation ✔️ ✔️
Database user creation ✔️ ✔️
SQL review ✔️ ✔️ ✔️ ✔️
SQL and instance diagnostics ✔️ ✔️ ✔️ ✔️
Sensitive data management ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Access control system ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Operation 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.

Feature MongoDB Redis Lindorm Cassandra GDB
Query ✔️ ✔️ ✔️ ✔️ ✔️
Cross-database query ✔️
SQL result set 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 ✔️ ✔️ ✔️ ✔️ ✔️
Operation log ✔️ ✔️ ✔️ ✔️ ✔️
Ticket system ✔️ ✔️ ✔️ ✔️ ✔️
Security rule ✔️ ✔️ ✔️ ✔️ ✔️
Approval process ✔️ ✔️ ✔️ ✔️ ✔️

Data warehouses, Hologres, and OSS

The following table describes the features that are supported by data warehouses, Hologres, and OSS.

Feature AnalyticDB for MySQL V2.0 AnalyticDB for MySQL V3.0 AnalyticDB for PostgreSQL ClickHouse DLA MaxCompute and Hologres OSS
Query ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Query on logical databases or tables ✔️ ✔️
Cross-database query ✔️ ✔️
SQL result set export ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Table data export ✔️ ✔️
Data change ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data import ✔️ ✔️ ✔️
Test data generation ✔️ ✔️ ✔️
Database cloning
Schema change ✔️ ✔️ ✔️ ✔️
Visualized schema modification ✔️ ✔️
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 ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Operation log ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data service ✔️ ✔️ ✔️ ✔️ ✔️
Data visualization ✔️ ✔️ ✔️ ✔️ ✔️
Task orchestration ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data warehouse development ✔️ ✔️ ✔️
Ticket system ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Security rule ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Approval process ✔️ ✔️ ✔️ ✔️ ✔️ ✔️