Jenis dan fitur database apa saja yang didukung oleh DMS - Data Management

Data Management (DMS) mendukung database relasional, gudang data, database NoSQL, platform data besar, serta layanan file dan log. Halaman ini mencantumkan semua database yang didukung beserta fitur DMS yang tersedia untuk masing-masingnya.

Jenis database yang didukung

Database Alibaba Cloud

Database relasional

ApsaraDB RDS for MySQL
ApsaraDB RDS for SQL Server
ApsaraDB RDS for PostgreSQL
ApsaraDB for MariaDB
PolarDB for MySQL
PolarDB for PostgreSQL
PolarDB for PostgreSQL (Compatible with Oracle)
PolarDB for Xscale (sebelumnya DRDS)
ApsaraDB for OceanBase dalam mode MySQL
ApsaraDB for OceanBase dalam mode Oracle
ApsaraDB RDS for PPAS

Gudang data

ApsaraDB for ClickHouse
AnalyticDB for MySQL 3.0
AnalyticDB for PostgreSQL
AnalyticDB for MySQL 2.0

Database NoSQL

Tair (Redis OSS-Compatible)
ApsaraDB for MongoDB
ApsaraDB for MongoDB Serverless Edition tidak didukung.
ApsaraDB for Cassandra
Lindorm SQL
Lindorm Phoenix
Lindorm CQL
Lindorm TSDB
Lindorm HBase
Graph Database

Data besar

MaxCompute
MaxCompute Lighting

Fitur	SLS	OSS
Query	✔️	✔️
Logical database and table query	❌	❌
Cross-database query	❌	❌
SQL result set export	✔️	❌
Table data export	❌	❌
Data change	❌	❌
Data import	❌	❌
Test data generation	❌	❌
Database clone	❌	❌
Schema evolution	❌	❌
Visual schema editing	❌	❌
Schema synchronization	❌	❌
Empty database initialization	❌	❌
Programmable object	✔️	❌
Export Structure	❌	❌
Schema design PRO	❌	❌
Database creation	❌	❌
Database user creation	❌	❌
SQL review	❌	❌
Sensitive data management	❌	❌
Permission system	✔️	✔️
Operation logs	✔️	❌
Task orchestration	❌	✔️
Ticket system	❌	❌
Security rules	❌	❌
Approval process	❌	❌

Fitur	MaxCompute	Hologres	RestAPI
Query	✔️	✔️	❌
Logical database and table query	❌	❌	❌
Cross-database query	❌	❌	❌
SQL result set export	✔️	✔️	❌
Table data export	❌	❌	❌
Data change	✔️	✔️	❌
Data import	❌	✔️	❌
Test data generation	❌	❌	❌
Database clone	❌	❌	❌
Schema evolution	❌	❌	❌
Visual schema editing	❌	❌	❌
Schema synchronization	❌	❌	❌
Empty database initialization	❌	❌	❌
Programmable object	❌	❌	❌
Schema export	❌	❌	❌
Schema design PRO	❌	❌	❌
Database creation	❌	❌	❌
Database user creation	❌	❌	❌
SQL review	❌	❌	❌
Sensitive data management	✔️	✔️	❌
Permission system	✔️	✔️	✔️
Operation logs	✔️	✔️	❌
Task orchestration	✔️	✔️	✔️
Ticket system	✔️	✔️	❌
Security rules	✔️	✔️	❌
Approval process	✔️	✔️	❌

Layanan file dan log

OSS
Log Service

Database cloud pihak ketiga dan database yang dikelola sendiri

Database relasional

MySQL
SQL Server
PostgreSQL
MariaDB
ApsaraDB for OceanBase dalam mode MySQL
ApsaraDB for OceanBase dalam mode Oracle
OceanBase ODP
Oracle
Db2
Dameng
openGauss

Gudang data

ApsaraDB for ClickHouse

Database NoSQL

Tair (Redis OSS-Compatible)
ApsaraDB for MongoDB

Data besar

BigQuery

Dukungan fitur berdasarkan jenis database

Keterangan simbol:

Simbol	Makna
✔️	Didukung
➖	Segera hadir
❌	Tidak didukung

Database relasional

Operasi data

