BestHub
Sign in
dbaplus Community
Author

dbaplus Community

Enterprise-level professional community for Database, BigData, and AIOps. Daily original articles, weekly online tech talks, monthly offline salons, and quarterly XCOPS&DAMS conferences—delivered by industry experts.

2.2k
Articles
1
Likes
1.3k
Views
0
Comments
Recent Articles

Latest from dbaplus Community

100 recent articles max
dbaplus Community
dbaplus Community
Dec 8, 2025 · Databases

Which Database Wins IP Range Lookups? ClickHouse vs Doris vs Redis Benchmarks

This article presents a systematic benchmark comparing ClickHouse, Doris, and Redis for IP‑range dimension lookups using Flink‑Kafka pipelines, detailing test design, result table schema, query interfaces, and performance results across varying data rates, concluding that Redis offers the fastest and most stable query latency.

ClickHouseDatabase BenchmarkFlink
0 likes · 7 min read
Which Database Wins IP Range Lookups? ClickHouse vs Doris vs Redis Benchmarks
dbaplus Community
dbaplus Community
Dec 7, 2025 · Databases

Postgres vs MySQL: Deep Dive into Indexes, Query Costs, and MVCC

An in‑depth comparison of PostgreSQL and MySQL examines how primary and secondary indexes are implemented, contrasts query execution costs, explores data type impacts, explains MVCC undo logs, and discusses process versus thread architectures, highlighting performance trade‑offs for each system.

IndexesMVCCMySQL
0 likes · 13 min read
Postgres vs MySQL: Deep Dive into Indexes, Query Costs, and MVCC
dbaplus Community
dbaplus Community
Dec 7, 2025 · Artificial Intelligence

How AI Agents Can Revolutionize Data Governance: A Step‑by‑Step Blueprint

This article explains how AI agents transform traditional data governance by introducing a four‑layer perception‑decision‑execution‑learning architecture, detailing the required technologies, tool integrations, code examples, deployment steps, team roles, security safeguards, and practical rollout strategies for enterprises seeking automated, intelligent data management.

AI AgentData qualityLangChain
0 likes · 10 min read
How AI Agents Can Revolutionize Data Governance: A Step‑by‑Step Blueprint
dbaplus Community
dbaplus Community
Dec 6, 2025 · Big Data

Why Precise Data Warehouse Naming Boosts Efficiency and Cuts Costs

In the era of digital transformation, chaotic data warehouse naming wastes resources, while a well‑defined naming convention improves maintainability, collaboration, and business value, as demonstrated by real‑world cases showing three‑fold query speed gains and up to 60% reduction in cross‑team effort.

Data WarehouseNaming Conventionsbest practices
0 likes · 6 min read
Why Precise Data Warehouse Naming Boosts Efficiency and Cuts Costs
dbaplus Community
dbaplus Community
Dec 4, 2025 · Fundamentals

Exploring Linux Filesystems: VFS, ext2 Superblock, and Inode Access

This article guides readers through Linux file system fundamentals, explaining the role of the virtual file system (VFS), detailed structures of the ext2 superblock, group descriptors, block and inode bitmaps, and provides C code examples for extracting and reading file data directly via inode numbers.

C programmingDisk LayoutExt2
0 likes · 27 min read
Exploring Linux Filesystems: VFS, ext2 Superblock, and Inode Access
dbaplus Community
dbaplus Community
Dec 3, 2025 · Databases

Why SQLite Beats PostgreSQL in Embedded Environments – Version Guide & Concurrency Insights

This article compares SQLite and PostgreSQL, presents detailed SQLite version timelines and OS compatibility tables, explains the differences between rollback‑journal and WAL concurrency models, shows a simple multi‑process lock test, and concludes that SQLite 3.45 is the most suitable choice for modern Linux, macOS, Android and iOS deployments.

PostgreSQLSQLiteVersion Compatibility
0 likes · 14 min read
Why SQLite Beats PostgreSQL in Embedded Environments – Version Guide & Concurrency Insights
dbaplus Community
dbaplus Community
Dec 2, 2025 · Databases

Adapting goInception for OceanBase MySQL: Full Guide with Python Integration

This article walks through the challenges of using goInception with OceanBase‑MySQL tenants, details the code modifications required to parse OB's Query Plan, shows how to expose the enhanced engine via a Python wrapper, and presents validation results demonstrating accurate, low‑latency SQL auditing.

OB-MySQLOceanBasePython
0 likes · 10 min read
Adapting goInception for OceanBase MySQL: Full Guide with Python Integration
dbaplus Community
dbaplus Community
Nov 30, 2025 · Databases

How Uber Scales Database Backup and Recovery to Petabytes

This article explains how Uber built a robust, continuously backed‑up and recoverable database platform that handles tens of petabytes of data, detailing the challenges, architecture, scheduling, backup and restore frameworks, and the technology‑specific snapshot logic that enable fast RPO/RTO at massive scale.

BackupRecoveryUber
0 likes · 14 min read
How Uber Scales Database Backup and Recovery to Petabytes
dbaplus Community
dbaplus Community
Nov 26, 2025 · Databases

How Meituan’s Database Capacity Assessment System Boosts Stability and Efficiency

Meituan’s Database Capacity Assessment System uses online traffic replay, accelerated load testing, and automated analysis to safely evaluate and optimize database read/write capacity, providing real‑time operation insights, flexible scaling, and reliable change‑risk mitigation for large‑scale production environments.

AutomationMeituancapacity planning
0 likes · 17 min read
How Meituan’s Database Capacity Assessment System Boosts Stability and Efficiency