Data Warehouse Types
Product Type Overview
- Coupled storage and compute: This type of 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 shared storage for virtual warehouses (VW). These capabilities allow for computing isolation and concurrent expansion to handle varying loads, making it an ideal choice for OLAP analysis scenarios.
Features
| Function | Function | Coupled Storage and Compute | Decoupled Storage and Compute |
|---|---|---|---|
| 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 | |
| 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 | |
| Workload management | Yes | Yes | |
| Intelligent O&M | Yes | Yes | |
| Logical cluster | Yes | Yes (virtual warehouse in the storage-compute decoupled architecture) | |
| 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 | 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 | |
| Extended functions (plug-ins) | Extended functions such as PostGIS (CREATE EXTENSION statement) | Yes | They can only be executed on the primary compute group. |
- Note 1: The storage-compute decoupled 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 decoupled 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.
