Tagged articles
GaussDB
31 articles · Page 1 of 1
The article details how China Postal Savings Bank rebuilt its core account transaction query system with a distributed micro‑service and big‑data stack, achieving millisecond‑level responses for over ten years of data, boosting performance by 700% and enabling new intelligent services.
Apache SparkFinancial ComplianceGaussDB
0 likes · 9 min read

Facing gaps in database education, Beijing Information Technology University launched a GaussDB‑based textbook project to blend theory with hands‑on practice, producing a four‑part, thirteen‑chapter resource that covers fundamentals, SQL, design, and management, while supporting curriculum reform and industry collaboration.
Database DesignDatabase EducationGaussDB
0 likes · 10 min read

This article walks through adapting the open‑source fake2db tool to work with Huawei's GaussDB, covering environment setup, driver installation, code changes, testing, and exposing the generated data via a Django‑based RESTful API.
DjangoGaussDBdatabase
0 likes · 5 min read

GaussDB for MySQL introduces a Limit‑Offset pushdown optimization that moves offset calculation to the InnoDB storage engine, eliminating unnecessary row transfers and index‑back‑table lookups, thereby dramatically reducing query latency for large offsets as demonstrated by TPC‑H benchmarks.
Database PerformanceGaussDBLIMIT OFFSET
0 likes · 13 min read

WeTune 2.0, a revolutionary tool developed by Shanghai Jiao Tong University and GaussDB experts, automatically discovers and validates SQL rewrite rules, dramatically improving query performance in Huawei Cloud GaussDB by eliminating manual rule creation, supporting extensive rule enumeration, equivalence verification, and cost‑based evaluation, while addressing scalability challenges.
GaussDBQuery RewriteSQL Optimization
0 likes · 11 min read

GaussDB provides a fine‑grained resource control solution that lets administrators define CPU, memory, I/O, connection, concurrency, and storage limits at user, session, and statement levels, using resource pools, control groups, and GUC parameters to ensure multi‑tenant isolation, SLA compliance, and optimal cluster utilization.
CPUGaussDBI/O
0 likes · 16 min read

This article explains GaussDB's system architecture, the roles of GTM, CN, and DN, the SQL and storage engines, parsing stages, rule‑based and cost‑based optimizers (including AI‑based techniques), distributed query plans, execution operators, and the parallel execution framework that together enable high‑performance SQL processing in a cloud‑native distributed database.
Database ArchitectureDistributed DatabaseGaussDB
0 likes · 15 min read

This article reviews GaussDB(DWS) TopSQL, explaining its purpose, core principles, configurable parameters, system tables, typical real‑time and historical use cases, and practical tips for using TopSQL to monitor, diagnose, and optimize SQL workloads in production environments.
GaussDBPerformance MonitoringTopSQL
0 likes · 8 min read

This article examines the technical reasons why MySQL single tables struggle with massive data volumes, debunks the index‑depth myth, explains InnoDB's SMO concurrency bottlenecks, and shows how B‑Link Tree indexes and heap‑organized tables in GaussDB provide superior performance for large‑scale workloads.
B-Link TreeB-TreeDatabase Performance
0 likes · 10 min read

This guide explains step‑by‑step how to manually set up fine‑grained disaster recovery for GaussDB(DWS) in a cloud‑based dual‑cluster environment, covering preparation, configuration files, backup/restore operations, verification, and removal to achieve reliable, cost‑effective data protection.
GaussDBSQLcloud
0 likes · 20 min read

This article explains why physical fine‑grained backup and restore are essential for GaussDB(DWS), outlines the toolchain, advantages, detailed workflow, and practical command‑line usage to protect data warehouse integrity while saving space and time.
GaussDBPhysical Fine-GrainedRestore
0 likes · 7 min read

This announcement introduces Huawei Cloud’s DTT live session on August 29, where expert Lv Pengbo will explain GaussDB(DWS) resource control principles and demonstrate practical techniques—such as CPU usage analysis, memory tuning, and queue issue resolution—to help developers efficiently manage data‑warehouse resources and boost performance.
GaussDBHuawei CloudSQL Performance
0 likes · 3 min read

Discover how GaussDB(DWS) HStore tables combine columnar storage with Delta capabilities to support high‑concurrency real‑time data ingestion, upsert operations, and ultra‑fast analytical queries, while offering full ACID consistency, strong compression, and practical configuration tips for developers.
ColumnarDatabase StorageGaussDB
0 likes · 8 min read

The article explains how Huawei's BiSheng compiler enhances GaussDB performance through architecture‑level, module‑level, and function‑level optimizations such as inline expansion, instruction prefetch, auto‑vectorization, link‑time optimization, and feedback‑guided optimizations, and outlines future development plans.
BISHENGGaussDBInline
0 likes · 8 min read

Huawei Cloud’s GaussDB, a high‑performance, highly available, elastic, AI‑optimized and secure cloud‑native distributed database, earned the top Science & Technology Progress award, showcasing breakthrough innovations and wide adoption in major financial institutions.
Cloud-Native DatabaseGaussDBSecurity
0 likes · 6 min read

This article reviews the origins, core characteristics, traditional and logical architectures of data warehouses, explores emerging trends such as massive real‑time data, and outlines Huawei Cloud GaussDB(DWS) evolution toward a cloud‑native, elastic, lake‑warehouse integrated solution.
Database ArchitectureGaussDBbig data
0 likes · 8 min read


