Data Warehouse Service
Contact Sales

GaussDB(DWS) Architecture

This page presents the architecture and technical highlights of GaussDB(DWS).

Architecture

      The architecture of GaussDB(DWS) is illustrated in Figure 1-1.

Figure 1-1 GaussDB(DWS) Architecture

      GaussDB(DWS) supports standard ANSI SQL. You can interact with GaussDB(DWS) using its client tool, JDBC, or ODBC interface. You can develop services via our JDBC, ODBC, and PL/SQL interfaces.

      GaussDB(DWS) relies on a shared-nothing, massively parallel processing (MPP) architecture, where each logical node has dedicated CPU, memory, and storage. Data is distributed on multiple physical nodes, and query tasks are executed near where the data is stored. A control module coordinates the logical nodes for concurrent processing of a large amount of data, so the system can respond to user requests fast.

      GaussDB(DWS) uses hybrid row-column storage and vectorized execution. It can handle both OLTP and OLAP requests.

      GaussDB(DWS) provides tools to assist with data migration, backup, import, and export between databases and between GaussDB(DWS) clusters. These tools make it easy to upgrade, scale, change, and back up your database as needed.

      GaussDB(DWS) also provides a cluster management GUI, where you can deploy, upgrade, and scale your cluster with a few clicks. You can also check your database status and runtime statistics to analyze database performance.

Technical Highlights

  • High performance

With key technologies such as column storage, vectorized executor, and distributed query processing, GaussDB(DWS) can search 10 billion records for the data you need and return results within seconds.

  • High reliability

-­ GaussDB(DWS) uses a distributed architecture with multi-copy redundancy.

-­ Hardware fault detection and switchover are automated to prevent single-node failures.

  • High scalability

- A cluster can include up to 2,048 nodes.

­- The cluster can be flexibly scaled in and out without service interruptions.

  • Openness and compatibility

-­ GaussDB(DWS) supports standard x86 and Arm servers and mainstream Linux distributions, including SUSE Linux, Red Hat, CentOS, and EulerOS.

­- You can smoothly migrate your applications to GaussDB(DWS), which supports SQL-92 and SQL2003.

-­ GaussDB(DWS) can work with Hadoop Distributed File System (HDFS), Huawei Cloud Object Storage Service (OBS), and more. You can flexibly choose and expand your data storage to accelerate big data analysis.