BestHub
Sign in
Tagged articles
30 articles
Page 1 of 1
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Aug 8, 2025 · Databases

GaussDB-Powered Database Textbook: Transforming Teaching & Practice

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.

Curriculum ReformDatabase EducationDatabase Management
0 likes · 10 min read
GaussDB-Powered Database Textbook: Transforming Teaching & Practice
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Aug 29, 2024 · Databases

Boost MySQL Queries: How GaussDB’s Limit‑Offset Pushdown Cuts Execution Time

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 PerformanceGaussDBPushdown Optimization
0 likes · 13 min read
Boost MySQL Queries: How GaussDB’s Limit‑Offset Pushdown Cuts Execution Time
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Jul 3, 2024 · Databases

How WeTune 2.0 Automates SQL Query Rewrite for GaussDB Performance Boost

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
How WeTune 2.0 Automates SQL Query Rewrite for GaussDB Performance Boost
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
May 8, 2024 · Databases

How GaussDB’s Fine‑Grained Resource Control Optimizes Multi‑Tenant Performance

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
How GaussDB’s Fine‑Grained Resource Control Optimizes Multi‑Tenant Performance
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Apr 24, 2024 · Databases

How Does GaussDB Execute SQL? Inside Its Engine and Optimization

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 ArchitectureGaussDBSQL Engine
0 likes · 15 min read
How Does GaussDB Execute SQL? Inside Its Engine and Optimization
MaGe Linux Operations
MaGe Linux Operations
Feb 26, 2024 · Databases

Why MySQL Single Tables Hit Performance Limits and How B‑Link Trees Help

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
Why MySQL Single Tables Hit Performance Limits and How B‑Link Trees Help
MaGe Linux Operations
MaGe Linux Operations
Feb 21, 2024 · Databases

How to Deploy Fine-Grained Disaster Recovery for GaussDB DWS on Cloud

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.

GaussDBclouddisaster recovery
0 likes · 20 min read
How to Deploy Fine-Grained Disaster Recovery for GaussDB DWS on Cloud
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Aug 25, 2023 · Databases

Unlock GaussDB(DWS) Performance: Expert Tips for Resource Management

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.

Database TuningGaussDBHuawei Cloud
0 likes · 3 min read
Unlock GaussDB(DWS) Performance: Expert Tips for Resource Management
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Aug 4, 2023 · Databases

How GaussDB(DWS) HStore Tables Enable Real‑Time Ingestion and Lightning‑Fast Queries

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.

ColumnarData WarehousingDatabase Storage
0 likes · 8 min read
How GaussDB(DWS) HStore Tables Enable Real‑Time Ingestion and Lightning‑Fast Queries
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Jun 12, 2023 · Fundamentals

Boosting GaussDB Performance: Inside Huawei’s BiSheng Compiler Optimizations

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.

BISHENGCompiler OptimizationGaussDB
0 likes · 8 min read
Boosting GaussDB Performance: Inside Huawei’s BiSheng Compiler Optimizations
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Mar 28, 2023 · Databases

What’s Next for Data Warehouses? From History to Future Trends

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.

Big DataData IntegrationDatabase Architecture
0 likes · 8 min read
What’s Next for Data Warehouses? From History to Future Trends
ITPUB
ITPUB
Feb 22, 2023 · Databases

How Huawei’s GaussDB(DWS) 3.0 Redefines Cloud‑Native Data Warehousing

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 integrationCloud NativeGaussDB
0 likes · 16 min read
How Huawei’s GaussDB(DWS) 3.0 Redefines Cloud‑Native Data Warehousing
ITPUB
ITPUB
Feb 20, 2023 · Databases

Why Teradata Is Leaving China and What It Means for the Domestic Data Warehouse Market

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.

Big DataGBaseGaussDB
0 likes · 9 min read
Why Teradata Is Leaving China and What It Means for the Domestic Data Warehouse Market
Xingsheng Youxuan Technology Community
Xingsheng Youxuan Technology Community
Aug 30, 2022 · Big Data

How to Build a Unified Big Data Security Platform with Ranger and Custom Authorization

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.

AuthorizationBig DataDistributed Systems
0 likes · 17 min read
How to Build a Unified Big Data Security Platform with Ranger and Custom Authorization
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Sep 2, 2021 · Databases

Why Time‑Series Databases Are the Backbone of IoT and Cloud‑Native Ops

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
Why Time‑Series Databases Are the Backbone of IoT and Cloud‑Native Ops
ITPUB
ITPUB
Jun 30, 2021 · Databases

Why GaussDB for Redis Outperforms Open‑Source Redis: Architecture, Benefits, and Real‑World Performance

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.

Compute-Storage SeparationGaussDBNoSQL
0 likes · 14 min read
Why GaussDB for Redis Outperforms Open‑Source Redis: Architecture, Benefits, and Real‑World Performance
dbaplus Community
dbaplus Community
Mar 29, 2020 · Databases

Mastering GaussDB T: Planning Single‑Node, HA, and Distributed Architectures

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 ArchitectureGaussDBPlanning
0 likes · 13 min read
Mastering GaussDB T: Planning Single‑Node, HA, and Distributed Architectures
dbaplus Community
dbaplus Community
Mar 15, 2020 · Databases

Step-by-Step Guide to Installing GaussDB T 1.0.2 HA Cluster on CentOS

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
Step-by-Step Guide to Installing GaussDB T 1.0.2 HA Cluster on CentOS
dbaplus Community
dbaplus Community
Feb 22, 2020 · Databases

How to Perform Daily Maintenance on GaussDB T Clusters Without Pitfalls

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.

Cluster ManagementDatabase MaintenanceError Handling
0 likes · 11 min read
How to Perform Daily Maintenance on GaussDB T Clusters Without Pitfalls
dbaplus Community
dbaplus Community
Nov 20, 2019 · Databases

Key Takeaways: Database Ecosystem & GaussDB Compatibility at Global Data Forum

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.

CompatibilityDigital TransformationEcosystem
0 likes · 13 min read
Key Takeaways: Database Ecosystem & GaussDB Compatibility at Global Data Forum