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
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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot