GaussDB(DWS)

{"_id":"pep-solution-page-navigate-v2_1690800752634","context":{"bg":"white","btnList":[{"btnUrl":"https://www.huaweicloud.com/eu/about/contact-us.html","btnText":"Contact Us","btnStyle":"por-btn-primary"}],"moreText":"更多","actionInfo":{"title":"GaussDB(DWS)","titleUrl":"","actionList":[{"isBlank":false,"actionUrl":"","isChecked":true,"actionName":"Overview","selectMenu":{"selectList":[{"url":"https://www.huaweicloud.com","name":"开发者资源开发者资源开发者资源","isBlank":false},{"url":"https://www.huaweicloud.com","name":"客户案例","isBlank":false},{"url":"https://www.huaweicloud.com","name":"最佳实践","isBlank":false}]},"isShowSelect":false},{"isBlank":true,"actionUrl":"https://support.huaweicloud.com/eu/function-dws/index.html","isChecked":false,"actionName":" Features","selectMenu":{"selectList":[{"url":"https://www.huaweicloud.com","name":"开发者资源开发者资源开发者资源","isBlank":false},{"url":"https://www.huaweicloud.com","name":"客户案例","isBlank":false},{"url":"https://www.huaweicloud.com","name":"最佳实践","isBlank":false}]},"isShowSelect":false},{"isBlank":true,"actionUrl":"https://support.huaweicloud.com/eu/productdesc-dws/dws_01_0011.html","isChecked":false,"actionName":"Pricing","selectMenu":{"selectList":[{"url":"https://www.huaweicloud.com","name":"开发者资源","isBlank":false},{"url":"https://www.huaweicloud.com","name":"客户案例","isBlank":false},{"url":"https://www.huaweicloud.com","name":"最佳实践","isBlank":false}]},"isShowSelect":false},{"isBlank":true,"actionUrl":"https://support.huaweicloud.com/eu/productdesc-dws/dws_01_00018.html","isChecked":false,"actionName":"Instances","selectMenu":{"selectList":[{"url":"https://www.huaweicloud.com","name":"开发者资源开发者资源开发者资源","isBlank":false},{"url":"https://www.huaweicloud.com","name":"客户案例","isBlank":false},{"url":"https://www.huaweicloud.com","name":"最佳实践","isBlank":false}]},"isShowSelect":false},{"isBlank":true,"actionUrl":"https://support.huaweicloud.com/eu/qs-dws/index.html","isChecked":false,"actionName":"Getting Started","selectMenu":{"selectList":[{"url":"","name":"","isBlank":false},{"url":"","name":"","isBlank":false}]},"isShowSelect":false},{"isBlank":true,"actionUrl":"https://support.huaweicloud.com/eu/dws_faq/dws_03_0001.html","isChecked":false,"actionName":"FAQs","selectMenu":{"selectList":[{"url":"","name":"","isBlank":false},{"url":"","name":"","isBlank":false}]},"isShowSelect":false}],"mobileSelectText":""},"columnNumberMB":"2"},"advancedInfo":{"isShowBtn":true,"isShowTitle":true}}

Data Warehouse Service (DWS)

A next-gen, all-scenario data warehouse that features one-stop analysis and unlimited performance and capacity, helping you make the most of your data.

2048-Node Ultra-large Cluster

First CAICT certified 2048-node cluster

4+1 One-stop Analysis

Database/Warehouse/Mart/Lake + IoT integration

Multi-ecosystem compatibility

Compatible with TD/Oracle/PG/MySQL ecosystems

Why Huawei Cloud Data Warehouse Service (DWS)?

Exceptional Scalability, Huge Computing Power, and Multi-Layer Reliability

A GaussDB(DWS) cluster is designed to be highly scalable and can store up to 10 PB data.
The multi-layer parallel computing of GaussDB(DWS) ensures faster processing and can meet even the highest SLA requirements.
The GaussDB(DWS) data warehouse system is built to be robust and available 24/7, thanks to its multi-level HA and backup features, as well as full hardware redundancy.

