Tagged articles
openGauss
20 articles · Page 1 of 1
This article compares five major Chinese domestic databases across three technical generations—traditional centralized (Dameng, Kingbase), open-source modified (openGauss), and self-developed distributed (OceanBase, TiDB)—detailing their kernel origins, compatibility targets, strengths, weaknesses, and a decision framework based on compliance requirements, existing workload, scale, and operational readiness.
DamengHTAPKingbase
0 likes · 9 min read

This article walks you through the complete process of switching to a domestically‑produced Linux stack by downloading and installing the openEuler operating system, configuring its package sources, installing required tools, then adding the openGauss database, adjusting its configuration files, and verifying successful deployment, all on a VM or physical server.
Database SetupLinux Installationfirewall disable
0 likes · 6 min read

This tutorial provides a step-by-step guide to deploying openGauss database using Docker Compose, covering environment setup, directory creation, docker-compose.yml configuration with persistent storage and environment variables, container startup, service verification, and troubleshooting common issues like password policy and permission errors.
ContainerizationDocker Composedatabase deployment
0 likes · 9 min read

This tutorial walks you through downloading the OpenEuler ISO, installing the OS on a server or VMware VM, configuring yum sources, installing and configuring the openGauss database, setting up network and firewall, and optionally using Data Studio for visual management, all with detailed commands and screenshots.
openEuleropenGauss
0 likes · 8 min read

This guide provides step‑by‑step shell scripts, directory setups, cron jobs, and cleanup commands for reliable backup and restore of Oracle (RMAN and logical), MySQL (full, incremental, Percona XtraBackup), PostgreSQL (logical and physical with pg_rman), and openGauss databases, including retention policies and automation tips.
MySQLOraclePostgreSQL
0 likes · 19 min read

The author reflects on a decade‑plus journey through China’s DTCC database conferences, describing personal growth from novice to speaker and organizer, sharing insights on Redis Cluster, distributed database selection, openGauss, time‑series databases, and the evolving themes that chart the industry's progress.
Rediscareer developmentconference
0 likes · 6 min read


ITPUBAug 7, 2024 · Databases
This guide provides a comprehensive collection of ready-to-use shell scripts and step-by-step instructions for backing up and restoring major databases—including Oracle RMAN, logical and physical backups, MySQL full and incremental backups with Xtrabackup, PostgreSQL logical and physical backups, and openGauss dump scripts—plus scheduling and cleanup procedures.
MySQLOraclePostgreSQL
0 likes · 19 min read


ITPUBJan 18, 2023 · Cloud Native
China Postal Savings Bank’s three‑year, 3‑thousand‑person effort delivered a cloud‑native, distributed core banking platform that migrated 650 million customers with a 67,000 TPS peak, 65 ms transaction latency and dramatically improved processing times, showcasing the power of open‑source databases and micro‑service architecture.
core bankingdistributed architectureopenGauss
0 likes · 14 min read

The article examines why openGauss 2.0/3.0 cannot use Index‑Only Scan for covering indexes, explores the role of the visibility map and VACUUM, compares behavior with PostgreSQL 11, and shows how the USTORE storage engine can finally enable true covering indexes.
Covering IndexDatabase MigrationIndex Only Scan
0 likes · 11 min read

The article explains the fundamental differences between row‑based and column‑based storage in databases, compares their write and read performance, presents a practical openGauss experiment showing storage size and insert speed differences, and offers guidance on when to choose each model.
Column StoreRow StoreStorage
0 likes · 8 min read

This article explains the fundamental differences between row‑based and column‑based storage in databases, compares their write and read performance, lists pros and cons, presents an openGauss experiment with sample tables, and offers practical guidance on when to choose each storage model.
Column StorageData CompressionDatabase Performance
0 likes · 9 min read

This article explains the fundamental differences between row‑based and column‑based storage in relational databases, compares their performance for writes, reads, compression and use cases, presents an openGauss experiment with sample tables and SQL commands, and offers practical guidance on when to choose each storage model.
Column StoreDatabase StorageRow Store
0 likes · 10 min read

This article compares row‑based and column‑based storage models, analyzes their write and read performance, presents a practical openGauss experiment showing size and insert‑time differences, and offers concrete guidance on selecting the appropriate storage type for various workloads.
Column StoreDatabase StorageRow Store
0 likes · 10 min read

This article explains the differences between row-based and column-based storage in databases, compares their advantages and disadvantages, presents experimental results using openGauss including space usage and insert performance, and offers practical guidance on selecting the appropriate storage model for various workloads.
Column StoreDatabase StorageRow Store
0 likes · 10 min read

This article explains the fundamental differences between row‑based and column‑based storage in databases, compares their read/write performance, presents experimental results on openGauss showing space and speed trade‑offs, and offers practical guidance on when to choose each storage model.
Column StoreDatabase StorageRow Store
0 likes · 11 min read


ITPUBOct 8, 2021 · Cloud Native
The article examines how Postal Savings Bank of China tackled legacy core banking limitations by designing a distributed, cloud‑native core system using openGauss, Kunpeng hardware, microservices, and DevOps, detailing the architecture, deployment process, performance gains, and industry implications.
Kunpengcore bankingdistributed systems
0 likes · 10 min read

This article examines how openGauss implements Oracle SQL compatibility, covering query syntax like ROWNUM and DUAL, unsupported CONNECT BY, HINT handling, execution‑plan commands, Oracle functions such as DECODE, SYSDATE, NVL/NVL2, PL/SQL UDFs, stored procedures, triggers, cursors, VARRAYs, and provides a detailed compatibility summary.
Oracle compatibilityPL/SQLSQL dialect
0 likes · 13 min read

This article evaluates the compatibility of Oracle logical objects—indexes, constraints, views, sequences, and synonyms—in openGauss, detailing each object type, providing concrete SQL examples, highlighting differences such as bitmap index support, and summarizing the overall compatibility in a concise table.
Oracle compatibilitySequencesSynonyms
0 likes · 11 min read

This article traces the evolution of openGauss from its Huawei roots and systematically evaluates how well openGauss 1.0.0 supports Oracle’s various table types, providing creation examples, compatibility results, and guidance on work‑arounds for unsupported features.
OraclePartitioningSQL
0 likes · 15 min read

This article evaluates whether openGauss can serve as an Oracle replacement in OLTP scenarios by systematically testing compatibility of Oracle's character, numeric, date/time, large object, ROWID, and RAW data types, presenting command‑line results and practical substitution recommendations.
Database MigrationOracleSQL
0 likes · 14 min read
