Using DWS

DWS is an online data processing database that uses the Huawei Cloud infrastructure to provide scalable, fully managed, and out-of-the-box analytic database service, freeing you from complex database management and monitoring. It is a native cloud service based on the Huawei converged data warehouse GaussDB, and is fully compatible with the standard ANSI SQL 99 and SQL 2003, as well as the PostgreSQL and Oracle ecosystems. DWS provides competitive solutions for PB-level big data analysis in various industries.

DWS provides an easy-to-use management console, allowing you to quickly create clusters and easily manage data warehouses.

Procedure Description

Figure 1 Procedure for using DWS
Click to enlarge

**Table 1** Procedure description
Process	Task	Description	Operation Instruction
Make preparations.	-	Before using DWS, you need to apply for a Cloud account.	Preparations
Create a cluster.	-	Create a cluster before using DWS to execute data analysis tasks. A DWS cluster contains nodes in the same subnet. These nodes jointly provide services. During cluster creation, the system creates a default database.	Creating a DWS Storage-Compute Coupled Cluster Creating a DWS Storage-Compute Decoupled Cluster
Connect to the cluster.	-	After the DWS cluster is created, use the SQL client tool or a third-party driver such as JDBC or ODBC to connect to the database in the cluster. You can download the SQL client tool and JDBC/ODBC driver on the Client Connections page of the DWS console.	Connecting to a DWS Cluster
Access the database.	-	After connecting to the cluster, you can create and manage databases, manage users and permissions, import and export data, and query and analyze data.	Data Warehouse Service Developer Guide
Manage and monitor the cluster.	Cluster management	View the cluster status, modify cluster configurations, add cluster tags, and scale out, restart, and delete the cluster.	DWS Cluster Management
	Snapshot management	Create snapshots to back up and restore the cluster.	Backing Up and Restoring a GaussDB(DWS) Cluster
	O&M and monitoring	View the running status and performance of the cluster through cluster monitoring, log auditing, event notification, and alarm management.	Viewing DWS Cluster Monitoring Information on Cloud Eye Viewing and Subscribing to DWS Cluster Events Viewing GaussDB(DWS) Cluster Monitoring Information on the Monitoring Panel (DMS) Viewing and Subscribing to DWS Cluster Alarms
	Scaling and specification change	Expand the capacity of an existing cluster on the console if your service requires additional compute or storage resources. Change the specifications of created clusters on the console.	Scaling Out a Cluster Changing DWS Cluster Specifications
	Cluster upgrade	Cluster 8.1.1 and later versions allow users to deliver cluster upgrade operations on the console.	Upgrading a DWS Cluster
	Resource load management	DWS provides the resource management function. You can put resources (CPU, memory, I/O, and storage space) into different resource pools, which are isolated from each other.	DWS Resource Load Management

Next topic: Preparations

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel