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 MySQL databases from other sources
- SQL Server: ApsaraDB RDS for SQL Server, MyBase for SQL Server, and SQL Server databases from other sources
- PostgreSQL: ApsaraDB RDS for PostgreSQL, PolarDB for PostgreSQL, MyBase for PostgreSQL, and PostgreSQL databases from other sources
- MariaDB: ApsaraDB for MariaDB TX and MariaDB databases from other sources
- OceanBase: ApsaraDB for OceanBase in MySQL mode, ApsaraDB for OceanBase in Oracle mode, and self-managed OceanBase databases
- PolarDB for Oracle
- Self-managed Oracle
- DamengDB
- IBM Db2
- NoSQL databases:
- Redis: ApsaraDB for Redis, MyBase for Redis, and Redis databases from other sources
- MongoDB: ApsaraDB for MongoDB and MongoDB databases from other sources
Note ApsaraDB for MongoDB of Serverless Edition is not supported.
- 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 ClickHouse databases from other sources
- MaxCompute
- Hologres
- Object Storage Service
Note Databases from other sources 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 for Oracle | 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 | ✔️ | ✔️ | ❌ | ❌ | ➖ | ➖ | ✔️ | ❌ | ➖ | ❌ | ❌ |
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.
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 | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ❌ |