Fitur	MySQL (excl. PolarDB-X)	PolarDB-X	SQL Server	PostgreSQL (excl. PolarDB for PostgreSQL)	PolarDB for PostgreSQL	MariaDB	ApsaraDB for OceanBase dalam mode MySQL	Oracle yang dikelola sendiri dan ApsaraDB for OceanBase dalam mode Oracle	PolarDB for PostgreSQL (Compatible with Oracle)	DamengDB
Query	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Query untuk database logis atau koleksi	✔️	❌	✔️	✔️	✔️	➖	✔️	✔️	✔️	❌
Cross-instance query	✔️	✔️	✔️	✔️	✔️	❌	❌	❌	✔️	❌
SQL result set export	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Table data export	✔️	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️
Data change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Historical data cleanup	✔️	✔️	❌	✔️	✔️	✔️	✔️	❌	✔️	✔️
Lock-free data change	✔️	✔️	❌	✔️	✔️	✔️	✔️	❌	✔️	❌
Data import	✔️	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️
Test data generation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	❌
Data tracking	✔️	➖	❌	❌	❌	➖	❌	❌	➖	❌

Manajemen skema

Fitur	MySQL (excl. PolarDB-X)	PolarDB-X	SQL Server	PostgreSQL (excl. PolarDB for PostgreSQL)	PolarDB for PostgreSQL	MariaDB	ApsaraDB for OceanBase dalam mode MySQL	Oracle yang dikelola sendiri dan ApsaraDB for OceanBase dalam mode Oracle	PolarDB for PostgreSQL (Compatible with Oracle)	DamengDB
Schema change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	❌
Visualized schema modification	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	✔️	❌
Lock-free schema change	✔️	➖	❌	❌	❌	➖	❌	❌	❌	❌
Schema synchronization	✔️	✔️	❌	➖	➖	✔️	✔️	❌	➖	❌
Schema export	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Schema design pro	✔️	✔️	❌	❌	➖	➖	✔️	❌	➖	❌
Database cloning	✔️	✔️	❌	➖	➖	✔️	✔️	❌	➖	❌
Empty database initialization	✔️	✔️	❌	➖	➖	✔️	✔️	❌	➖	❌
Programmable object	✔️	❌	✔️	✔️	✔️	✔️	❌	❌	✔️	❌
Database creation	✔️	❌	❌	➖	❌	✔️	❌	❌	❌	❌
Database user creation	✔️	❌	❌	➖	❌	✔️	❌	❌	❌	❌

Analisis dan diagnostik SQL

Fitur	MySQL (excl. PolarDB-X)	PolarDB-X	SQL Server	PostgreSQL (excl. PolarDB for PostgreSQL)	PolarDB for PostgreSQL	MariaDB	ApsaraDB for OceanBase dalam mode MySQL	Oracle yang dikelola sendiri dan ApsaraDB for OceanBase dalam mode Oracle	PolarDB for PostgreSQL (Compatible with Oracle)	DamengDB
SQL review	✔️	➖	❌	✔️	✔️	➖	➖	✔️	✔️	❌
SQL and instance diagnostics	✔️	❌	❌	✔️	✔️	➖	❌	❌	✔️	❌

Keamanan dan tata kelola

Fitur	MySQL (excl. PolarDB-X)	PolarDB-X	SQL Server	PostgreSQL (excl. PolarDB for PostgreSQL)	PolarDB for PostgreSQL	MariaDB	ApsaraDB for OceanBase dalam mode MySQL	Oracle yang dikelola sendiri dan ApsaraDB for OceanBase dalam mode Oracle	PolarDB for PostgreSQL (Compatible with Oracle)	DamengDB
Sensitive data management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Access control system	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Operation logs	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Security rules	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️	✔️
Task orchestration	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️	✔️
Ticket system	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Approval process	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️

Gudang data

Fitur	AnalyticDB for MySQL 2.0	AnalyticDB for MySQL 3.0	AnalyticDB for PostgreSQL	ClickHouse
Query	✔️	✔️	✔️	✔️
Query untuk database logis atau koleksi	❌	✔️	✔️	❌
Cross-instance 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 logs	✔️	✔️	✔️	✔️
Task orchestration	✔️	✔️	✔️	❌
Ticket system	✔️	✔️	✔️	✔️
Security rules	✔️	✔️	✔️	✔️
Approval process	✔️	✔️	✔️	✔️

Database NoSQL

Fitur	MongoDB	Redis	Lindorm	Cassandra	GDB
Query	✔️	✔️	✔️	✔️	✔️
Cross-instance 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 logs	✔️	✔️	✔️	✔️	✔️
Ticket system	✔️	✔️	✔️	✔️	✔️
Security rules	✔️	✔️	✔️	✔️	✔️
Approval process	✔️	✔️	✔️	✔️	✔️

Data besar

Fitur	MaxCompute	Hologres	RestAPI
Query	✔️	✔️	❌
Query untuk database logis atau koleksi	❌	❌	❌
Cross-instance 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 logs	✔️	✔️	❌
Task orchestration	✔️	✔️	✔️
Ticket system	✔️	✔️	❌
Security rules	✔️	✔️	❌
Approval process	✔️	✔️	❌

Layanan file dan log

Fitur	SLS	OSS
Query	✔️	✔️
Query untuk database logis atau koleksi	❌	❌
Cross-instance 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 logs	✔️	❌
Task orchestration	❌	✔️
Ticket system	❌	❌
Security rules	❌	❌
Approval process	❌	❌

Data Disaster Recovery (sebelumnya DBS) — jenis database yang didukung

Penting

Jika sumber data berisi nama tabel atau nama field dalam bahasa Tiongkok, pemulihan data akan gagal. Bergabunglah dengan grup DingTalk (ID: 35585947) untuk melaporkan masalah ini atau submit a ticketsubmit a ticket.

Data Disaster Recovery mendukung kategori database berikut:

Database relasional: Database Alibaba Cloud; database yang dikelola sendiri pada instans Elastic Compute Service (ECS); database on-premises; database cloud pihak ketiga
Database NoSQL: MongoDB, Redis
Cadangan logis: MySQL, MariaDB, PolarDB (untuk PostgreSQL, untuk MySQL, untuk PostgreSQL Kompatibel dengan Oracle, dan PolarDB-X), SQL Server, Oracle, Redis, MongoDB

Sumber data pemulihan bencana

Modul sumber data pemulihan bencana mendukung pembuatan cadangan dari:

Database Alibaba Cloud: ApsaraDB RDS for MySQL, ApsaraDB RDS for PostgreSQL, ApsaraDB RDS for SQL Server, dan PolarDB for MySQL
Database yang dikelola sendiri pada instans ECS: MySQL
Database on-premises dan cloud pihak ketiga: MySQL

Dukungan fitur Data Disaster Recovery berdasarkan jenis database

Database relasional — Alibaba Cloud

Cadangan logis

Operasi	ApsaraDB RDS for MySQL	ApsaraDB RDS for SQL Server	ApsaraDB RDS for PostgreSQL	ApsaraDB RDS for MariaDB	PolarDB for MySQL	PolarDB for PostgreSQL	PolarDB-X
Versi yang didukung	8.0, 5.7, 5.6, 5.5	2019, 2017, 2016, 2014, 2012, 2008 R2	16, 15, 14, 13, 12, 11, 10, 9.4	10.3	8.0, 5.7, 5.6	11	Jenis penyimpanan: ApsaraDB RDS for MySQL (MySQL 5.x)
Jenis sumber data	MySQL	SQL Server	PostgreSQL	MariaDB	MySQL	Oracle, PostgreSQL	PolarDB-X
Cadangan data lengkap	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Cadangan log inkremental	✔️	❌	❌	✔️	✔️	❌	❌
Cadangan real-time	RPO dalam hitungan detik	RPO dalam hitungan hari	RPO dalam hitungan hari	RPO dalam hitungan detik	RPO dalam hitungan detik	RPO dalam hitungan hari	RPO dalam hitungan hari
Pemulihan instans	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Granularitas minimum	Tabel	Tabel	Tabel	Tabel	Tabel	Tabel	Database
Unduh set cadangan	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Kueri set cadangan	✔️	✔️	✔️	❌	✔️	✔️ (hanya untuk sumber data PostgreSQL)	✔️

Recovery Point Objective (RPO) adalah jumlah maksimum kehilangan data yang dapat diterima, diukur sebagai titik waktu hingga data dapat dipulihkan setelah terjadi bencana.

Pencadangan dan pemulihan lintas akun didukung untuk database Alibaba Cloud. Untuk detailnya, lihat Mencadangkan dan memulihkan data lintas akun Alibaba Cloud.

