Databases

Showing 100 articles max

Aug 7, 2026 · Databases

Day 50: Relational Database Normalization – From Functional Dependencies to Normal Form Decomposition

This lesson walks through relational database normalization using a messy enrollment table, showing how to derive functional dependencies, identify candidate keys, detect partial, transitive and BCNF violations, and systematically decompose the schema into student, major, course, teacher and enrollment tables while ensuring lossless joins and dependency preservation.

BCNFRelational DatabaseSQL

0 likes · 30 min read

Day 50: Relational Database Normalization – From Functional Dependencies to Normal Form Decomposition

Ray's Galactic Tech

Aug 7, 2026 · Databases

OLAP Engine Selection for Billion‑Row Analytics: Doris, ClickHouse, StarRocks

This guide compares Doris, ClickHouse, and StarRocks for billion‑row real‑time analytics, outlining their strengths and weaknesses across write throughput, update handling, join performance, concurrency, cost, and operational complexity, and provides concrete modeling, ingestion, query governance, and fault‑tolerance recommendations to help teams choose the most suitable OLAP platform.

ClickHouseDorisFlink

0 likes · 32 min read

OLAP Engine Selection for Billion‑Row Analytics: Doris, ClickHouse, StarRocks

ITPUB

Aug 7, 2026 · Databases

The Evolution and Practice of Multi-Write Multi-Read Shared Storage Clusters – UXDB SRAC Whitepaper

The whitepaper released by Youxuan Database outlines the market size of the DBMS industry, traces the technical evolution of multi‑write multi‑read shared‑storage clusters from early research to modern implementations, details the UXDB SRAC architecture and its innovations, and validates its feasibility through certifications, benchmark results, and real‑world case studies.

UXDB SRACcache fusioncluster database

0 likes · 9 min read

The Evolution and Practice of Multi-Write Multi-Read Shared Storage Clusters – UXDB SRAC Whitepaper

ITPUB

Aug 7, 2026 · Databases

Left Join: ON vs WHERE – Understanding the Crucial Difference

The article explains that in a LEFT JOIN the ON clause determines how rows are matched but never filters out rows from the left table, while a WHERE clause is applied after the join and can remove left‑table rows, illustrated with concrete SQL examples and step‑by‑step analysis.

DatabaseLeft JoinON clause

0 likes · 5 min read

Left Join: ON vs WHERE – Understanding the Crucial Difference

Xike

Aug 7, 2026 · Databases

Embedding Sharding Genes in Business IDs for Direct Routing in Sharded Databases

By embedding a shard identifier (“gene”) into the low bits of a business ID generated via Redis INCR or similar sequencers, the article shows how to achieve direct table routing without broadcast queries or extra mapping tables, detailing the algorithm, implementation, integration with Snowflake and Leaf, and common pitfalls.

JavaLeafRedis

0 likes · 11 min read

Embedding Sharding Genes in Business IDs for Direct Routing in Sharded Databases

AI Large-Model Wave and Transformation Guide

Aug 6, 2026 · Databases

Ontology vs Graph Inference Engine: How the Wrong Choice Can Render Your Knowledge Graph Useless

Choosing between OWL‑based ontologies and graph‑database inference engines fundamentally affects knowledge‑graph design: ontologies provide formal logical consistency and open‑world reasoning, while graph inference offers fast, flexible queries, with each suited to different constraints, scalability, and maintenance scenarios.

Graph DatabaseNeo4jOWL

0 likes · 9 min read

Ontology vs Graph Inference Engine: How the Wrong Choice Can Render Your Knowledge Graph Useless

Ray's Galactic Tech

Aug 6, 2026 · Databases

Taming Message Storms: Redis 7.x Engineering Practices for Enterprise Live‑Streaming Platforms

This article dissects why a simple Redis upgrade is insufficient for large‑scale live streaming, then walks through how Redis 7’s Sharded Pub/Sub, Function, and ACL v2 features together eliminate broadcast storms, streamline script governance, and enforce fine‑grained multi‑tenant control, backed by concrete architecture diagrams, production‑grade Java code, capacity planning, monitoring, rollout procedures, and real‑world benchmark results.

ACLHigh ConcurrencyRedis

0 likes · 41 min read

Taming Message Storms: Redis 7.x Engineering Practices for Enterprise Live‑Streaming Platforms

MaGe Linux Operations

Aug 6, 2026 · Databases

How to Determine the Right Database Connection Pool Size: Practical Guidelines and Benchmarks

This article walks through a systematic approach to sizing PostgreSQL connection pools for Java applications using HikariCP and Spring Boot, covering capacity budgeting, workload‑driven calculations, monitoring metrics, slow‑SQL analysis, leak detection, Kubernetes deployment considerations, and safe rollout practices.

Connection PoolHikariCPKubernetes

0 likes · 27 min read

How to Determine the Right Database Connection Pool Size: Practical Guidelines and Benchmarks

Raymond Ops

Aug 6, 2026 · Databases

Diagnosing and Eliminating MySQL Deadlocks in Production

This article explains how MySQL deadlocks arise, details the four necessary conditions, compares lock types, shows how to enable detailed deadlock logging, query lock metadata, interpret logs, and provides practical code‑level and configuration strategies to prevent and resolve common deadlock scenarios in production environments.

DeadlockInnoDBMySQL

0 likes · 20 min read

Diagnosing and Eliminating MySQL Deadlocks in Production

macrozheng

Aug 6, 2026 · Databases

RedisInsight: A Stunning Official Redis Visualization Tool with Powerful Features

This article introduces RedisInsight, the official Redis visualization tool, walks through its Docker-based installation, showcases its graphical interface for data types, built-in workbench, slow‑log and memory analysis, JSON editing, theme switching, and provides a quick hands‑on experience for beginners.

Database ManagementDockerRedis

0 likes · 5 min read

RedisInsight: A Stunning Official Redis Visualization Tool with Powerful Features

liandk

Aug 5, 2026 · Databases

Mastering Redis High Availability: Replication, Sentinel, and Cluster Explained

The article explains why Redis must be highly available and walks through three progressive architectures—master‑slave replication, Sentinel automatic failover, and Redis Cluster—detailing their mechanisms, advantages, drawbacks, and when to choose each for small, medium, or large‑scale production systems.

Database ScalingRedisSentinel

0 likes · 7 min read

Mastering Redis High Availability: Replication, Sentinel, and Cluster Explained

Data Integration and Governance

Aug 5, 2026 · Databases

8 Essential Data Modeling Techniques Every Data Engineer Should Know

The article explains why data modeling is the bridge between business processes and analytical applications, breaks down eight common modeling methods—including ER, 3NF, dimensional, star, snowflake, wide‑table, Data Vault, and subject‑oriented models—detailing their purposes, strengths, trade‑offs, and how they fit into a layered data‑warehouse architecture.

Data ModelingData VaultER Model

0 likes · 16 min read

8 Essential Data Modeling Techniques Every Data Engineer Should Know

Architect's Guide

Aug 5, 2026 · Databases

How to Combine Pagination and Multi‑Condition Fuzzy Search in Redis

This article explains how to implement pagination using Redis Sorted Sets, achieve multi‑condition fuzzy queries with Hashes and HSCAN, and then combine both techniques into a single solution while discussing performance trade‑offs and optimization strategies such as key expiration and data‑sync methods.

Fuzzy SearchHSCANPagination

0 likes · 9 min read

How to Combine Pagination and Multi‑Condition Fuzzy Search in Redis

MaGe Linux Operations

Aug 4, 2026 · Databases

Why 70% of System Outages Stem from SQL Performance: A MySQL Index Optimization Guide

