Help Center/ GaussDB(DWS)/ Service Overview/ Data Warehouse Types
Updated on 2024-03-14 GMT+08:00
View PDF

Data Warehouse Types

Product Type Overview

  • Standard data warehouse (DWS 2.0): It can analyze hot and cold data and is highly cost-effective. Its storage and computing resources are not limited, and can be elastically scaled and billed per use. It is suitable for the converged analysis that requires integrated databases, warehouses, marts, and lakes. It is most suitable for OLAP workloads.
  • Standard data warehouse (DWS 3.0): It uses the cloud-native, cost-effective architecture with decoupled storage and computing. It supports hot and cold data analysis, elastic scaling of storage and computing, unlimited computing power and capacity, and pay-per-use pricing. It is applicable to OLAP analysis scenarios.
  • Hybrid data warehouse: It provides high-concurrency, high-performance, and low-latency transaction processing capabilities at low costs based on large-scale data query and analysis capabilities. The data warehouse can be used to process HTAP hybrid loads, and can be deployed in standalone or cluster mode.
  • Stream data warehouse: It provides efficient time series computing and IoT analysis capabilities based on the standard data warehouse and supports correlation between real-time and historical data. The compression ratio can reach 40:1. It can be used for IoT real-time analysis.

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

Standard Data Warehouse (DWS 2.0)

Standard Data Warehouse (DWS 3.0)

IoT

Hybrid (Cluster)

Hybrid (Standalone)

Navigation menu

Dashboard

Yes

Yes

Yes

Yes

Yes

Cluster management

Yes

Yes

Yes

Yes

Yes

DR management

Yes

No

Yes

Yes

No

Snapshot management

Yes

Yes

Yes

Yes

No

Parameters

Yes

Yes

Yes

Yes

Yes

Incident management

Yes

Yes

Yes

Yes

Yes

Alarm management

Yes

Yes

Yes

Yes

Yes

Client connections

Yes

Yes

Yes

Yes

Yes

Dashboard

Resources

Yes

Yes

Yes

Yes

Yes

Alarms

Yes

Yes

Yes

Yes

Yes

Recent events

Yes

Yes

Yes

Yes

Yes

Cluster monitoring metrics (DMS)

Yes

Yes

Yes

Yes

No

Cluster management

Monitoring panel (DMS)

Yes

Yes

Yes

Yes

No

Monitoring metrics (Cloud Eye)

Yes

Yes

Yes

Yes

No

Restart

Yes

Yes

Yes

Yes

Yes

Start

No

No

No

No

No

Stop

No

No

No

No

No

Scaling

Yes

Yes

Yes

Yes

No

Scale-in

Yes

Yes

Yes

Yes

No

Redistributing data

Yes

Yes

Yes

Yes

No

Viewing redistribution details

Yes

Yes

Yes

Yes

No

Changing the node flavor

Yes

Yes

Yes

Yes

Yes

Changing all specifications

Yes

No

No

Yes

No

Resetting passwords

Yes

Yes

Yes

Yes

Yes

Creating snapshots

Yes

Yes

Yes

Yes

No

Canceling read-only status

Yes

Yes

Yes

Yes

Yes

Deletion

Yes

Yes

Yes

Yes

Yes

Managing CNs

Yes

Yes

Yes

Yes

No

Storage space scaling

Yes

Yes

Yes

Yes

Yes

Basic Information

Basic information

Yes

Yes

Yes

Yes

Yes

ELB

Yes

Yes

Yes

Yes

N

Resource pool

Yes

Yes

Yes

Yes

N

Logical cluster

Yes

Yes

Yes

Yes

N

Snapshot

Yes

Yes

Yes

Yes

No

Parameter modifications

Yes

Yes

Yes

Yes

Yes

Security settings

Yes

Yes

Yes

Yes

Yes

MRS data sources

Yes

Yes

Yes

Yes

No

Monitoring panel

Yes

Yes

Yes

Yes

No

Tags

Yes

Yes

Yes

Yes

Yes

Node management

Yes

Yes

Yes

Yes

No

DR management

DR management

Yes

No

Yes

Yes

No

Snapshot management

Restoration

Yes

Yes

Yes

Yes

No

Deletion

Yes

Yes

Yes

Yes

No

Copy

Yes

Yes

Yes

Yes

No

Incident management

Event management (general)

Yes

Yes

Yes

Yes

Yes

Alarm management

Alarm management

Yes

Yes

Yes

Yes

Yes

Client connections

Client connections

Yes

Yes

Yes

Yes

Yes

Others

Inspection

Yes

Yes

Yes

Yes

No

Intelligent O&M

Yes

Yes

Yes

Yes

No

Node restoration

Yes

Yes

Yes

Yes

No

Warm backup on the tenant side

Yes

Yes

Yes

Yes

No

Open APIs

Yes

No

Yes

Yes

No
  • A hybrid data warehouse deployed in standalone mode cannot be changed to the distributed mode. Scaling, logical cluster operations, and resource management are not supported.
  • A hybrid data warehouse deployed in standalone mode does not support snapshots, DMS monitoring, or MRS data sources.
  • In a hybrid data warehouse deployed in standalone mode, the original syntax for specifying distribution columns will be ignored. Scheduled jobs, the sequence type, HDFS/OBS foreign table import and export, multi-temperature storage, and auto-increment partitioned tables are not supported. OBS foreign table import and export are supported in 8.2.0 and later versions.
  • Only GaussDB(DWS) 3.0 clusters of 9.0.2 and later versions support the snapshot function.