Database relasional — yang dikelola sendiri dan cloud pihak ketiga

Cadangan logis

Operasi	MySQL	SQL Server	Oracle	PostgreSQL	MariaDB
Versi yang didukung	8.0, 5.7, 5.6, 5.5	2019, 2017, 2016, 2014, 2012, 2008 R2, dan 2005 di Windows	12c, 11g, 10g, 9i	11, 10, 9.5, 9.4, 9.3	10.3, 10
Jenis sumber data	MySQL	SQL Server	Oracle	PostgreSQL	MariaDB
Cadangan data lengkap	✔️	✔️	✔️	✔️	✔️
Cadangan log inkremental	✔️	❌	❌	❌	✔️
Cadangan real-time	RPO dalam hitungan detik	RPO dalam hitungan hari	RPO dalam hitungan hari	RPO dalam hitungan hari	RPO dalam hitungan detik
Pemulihan instans	✔️	✔️	✔️	✔️	✔️
Granularitas minimum	Tabel	Tabel	Tabel	Tabel	Tabel
Unduh set cadangan	✔️	✔️	✔️	✔️	✔️
Kueri set cadangan	✔️	✔️	✔️	✔️	❌

Cadangan fisik

Operasi	MySQL	SQL Server	Oracle
Versi yang didukung	8.0, 5.7, 5.6, 5.5 (Linux)	2019, 2017, 2016, 2014, 2012, 2008 R2, 2005, 2000	11g, 10g, 12c, 18c, 19c
Jenis sumber data	MySQL	SQL Server	Oracle
Cadangan data lengkap	✔️	✔️	✔️
Cadangan log inkremental	✔️ (log biner; lihat Mencadangkan log biner database MySQL)	✔️	✔️
Cadangan diferensial	✔️	❌	❌
Pemulihan instans	✔️	✔️	✔️
Granularitas minimum	Instance	Database	Instans
Unduh set cadangan	✔️	✔️	✔️
Kueri set cadangan	❌	❌	❌
Pemulihan dalam hitungan menit	✔️	❌	✔️
Sandbox Data Disaster Recovery	✔️	❌	✔️

Database NoSQL

Cadangan logis

Operasi	MongoDB	Redis
Jenis database	Database Alibaba Cloud; yang dikelola sendiri di ECS; on-premises; cloud pihak ketiga	Database Alibaba Cloud; yang dikelola sendiri di ECS; on-premises; cloud pihak ketiga
Jenis sumber data	MongoDB	Redis
Versi yang didukung	4.2, 4.0, 3.6, 3.4, 3.2	4.0 (hanya arsitektur master-replika standar)
Cadangan data lengkap	✔️	✔️
Cadangan log inkremental	✔️ (hanya untuk arsitektur replica set)	✔️
Cadangan real-time	RPO dalam 10 menit	RPO dalam 10 menit
Pemulihan instans	✔️	✔️
Granularitas minimum	Koleksi	Database
Unduh set cadangan	✔️	❌
Kueri set cadangan	❌	❌

Redis 5.0 atau versi lebih baru tidak didukung. Instans cluster Redis tidak didukung. Hanya arsitektur master-replika standar yang didukung.

Objek database yang didukung oleh cadangan logis

Penting

Database Engine	Objek yang didukung
MySQL, MariaDB	Tabel, indeks, view, trigger, constraint, primary key, foreign key, stored procedure, function
PostgreSQL, PolarDB for PostgreSQL	Tabel, indeks, view, function, stored procedure, constraint, foreign key, sequence, rule, domain, extension, operator
PolarDB for MySQL, PolarDB for PostgreSQL (Compatible with Oracle), PolarDB-X	Tabel, indeks, view, trigger, stored procedure, role, constraint, user-defined function, user-defined table type
SQL Server	Tabel, indeks, view, trigger, stored procedure, user, role, constraint, user-defined function, user-defined data type, user-defined table type
Oracle	Tabel, indeks, view, constraint, foreign key, sequence, trigger, function, stored procedure, synonym, package
Redis	STRING, BINARY, LIST, SET, SORTED SET, HASH, BITARRAY, HYPERLOG, GEO, MODULE
MongoDB	Tabel, koleksi, indeks, view, function, user, role ( Catatan Database admin di MongoDB tidak dapat dicadangkan.)