ITPUBFeb 22, 2023 · Databases
This article summarizes Wang Chuanting’s DTCC2022 talk on Huawei Cloud GaussDB(DWS) 3.0, detailing its cloud‑native architecture, layered elasticity, lake‑warehouse integration, performance acceleration techniques, and how it seamlessly couples data‑processing pipelines with AI workloads for modern, real‑time analytics.
AI integrationGaussDBcloud-native
0 likes · 16 min read

The article analyzes Teradata's withdrawal from the Chinese market, examines its shared‑nothing MPP architecture, compares mainstream domestic data‑warehouse designs, reviews global Gartner assessments, and highlights local alternatives such as GBase 8a and Huawei GaussDB DWS along with migration tools.
GBaseGaussDBTeradata
0 likes · 9 min read

Teradata announced its withdrawal from China due to geopolitical uncertainty and rising competition from mature domestic data‑warehouse solutions, prompting a detailed analysis of its architecture, the main Chinese warehouse designs, global market positioning, and migration tools for replacing Teradata.
Database MigrationGBaseGaussDB
0 likes · 10 min read


ITPUBFeb 20, 2023 · Databases
Teradata's withdrawal from China, driven by geopolitical tensions and the rise of mature domestic data‑warehouse solutions, prompts a detailed look at its MPP architecture, the three main Chinese warehouse designs, Gartner market positioning, and migration tools for alternatives like GBase 8a and GaussDB DWS.
Database MigrationGBaseGaussDB
0 likes · 9 min read

In this interview, Huawei Cloud’s chief architect Zeng Kai explains how data warehouses originated, outlines the five key fusion trends shaping their evolution, and reveals the innovative features of GaussDB(DWS) 3.0 that drive cloud‑native, real‑time, and AI‑integrated analytics.
AI integrationGaussDBHTAP
0 likes · 8 min read

This article explains the design and implementation of a unified data security control platform that protects user privacy and corporate data across multiple big‑data components (Hive, Hetu, GaussDB) by integrating Apache Ranger, custom authorization APIs, asynchronous processing, distributed locking, and SDK‑based authentication to achieve fine‑grained, one‑stop permission management.
GaussDBaccess controlauthorization
0 likes · 17 min read

This article traces the rise of domestic databases in China, highlights the technical and market challenges they faced, and explains how Huawei’s GaussDB leverages cloud, distributed architecture, and ecosystem strategies to become a competitive, high‑availability solution for enterprises.
Chinese database industryGaussDBcloud computing
0 likes · 14 min read

The article explains how the explosive growth of IoT data makes high‑performance time‑series databases essential, describes Huawei Cloud's GaussDB for Influx architecture and compression breakthroughs, and shares the engineering challenges and real‑world benefits of building a cloud‑native TSDB for massive monitoring workloads.
GaussDBIoTcloud-native
0 likes · 10 min read


ITPUBJun 30, 2021 · Databases
This article explains the limitations of open‑source Redis, introduces Huawei Cloud's GaussDB for Redis with its compute‑storage separation architecture, details its design, implementation, and disaster‑recovery mechanisms, and summarizes the competitive advantages such as strong consistency, high availability, elastic scaling, and superior performance.
GaussDBNoSQLRedis
0 likes · 14 min read

This article explains the fundamentals, application scenarios, key requirements, and open‑source options for time series databases, highlighting how GaussDB (For Influx) addresses high‑performance writes, massive timelines, low storage cost, and elastic scaling for IoT and cloud monitoring workloads.
GaussDBInfluxDBIoT
0 likes · 10 min read

This article outlines a comprehensive plan for deploying GaussDB T, covering the software architecture, component roles, and practical guidelines for single‑node, primary‑standby, and distributed setups, while highlighting common pitfalls and operational considerations for production environments.
Database ArchitectureGaussDBHigh Availability
0 likes · 13 min read

This tutorial walks you through preparing the environment, configuring cluster components, installing required packages, setting up Python 3.7, running pre‑install checks, executing the GaussDB installation script, handling common errors, and finally uninstalling the cluster on a CentOS 7.5 system.
CentOSDatabase ClusterGaussDB
0 likes · 14 min read

This article walks through the entire Oracle‑to‑GaussDB migration process with Huawei DataSync, covering environment setup, tool constraints, NFS mounting, JDBC driver preparation, configuration file editing, password encryption, export and import execution, and post‑migration validation.
DataSyncDatabase MigrationGaussDB
0 likes · 15 min read

This guide walks you through the essential daily maintenance tasks for GaussDB T clusters, covering ETCD startup, cluster health checks, host resource monitoring, tablespace usage, abnormal wait events, log inspection, and common error troubleshooting with concrete commands and SQL examples.
Database MaintenanceGaussDBPerformance Monitoring
0 likes · 11 min read

The Global Data Infrastructure Forum in Shenzhen gathered industry leaders and academics to discuss database ecosystem building, GaussDB's new naming and compatibility certification, the ZnSQL and ZnAiops platforms, and Huawei's comprehensive digital transformation methodology encompassing strategic goals and a five‑step implementation framework.
Data InfrastructureGaussDBcompatibility
0 likes · 13 min read
