Process for Using GaussDB(DWS)

GaussDB(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. GaussDB(DWS) provides competitive solutions for PB-level big data analysis in various industries.

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

Process Description

Figure 1 Process for using GaussDB(DWS)

**Table 1** Process description
Process	Task	Description	Operation Instruction
Make preparations.	-	Before using GaussDB(DWS), select an open port on your firewall as the database port of your data warehouse cluster.	Preparations
Create a cluster.	-	Create a cluster before using GaussDB(DWS) to execute data analysis tasks. A GaussDB(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 2.0 Cluster Creating a Yearly/Monthly Cluster
Connect to the cluster.	-	After the data warehouse cluster is successfully 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 GaussDB(DWS) management console.	Methods of Connecting to a 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 (DWS) 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.	Managing clusters
	Snapshot management	Create snapshots to back up and restore the cluster.	Snapshots
	O&M and monitoring	View the running status and performance of the cluster through monitoring, log auditing, event notification, and resource load management.	Monitoring Clusters Using Cloud Eye Event Notifications Overview Audit Logs Resource Management
	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 Specifications
	Cluster upgrade	Cluster 8.1.1 and later versions allow users to deliver cluster upgrade operations on the console.	Cluster Upgrade
	Resource load management	GaussDB(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.	Resource Management
	Logical cluster	A physical cluster comprises multiple logical clusters, each with isolated user data. By deploying services on different logical clusters, an enterprise can manage services together while keeping their data and resources separate.	Managing Logical Clusters