The article walks through a systematic MySQL 8.0 index‑optimization workflow—starting with diagnosing slow queries and lock waits, validating execution plans with EXPLAIN ANALYZE, safely adding or dropping indexes using online DDL, handling pagination patterns, and verifying improvements via comprehensive metrics before and after.

EXPLAIN ANALYZEMySQLOnline DDL

0 likes · 12 min read

Why 70% of System Outages Stem from SQL Performance: A MySQL Index Optimization Guide

System Architect Go

Aug 4, 2026 · Databases

Quick PostgreSQL Guide for MySQL Users: Beyond Syntax Differences

This article walks MySQL developers through the essential architectural, schema, data‑type, SQL‑dialect, transaction, vacuum, indexing, and extension differences when moving to PostgreSQL, providing concrete examples, code snippets, and best‑practice recommendations to avoid common pitfalls.

DatabaseMigrationMySQL

0 likes · 38 min read

Quick PostgreSQL Guide for MySQL Users: Beyond Syntax Differences

Java Tech Workshop

Aug 4, 2026 · Databases

R2DBC vs JDBC: Choosing the Right Persistence for Reactive Spring Boot Projects

This article compares Spring Data JDBC and Spring Data R2DBC for Spring Boot 3.x/4.x projects, detailing setup, Maven dependencies, configuration, entity definitions, repository and service implementations, transaction handling, performance trade‑offs, and provides a hybrid approach that wraps JDBC calls in reactive Monos for WebFlux, helping developers decide which persistence layer best fits their reactive architecture.

Database AccessR2DBCReactive Programming

0 likes · 22 min read

R2DBC vs JDBC: Choosing the Right Persistence for Reactive Spring Boot Projects

samdeepthink

Aug 4, 2026 · Databases

Choosing the Best Composite Index for A = ?, B IN (...), ORDER BY C

The article explains why placing column C immediately after the equality column A in a composite index (A, C, B) avoids filesort and keeps performance stable regardless of how many values appear in the B IN list, outperforming other index orders such as (A, B, C).

Composite IndexFilesortIN Clause

0 likes · 10 min read

Choosing the Best Composite Index for A = ?, B IN (...), ORDER BY C

Raymond Ops

Aug 3, 2026 · Databases

How to Diagnose MySQL Slow Queries Without Relying on Blind Indexing

This guide walks through a systematic approach to uncovering and fixing MySQL slow queries, covering slow‑query‑log configuration, log analysis with mysqldumpslow and pt‑query‑digest, EXPLAIN‑based execution‑plan inspection, index design principles, SQL rewrites, configuration tuning, and ongoing monitoring to prevent performance regressions.

EXPLAINMySQLPerformance Tuning

0 likes · 27 min read

How to Diagnose MySQL Slow Queries Without Relying on Blind Indexing

Java Architect Handbook

Aug 3, 2026 · Databases

Redis Officially Launches RedisInsight: A Stunning GUI with Powerful Features

RedisInsight is a visual GUI for Redis that uniquely supports Redis Cluster, offers SSL/TLS connections, memory analysis and an integrated CLI; the article walks through downloading the package, configuring environment variables, starting the service on Linux, deploying it on Kubernetes with a YAML manifest, and using the UI to monitor and operate Redis instances.

GUIKubernetesMemory Analysis

0 likes · 8 min read

Redis Officially Launches RedisInsight: A Stunning GUI with Powerful Features

Lobster Programming

Aug 3, 2026 · Databases

How to Eliminate MySQL Master‑Slave Lag: Parallel Replication, Read‑Routing, and Redis Marking

To address MySQL master‑slave replication lag, the article explains enabling parallel replication (setting slave_parallel_workers), routing reads to the master for latency‑sensitive operations, and using a Redis short‑term marker to direct recent writes to the master, while outlining configuration steps and trade‑offs.

Database LagMySQLParallel Replication

0 likes · 6 min read

How to Eliminate MySQL Master‑Slave Lag: Parallel Replication, Read‑Routing, and Redis Marking