This topic describes the types of databases and the features that are supported by Data Management (DMS).

Supported database types

The following types of databases are supported:
  • Relational databases:
    • MySQL series: native MySQL, ApsaraDB RDS for MySQL, and PolarDB for MySQL
    • SQL Server 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 TX
    • Dameng (DM)
    • ApsaraDB OceanBase for MySQL
    • PostgreSQL
    • PolarDB-O
    • PolarDB for PostgreSQL
    • PolarDB-X
    • ApsaraDB RDS for PPAS
  • NoSQL databases:
    • ApsaraDB for Redis
    • ApsaraDB for MongoDB
    • ApsaraDB for HBase
    • ApsaraDB for Lindorm
    • ApsaraDB for Cassandra
  • Data warehouses:
    • AnalyticDB for MySQL
    • AnalyticDB for PostgreSQL
    • Data Lake Analytics (DLA)
    • ApsaraDB for ClickHouse
    • MaxCompute

Symbol description

To ease the description and your understanding, the following symbols 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 type or feature MySQL series SQL Server series Oracle series PostgreSQL PolarDB-X ApsaraDB OceanBase for MySQL PolarDB-O PolarDB for PostgreSQL MariaDB series DM
Query ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Query on logical databases or tables ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Cross-database query ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
SQL result set export ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Table data export ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data change ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Historical 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 ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
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.

Database type or feature ApsaraDB for MongoDB ApsaraDB for Redis ApsaraDB for HBase ApsaraDB for Lindorm ApsaraDB for Cassandra
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

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

Database type or feature AnalyticDB for MySQL V2.0 AnalyticDB for MySQL V3.0 AnalyticDB for PostgreSQL ApsaraDB for ClickHouse DLA MaxCompute
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 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 ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Operation log ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Data service ✔️ ✔️ ✔️ ✔️
Data visualization ✔️ ✔️ ✔️ ✔️
Task orchestration ✔️ ✔️ ✔️ ✔️
Data warehouse development ✔️ ✔️ ✔️
Ticket system ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Security rule ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Approval process ✔️ ✔️ ✔️ ✔️ ✔️ ✔️