Respond to massive concurrent interactive queries within seconds, enabling faster analysis

A 480-node GaussDB(DWS) cluster can have a capacity of up to 20 PB, making it ideal for data analysis, data marts, and business intelligence (BI).
Through distributed query optimization, GaussDB(DWS) can handle a large number of concurrent point queries in just seconds, or even milliseconds.
On GaussDB(DWS), resources are integrated and flexibly scheduled to accelerate multi-layer parallel computing.

Scalable Hybrid Transaction/Analytical Processing (HTAP) Capabilities in a Lakehouse

GaussDB(DWS) can handle over 1 million QPS and 100,000 TPS, ensuring strong transaction consistency.
GaussDB(DWS) can dynamically allocate resources to tasks based on task priorities.
GaussDB(DWS) can be elastically scaled to adapt to workload changes during peak and off-peak hours.
GaussDB(DWS) can integrate with data lake and directly read from and write to OBS, which stores cold and hot data separately.

Multi-source data convergence and real-time data analysis

GaussDB(DWS) can return results for complex SQL joins on over 10 tables in mere seconds.
On GaussDB(DWS), up to 600,000 records can be imported per second through hybrid batch and stream processing, eliminating the need to wait until the following day for analysis results.
On GaussDB(DWS), you can easily integrate all of your data sources and manage them all in one place.

Versatile Data Warehouse for the Big Data Era

Replaces Traditional Data Warehouses
One-Stop BI solution
Real-time Data Analysis

Replaces Traditional Data Warehouses

Traditional database or data warehouse products often face challenges in terms of storage, query processing, scalability, and cost-effectiveness. GaussDB(DWS) is a next-generation, all-scenario data warehouse solution that overcomes these difficulties and features excellent performance, high scalability, and one-stop analysis.

Advantages

Seamless Migration

GaussDB(DWS) provides various migration tools to ensure the seamless migration of popular data analysis systems such as Teradata, Oracle/Exadata, and Greenplum.

Comprehensive Database and SQL Capabilities

GaussDB(DWS) supports the SQL:2003 standard. It is compatible with the syntax and data structures of Oracle and Teradata, and supports global transactions, stored procedures, and strong data consistency.

Database and Warehouse Integration

GaussDB(DWS) supports logical clusters that can implement data marts and data warehouses in a cluster.

Related Services

Cloud Data Migration (CDM)

DataArts Studio

One-Stop BI solution

Enterprises have massive data assets, necessitating a high-performance big data platform that supports full data analysis and mining. GaussDB(DWS)+BI offers a global, intuitive, associated, and visualized digital operation analysis platform that can enhance business value and management.

Advantages

Multi-Source Data Access

Data is collected from many sources and displayed on a unified data display platform, preventing data silos.

Unified Analysis and Decision-making Platform

GaussDB(DWS) supports unified multi-dimension data analysis and decision-making for enterprises.

Various Display Methods

With BI tools, the data analysis results of GaussDB(DWS) can be displayed on PCs, mobile devices, and dashboards in many forms, meeting various report requirements of business departments.

Related Services

Data Lake Insight (DLI)

MapReduce Service (MRS)

DataArts Studio

Real-time Data Analysis

Real-Time Import of Stream Data

Data from IoT and Internet applications can be written into GaussDB(DWS) in real time after being processed by stream computing and AI services.

Advantages

Real-Time Import of Stream Data

Data from IoT and Internet applications can be written into GaussDB(DWS) in real time after being processed by stream computing and AI services.

Real-Time Monitoring and Prediction

GaussDB(DWS) monitors devices and predicts behavior through data analytics to control risk and optimize performance.

AI Convergent Analysis

You can conduct association analysis on the results of AI-based image and text data analysis, as well as other service data, on GaussDB(DWS).

Related Services

ModelArts

Continuous Service Innovation for Millions of Customers

CMB KingMed Diagnostics Mingyuan Cloud Xingsheng Youxuan

Huawei Cloud empowers CMB's cloud data warehouse to unlock the full potential of data with a whole new experience.

