Help Center/ GaussDB(DWS)/ Service Overview/ Data Warehouse Types
Updated on 2025-08-18 GMT+08:00

Data Warehouse Types

Product Type Overview

  • Coupled storage and compute: The storage-compute coupled data warehouse provides enterprise-level data warehouse services with high performance, high scalability, high reliability, high security, low latency, and easy O&M. It is capable of data analysis at a scale of 2,048 nodes and 20 petabytes of data and is suitable for converged analysis services that integrate databases, warehouses, marts, and lakes.
  • Decoupled storage and compute: The storage-compute decoupled data warehouse is designed with a cloud native architecture that separates storage and compute. It also features hierarchical auto scaling for computing and storage, as well as multi-logical cluster shared storage technology (Virtual Warehouse or VW). These capabilities allow for computing isolation and concurrent expansion to handle varying loads, making it an ideal choice for OLAP analysis scenarios.
  • GaussDB(DWS) data warehouses cannot access each other. You can create an OBS foreign table to associate two databases in the same data directory for data query.

Features

Table 1 Features

Module

Function

Storage-Compute Coupling

Storage-Compute Decoupling

Dashboard

Resources

Yes

Yes

Alarms

Yes

Yes

Recent events

Yes

Yes

Cluster monitoring metrics (DMS)

Yes

Yes

Data

-

Yes

Yes

Cluster management

SQL editor

Yes

Yes

Monitoring panel (DMS)

Yes

Yes

Monitoring metrics (Cloud Eye)

Yes

Yes

Restart

Yes

Yes

Start

Yes

Yes

Stop

Yes

Yes

Scaling

Yes

Yes

Scale-in

Yes

Yes

Redistributing data

Yes

Yes (Note 1)

Viewing redistribution details

Yes

Yes

Changing the node flavor

Yes

Yes

Changing all specifications

Yes

No

Resetting passwords

Yes

Yes

Creating snapshots

Yes

Yes

Canceling read-only status

Yes

Yes

Deletion

Yes

Yes

Managing CNs

Yes

Yes

Storage space scaling

Yes

Yes

Basic Information

Basic information

Yes

Yes

ELB

Yes

Yes

Resource Management

Yes

Yes

Intelligent O&M

Yes

Yes

Logical cluster

Yes

Yes

Snapshot

Yes

Yes

Parameter modifications

Yes

Yes

Security settings

Yes

Yes

MRS data sources

Yes

Yes

Tags

Yes

Yes

Node management

Yes

Yes

Upgrade management

Yes

Yes

Logging

Yes

Yes

User management

Yes

Yes

Integration

Data migration

Yes

Yes

DR management

DR management

Yes

No

Snapshot management

Restoration

Yes

Yes

Deletion

Yes

Yes

Copy

Yes

Yes

Incident management

Event management (general)

Yes

Yes

Alarm management

Alarm management

Yes

Yes

Client connections

Client connections

Yes

Yes

Others

Inspection

Yes

Yes

Intelligent O&M

Yes

Yes

Node restoration

Yes

Yes

Warm backup on the tenant side

Yes

Yes

  • Note 1: The storage-compute separated table stores data on OBS, eliminating the need for redistribution. However, metadata and indexes are stored locally and must still be redistributed. Redistributing a table with separated storage and compute nodes only allows for read operations, and metadata redistribution is fast. However, creating an index on the table can affect redistribution performance, with completion time increasing with index data volume. During this period, the table is read-only and cannot be modified.
  • Only storage-compute decoupled clusters of 9.0.2 and later versions support the snapshot function.