Help Center> GaussDB(DWS)> Progressive Knowledge
Progressive Knowledge - HuaweiCloud

Data Warehouse Service

Data Warehouse Service (DWS) is a real-time, simple, secure, and reliable enterprise-class converged data warehouse service. It is compatible with the standard ANSI SQL 99/2003 and PostgreSQL/Oracle ecosystems, providing state of the art PB-level big data analysis across a variety of industries.


Progressive Knowledge

DWS knowledge for users from beginner level to expert level

Understand

DWS architecture, functions, and application scenarios are provided to help you quickly select your desired type to match services. This facilitates easier data analysis.

Service Overview

Start

This document demonstrates how to create a data warehouse cluster, connect to a sample database, import sample data from OBS, and query and analyze the data, helping you quickly use DWS.

Getting Started

Initializing Data Disks

Excellent Practices

During table design, data import, and query design, comprehensively consider the factors to work out a proper solution. This chapter introduces key principles with necessary examples and usage suggestions.

Excellent Practices

Tools

DWS provides several database tools to facilitate database management and data import and export.

Tool Guide

APIs

DWS provides Representational State Transfer (REST) APIs. You can make API calls over HTTPS to manage clusters and snapshots. This document details DWS APIs, parameters, examples, and calling methods.

API Reference

Databases Monitoring

DMS is provided by GaussDB(DWS) to ensure the fast and stable running of databases. It collects, monitors, and analyzes the disk, network, and OS metric data used by the service database, as well as key performance metric data of cluster running. 

Monitoring

Utilities

Workload Analysis

Typical Scenarios

Purchase

DWS supports two billing modes: pay-per-use (billed based on the actual duration) and yearly/monthly package (discount obtained by upfront payment).

Billing Mode

Quick Purchase

Billing FAQs

FAQs

Learn more about common issues and solutions.