CMB successfully deployed a 240-node ultra-large GaussDB(DWS) cluster, significantly shortening batch job processing.

Data+technology expedite medical examinations

KingMed Diagnostics partnered with Huawei Cloud to build a T+0 medical examination real-time dashboard. This innovative dashboard allows medical professionals to monitor the lab examination process in real time and quickly schedule resources as needed.

Huawei Cloud and Mingyuan Cloud joined forces to lead the digitalization of the real-estate industry.

Leveraging Huawei Cloud's full-process O&M, Mingyuan Cloud implemented O&M capabilities such as cluster management, database monitoring and diagnosis, and event alarms, ensuring stable O&M services for its customers.

Huawei Cloud helped Xingsheng Youxuan connect data to users and establish a thriving community e-commerce platform.

GaussDB(DWS) helped Xingsheng Youxuan solve problems of data inconsistency and real-time service instability, and sorted the data assets of dozens of service domains, enabling Xingsheng to provide better user experience.

Authoritative Certifications

CC EAL2 + ALC_FLR.2 Certification

On March 8, 2022, the Huawei GaussDB 200 data warehouse, a.k.a Huawei Cloud GaussDB(DWS), was officially granted the CC EAL2 + ALC_FLR.2 — one of the most highly respected security certifications in the world.

GaussDB(DWS) earned the certification for its strong measures to protect data assets against risks and threats.

"Best Data Warehouse Product" in 2020 and 2021

From July 28 to 29, 2021, the 6th China Big Data World conference was held in Beijing, with the theme, "Digital and Intelligent Transformation".

GaussDB(DWS) defended its title as the "Best Data Warehouse Product" at the conference.

Leading Technology Achievement Award in 2021

On May 26, 2021, the China International Big Data Industry Expo was held in Guiyang, China, issuing Leading Technology Achievement Awards to industry leading products.

GaussDB(DWS) won the award for its outstanding analysis performance and advanced design.

Certification for a 2048-node Cluster

On December 18, 2020, the Data Asset Management Conference jointly hosted by CAICT, China Communications Standards Association, and Beijing Big Data Center was held in Beijing.

GaussDB(DWS) with its record of 2048 nodes per cluster, passed the test with full marks, and became the largest distributed database ever certified by CAICT.

CC EAL2 + ALC_FLR.2 Certification

GaussDB(DWS) earned the certification for its strong measures to protect data assets against risks and threats.

"Best Data Warehouse Product" in 2020 and 2021

From July 28 to 29, 2021, the 6th China Big Data World conference was held in Beijing, with the theme, "Digital and Intelligent Transformation".

GaussDB(DWS) defended its title as the "Best Data Warehouse Product" at the conference.

Leading Technology Achievement Award in 2021

On May 26, 2021, the China International Big Data Industry Expo was held in Guiyang, China, issuing Leading Technology Achievement Awards to industry leading products.

GaussDB(DWS) won the award for its outstanding analysis performance and advanced design.

Certification for a 2048-node Cluster

On December 18, 2020, the Data Asset Management Conference jointly hosted by CAICT, China Communications Standards Association, and Beijing Big Data Center was held in Beijing.

GaussDB(DWS) with its record of 2048 nodes per cluster, passed the test with full marks, and became the largest distributed database ever certified by CAICT.

Documentation

Getting Started

Getting Started

Creating a Cluster and Connecting to It

Database Quick Start

Basic SQL Operations

More
Best Practices

Best Practices

Import and Export

Data Migration

Table Optimization Practices

More
FAQs

FAQs

What Do I Do If Creating a GaussDB(DWS) Cluster Failed?

How Do I Change Distribution Columns?

How Applications Communicate with GaussDB(DWS)?

More

More Services

Data Lake Insight (DLI)

Converged processing and analysis service for stream and batch jobs

MapReduce Service (MRS)

Enterprise-level big data cluster cloud service

DataArts Studio

One-stop data development and governance platform

Data Warehouse Service (DWS)