BestHub
Sign in
Tagged articles
625 articles
Page 4 of 7
Architects Research Society
Architects Research Society
May 7, 2022 · Backend Development

System Design of Hotel Booking Applications: Microservices Architecture, Databases, and Messaging

This article explains how large hotel‑booking platforms such as Airbnb, Booking.com and OYO use a micro‑services architecture, load balancers, master‑slave databases, caching, message queues, Elasticsearch, Cassandra and Hadoop to deliver seamless hotel management, search, booking and view‑booking services at massive scale.

Backend ArchitectureMessagingSystem Design
0 likes · 7 min read
System Design of Hotel Booking Applications: Microservices Architecture, Databases, and Messaging
Xiao Lou's Tech Notes
Xiao Lou's Tech Notes
May 5, 2022 · Databases

How We Scaled a Ride‑Hailing Order System: From Single DB to Sharded MySQL

This article chronicles the step‑by‑step evolution of a ride‑hailing order service, detailing how a single SQLServer database was optimized, split by business domain, migrated to MySQL, and finally sharded with a custom client‑side component, while leveraging read/write separation, caching, MQ, and data‑exchange platforms to sustain massive traffic.

cachingdatabasesmigration
0 likes · 15 min read
How We Scaled a Ride‑Hailing Order System: From Single DB to Sharded MySQL
21CTO
21CTO
Apr 19, 2022 · Information Security

Web Scraping Legalized and Chrome Zero‑Day Patched: Key Tech Updates

Recent developments include a US appellate court affirming that publicly accessible web data can be scraped legally, Google releasing an emergency Chrome 100.0.4896.127 patch for the critical CVE‑2022‑1364 V8 type‑confusion flaw, DB‑Engines’ latest database popularity rankings highlighting Redis’s rise, and Mullvad’s Firefox‑only privacy extension becoming open‑source.

Browser SecurityWeb Scrapingdatabases
0 likes · 6 min read
Web Scraping Legalized and Chrome Zero‑Day Patched: Key Tech Updates
ITPUB
ITPUB
Apr 11, 2022 · Databases

How to Optimize Chinese Domestic Databases: Practical DBA Tips Beyond Benchmarks

This article shares experienced DBA insights on optimizing Chinese domestic databases, highlighting why traditional Oracle benchmark tweaks often fail, the limited value of buffer‑hit metrics, the importance of OS I/O tuning, SQL plan baselines, and handling high‑concurrency bottlenecks such as spinlock contention.

OS I/OSQL TuningTPMC
0 likes · 7 min read
How to Optimize Chinese Domestic Databases: Practical DBA Tips Beyond Benchmarks
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 15, 2022 · Databases

Using MySQL 8.0.27 Multi‑Factor Authentication with the authentication_policy Variable

This article explains how MySQL 8.0.27 adds multi‑factor authentication (MFA) via the new authentication_policy system variable, demonstrates configuring the variable, creating users with single or multiple authentication plugins, installing external plugins, and verifies MFA behavior with practical Docker‑based examples.

MFAauthentication_policydatabases
0 likes · 10 min read
Using MySQL 8.0.27 Multi‑Factor Authentication with the authentication_policy Variable
Top Architect
Top Architect
Mar 12, 2022 · Databases

Understanding Redis Eviction Policies and Memory Management

This article explains Redis's in‑memory database architecture, detailing data locality, various eviction policies such as LRU, LFU, random and TTL, their configuration via maxmemory settings, and provides code examples of the eviction process and memory‑freeing functions.

LFULRUMemory Management
0 likes · 17 min read
Understanding Redis Eviction Policies and Memory Management
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 5, 2022 · Databases

Weekly Community Tech Digest – MySQL Updates, Middleware Progress, and Community News

This weekly digest summarizes the latest MySQL 8.0 enhancements, replication delay case, user connection memory limits, Oracle‑to‑MySQL synchronization, new SQLE release, DBLE middleware developments, bug fixes, community Q&A, recruitment notices, and upcoming plans, providing concise technical insights for the open‑source community.

Weekly Digestcommunitydatabases
0 likes · 4 min read
Weekly Community Tech Digest – MySQL Updates, Middleware Progress, and Community News
Top Architect
Top Architect
Mar 4, 2022 · Databases

Why Redis Is So Fast: Architecture, Single‑Thread Model, and Multithreading in Redis 6.0

This article explains why Redis achieves high throughput—up to 100,000 QPS—by leveraging in‑memory storage, simple data structures, a single‑threaded event loop with I/O multiplexing, and the optional multithreaded I/O model introduced in Redis 6.0, including configuration details and safety considerations.

Single Threaddatabasesmultithreading
0 likes · 8 min read
Why Redis Is So Fast: Architecture, Single‑Thread Model, and Multithreading in Redis 6.0
Big Data Technology & Architecture
Big Data Technology & Architecture
Feb 22, 2022 · Databases

ClickHouse Best Practices: Table Engines, Cluster Architecture, and Operational Guidelines

This guide provides a comprehensive overview of ClickHouse, covering its core use cases, detailed table‑engine choices, cluster design, Zookeeper integration, query and data‑loading best practices, client tools, and key configuration parameters to ensure high performance and reliability in OLAP workloads.

Cluster ArchitectureOLAPTable Engines
0 likes · 23 min read
ClickHouse Best Practices: Table Engines, Cluster Architecture, and Operational Guidelines
ITPUB
ITPUB
Feb 10, 2022 · Cloud Native

Why Cloud‑Native Databases Are Redefining Data Management in 2024

Cloud‑native databases have shifted from simple containerized services to comprehensive, elastic solutions that integrate multiple engines and distributed technologies, offering horizontal scaling, fine‑grained billing, and high‑performance architectures, while enterprises must evaluate vendor perspectives and choose between public‑cloud services or private‑cloud implementations.

Distributed Systemscloud-nativedatabases
0 likes · 8 min read
Why Cloud‑Native Databases Are Redefining Data Management in 2024
IT Services Circle
IT Services Circle
Feb 5, 2022 · Databases

Recommended Technical Books for 2022: Databases, Java, Architecture, and More

To help readers set their 2022 learning goals, this article curates a list of 15 essential technical books covering database fundamentals, MySQL, Redis, Java core, concurrency, JVM, code quality, software craftsmanship, architecture, distributed systems, and microservices, with brief insights and personal recommendations.

Book RecommendationsMicroservicesdatabases
0 likes · 9 min read
Recommended Technical Books for 2022: Databases, Java, Architecture, and More
Architecture & Thinking
Architecture & Thinking
Feb 5, 2022 · Fundamentals

Essential Study Resources: 16 Curated Book Collections for Java, Databases & Cloud Native

This article compiles sixteen categories of learning materials, detailing the number of books for each topic—including Java, databases, caching, messaging, MongoDB, search, Zookeeper, networking, design patterns, data structures and algorithms, distributed systems, cloud‑native microservices, containers, service mesh, DevOps, and operating systems—along with a Baidu link and extraction code for access.

Cloud NativeDistributed Systemsdatabases
0 likes · 2 min read
Essential Study Resources: 16 Curated Book Collections for Java, Databases & Cloud Native
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Jan 26, 2022 · Cloud Native

2021 Technology Year-End Review: Serverless, Kubernetes, Frontend, Service Mesh, Rust, Databases, Software 2.0, and Audio/Video Trends

The 2021 year‑end review highlights the rapid rise of Serverless, the accelerated release cadence and security focus of Kubernetes, the deepening of frontend low‑code development, the practical expansion of service mesh, the growing Rust ecosystem, cloud‑native database evolution, the maturation of Software 2.0, and emerging audio‑video innovations driven by the metaverse.

Cloud NativeKubernetesRust
0 likes · 14 min read
2021 Technology Year-End Review: Serverless, Kubernetes, Frontend, Service Mesh, Rust, Databases, Software 2.0, and Audio/Video Trends
Qunar Tech Salon
Qunar Tech Salon
Jan 24, 2022 · Databases

Qunar 2021 Technical Salon – Infrastructure Articles Collection (Databases, Operations, Components)

This article compiles the 2021 Qunar Technical Salon infrastructure series, presenting original technical writings on databases, operational practices, and core components, each linked to detailed posts that share real‑world experiences, design guidelines, and performance insights for engineers and practitioners.

DevOpsInfrastructureOperations
0 likes · 7 min read
Qunar 2021 Technical Salon – Infrastructure Articles Collection (Databases, Operations, Components)
Alibaba Cloud Developer
Alibaba Cloud Developer
Jan 20, 2022 · Databases

How Cloud‑Native Databases Are Redefining China’s Database Landscape

The article examines how China’s domestic database market is shifting from legacy commercial systems to cloud‑native solutions like Alibaba Cloud’s PolarDB, highlighting Gartner’s recognition, architectural innovations, open‑source initiatives, and the broader impact on the nation’s digital economy.

Alibaba CloudDigital EconomyGartner
0 likes · 14 min read
How Cloud‑Native Databases Are Redefining China’s Database Landscape
Architects Research Society
Architects Research Society
Jan 17, 2022 · Databases

Understanding Open Source Databases: Licensing, Business Models, and Vendor Strategies

Open source databases are freely available software whose source code can be read, modified, and redistributed, and the article explores their licensing models, commercial versus community editions, major vendors' adoption strategies, emerging database types, and the governance and licensing challenges faced by the ecosystem.

Licensingclouddatabases
0 likes · 11 min read
Understanding Open Source Databases: Licensing, Business Models, and Vendor Strategies
ITPUB
ITPUB
Jan 14, 2022 · Databases

From Paper Tape to Cloud‑Native Distributed Databases: Evolution Overview

This article traces the history of data management from early manual and file‑system storage through relational models to modern distributed databases, covering key concepts like CAP theorem, distributed transactions, HTAP, and cloud‑native deployment trends.

CAP theoremDistributed SystemsHTAP
0 likes · 13 min read
From Paper Tape to Cloud‑Native Distributed Databases: Evolution Overview
Su San Talks Tech
Su San Talks Tech
Jan 1, 2022 · Fundamentals

Top 15 Must‑Know System Design & Coding Interview Questions Explained

This article compiles 15 common interview topics—from sorting linked lists and encryption differences to TCP reliability, I/O models, Hystrix, delayed tasks, HTTPS flow, transaction isolation, index pitfalls, virtual memory, ranking with Redis, distributed locks, zero‑copy techniques, synchronized internals, and Snowflake ID generation—providing concise explanations, code examples, and diagrams for each.

AlgorithmsNetworkingSystem Design
0 likes · 41 min read
Top 15 Must‑Know System Design & Coding Interview Questions Explained
Java Architecture Diary
Java Architecture Diary
Dec 13, 2021 · Backend Development

Essential Java & Cloud Native Resources: From JDK 17 to GraalVM, Spring & More

This curated collection gathers essential articles and tutorials covering Java 8‑17 updates, GraalVM performance tricks, Spring Native adoption, Spring Cloud and RSocket alternatives, GraphQL frameworks, observability stacks like Grafana, Prometheus and Loki, IDE enhancements, database fundamentals, and low‑code platform building, providing a comprehensive knowledge base for modern backend developers.

databasesgraalvmjava
0 likes · 4 min read
Essential Java & Cloud Native Resources: From JDK 17 to GraalVM, Spring & More
Architects Research Society
Architects Research Society
Dec 5, 2021 · Databases

Understanding Sequential, Causal, and Eventual Consistency Models

This article explains the concepts of sequential, causal, and eventual consistency models, illustrating their definitions, guarantees, and practical examples—including process interactions and real‑world scenarios—while comparing their strengths, trade‑offs, and related consistency guarantees such as monotonic reads, writes, and read‑your‑writes.

ConsistencyDistributed Systemscausal consistency
0 likes · 10 min read
Understanding Sequential, Causal, and Eventual Consistency Models
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 4, 2021 · Databases

Weekly Community Newsletter: MySQL Index Cases, Password Policy, Backup Issues, and Open‑Source Middleware Updates

This weekly community newsletter curates technical articles and updates, covering MySQL index length limitations, new password policies, backup‑induced replication issues, open‑source middleware progress, bug fixes, and upcoming development plans, while inviting reader feedback for further improvements.

BugFixesOpenSourceWeeklyUpdate
0 likes · 4 min read
Weekly Community Newsletter: MySQL Index Cases, Password Policy, Backup Issues, and Open‑Source Middleware Updates
21CTO
21CTO
Nov 29, 2021 · Databases

Why Moving Business Logic to the Application Boosts Scalability

The article explains how shifting complex filtering, validation, and join operations from the database to the application layer reduces scarce database resource usage, improves scalability, and enables more flexible resource allocation for modern web applications.

Data RetrievalScalabilityapplication architecture
0 likes · 7 min read
Why Moving Business Logic to the Application Boosts Scalability
Java Architect Essentials
Java Architect Essentials
Nov 22, 2021 · Databases

10 Best Practices for Using Redis Effectively

This article outlines ten essential Redis best‑practice tips, covering why to avoid the KEYS * command, using SCAN, interpreting INFO stats, leveraging hashes, setting key expirations, choosing eviction policies, handling errors, scaling with clusters, CPU considerations, and ensuring high availability with Sentinel.

best practicesdatabaseshigh availability
0 likes · 8 min read
10 Best Practices for Using Redis Effectively
Top Architect
Top Architect
Nov 18, 2021 · Backend Development

Comprehensive Guide to Building a Startup Backend Technology Stack

This article provides a detailed, step‑by‑step guide for startups to design and select a complete backend technology stack, covering language choices, components, processes, systemization, and the practical evaluation of tools such as project management, DNS, load balancing, databases, messaging, CI/CD, monitoring, and deployment.

BackendDevOpsarchitecture
0 likes · 30 min read
Comprehensive Guide to Building a Startup Backend Technology Stack
Architects Research Society
Architects Research Society
Nov 13, 2021 · Databases

Choosing the Right Databases for IoT Applications

The article explains why the Internet of Things generates massive, diverse data streams that require specialized databases, outlines key selection criteria, describes common IoT data types, and reviews several open‑source databases—InfluxDB, CrateDB, MongoDB, RethinkDB, SQLite, and Cassandra—highlighting their strengths for IoT workloads.

Data ManagementIoTNoSQL
0 likes · 10 min read
Choosing the Right Databases for IoT Applications
21CTO
21CTO
Nov 6, 2021 · Cloud Computing

Why Cloud Computing Changes Database Design: Benefits, Drawbacks, and Core Principles

This article examines cloud computing’s core principle of using interchangeable machines, compares parallel‑first and single‑storage‑first database architectures, outlines the advantages such as scalability, cost efficiency, and integration, and discusses the weaknesses including maturity gaps, latency, and vendor lock‑in.

Cost ManagementScalabilitycloud architecture
0 likes · 8 min read
Why Cloud Computing Changes Database Design: Benefits, Drawbacks, and Core Principles
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 5, 2021 · Databases

SQLE 1.2111.0-pre1 Release Notes

The SQLE 1.2111.0-pre1 preview release introduces plugin-based support for arbitrary databases, provides a PostgreSQL plugin example, includes API adjustments, fixes a rule‑passing bug, and offers links to the source repository, documentation, and release information for users and administrators.

auditdatabasesplugin
0 likes · 3 min read
SQLE 1.2111.0-pre1 Release Notes
Xiao Lou's Tech Notes
Xiao Lou's Tech Notes
Oct 12, 2021 · Databases

Optimizing ORDER BY/LIMIT in Sharded Databases with Cobar’s Algorithm

This article explains Cobar’s sharding middleware and presents an optimization technique for handling ORDER BY and LIMIT queries across multiple databases, detailing the original approach, its inefficiencies with deep pagination, the step‑by‑step improved algorithm, performance analysis, limitations, and practical applicability.

CobarLIMITOrder By
0 likes · 8 min read
Optimizing ORDER BY/LIMIT in Sharded Databases with Cobar’s Algorithm
21CTO
21CTO
Oct 4, 2021 · Databases

October 2023 DB‑Engines Ranking: Top 10 Databases & Emerging Trends

The October DB‑Engines popularity ranking shows the same top‑10 databases as September, highlights score gains for MySQL and PostgreSQL, notes a year‑over‑year decline for the three leading systems, and reveals Snowflake’s rise into the top‑20, all based on five key popularity indicators.

DB-EnginesNoSQLdatabases
0 likes · 4 min read
October 2023 DB‑Engines Ranking: Top 10 Databases & Emerging Trends
DataFunTalk
DataFunTalk
Oct 1, 2021 · Databases

The Development and Landscape of China's Graph Database Market (2021‑2025)

This article provides a comprehensive overview of the Chinese graph database market, covering its origins, government policies, market size estimates, vendor rankings, funding activities, product features, challenges, and future prospects, while referencing numerous industry reports and case studies.

ChinaGraph Databasedatabases
0 likes · 21 min read
The Development and Landscape of China's Graph Database Market (2021‑2025)
Qingyun Technology Community
Qingyun Technology Community
Sep 16, 2021 · Databases

Why Cloud‑Native Databases Are Redefining Elasticity and Resilience

Cloud‑native databases address the elasticity, resilience, and high‑availability demands of modern cloud computing by separating compute and storage, leveraging log‑based persistence, multi‑replica consensus, and distributed architectures such as Spanner, Aurora, and TiDB, offering higher performance, lower cost, and better resource utilization.

cloud-nativedatabasesdistributed-systems
0 likes · 13 min read
Why Cloud‑Native Databases Are Redefining Elasticity and Resilience
IT Xianyu
IT Xianyu
Sep 15, 2021 · Databases

Database Types, Bottlenecks, Optimization Strategies and Scaling Techniques

This article explains the classification of relational and NoSQL databases, analyzes common performance bottlenecks such as query latency, large fields, and write overhead, and presents practical optimization methods including caching, proper indexing, transaction handling, read‑write separation, and sharding for large‑scale systems.

cachingdatabasesindexing
0 likes · 17 min read
Database Types, Bottlenecks, Optimization Strategies and Scaling Techniques
Alibaba Cloud Developer
Alibaba Cloud Developer
Sep 2, 2021 · Databases

From LAMP to Cloud‑Native: Evolving Application Data Architecture and Best Practices

This article traces two decades of application data architecture evolution, comparing traditional single‑system LAMP designs with modern multi‑component cloud‑native stacks, and offers practical guidance on scaling, component selection, CDC‑based data derivation, and cloud‑native implementations such as Tablestore.

CDCData Architecturedatabases
0 likes · 22 min read
From LAMP to Cloud‑Native: Evolving Application Data Architecture and Best Practices
Wukong Talks Architecture
Wukong Talks Architecture
Aug 27, 2021 · Databases

Understanding Redis Master‑Slave Architecture: Principles, Topologies, and Replication Mechanisms

This article explains the fundamentals of Redis master‑slave architecture, covering why high‑availability replication is needed, the three topology patterns, the three replication modes (continuous, full, partial), the replication backlog buffer, PSYNC command handling, heartbeat mechanisms, and the practical considerations for operators and architects.

cachingdatabasesmaster-slave replication
0 likes · 16 min read
Understanding Redis Master‑Slave Architecture: Principles, Topologies, and Replication Mechanisms
Architects' Tech Alliance
Architects' Tech Alliance
Aug 21, 2021 · Databases

In-Memory Databases: Concepts, Evolution, Applications, and Selection Guide

This whitepaper explains the concept of in‑memory databases, traces their historical development, outlines core attributes and typical use cases in e‑commerce, live streaming and telecom, compares leading products, and provides technical and management recommendations for hardware and product selection as well as future trends.

In-Memory DatabaseKey-Valuedatabases
0 likes · 14 min read
In-Memory Databases: Concepts, Evolution, Applications, and Selection Guide
php Courses
php Courses
Aug 9, 2021 · Databases

Interview Transcript: MySQL, Redis, PHP, and Distributed Systems Questions

The article records a video interview where the candidate answers technical questions on MySQL isolation levels, InnoDB indexing, locking, distributed locks, Redis sharding, PHP‑FPM architecture, RabbitMQ, AOP, Hyperf, and other backend topics, reflecting on the challenges faced during the session.

BackendDistributed SystemsPHP
0 likes · 7 min read
Interview Transcript: MySQL, Redis, PHP, and Distributed Systems Questions
Wukong Talks Architecture
Wukong Talks Architecture
Aug 3, 2021 · Databases

Redis Eviction Policies Explained

This article introduces the various Redis eviction strategies—including volatile-ttl, volatile-random, volatile-lru, volatile-lfu, allkeys-random, allkeys-lru, and allkeys-lfu—explains their behavior, shows where they are configured in redis.conf and the initServer source code, and notes the default noeviction policy when memory exceeds maxmemory.

CacheMemory Managementdatabases
0 likes · 3 min read
Redis Eviction Policies Explained
IT Architects Alliance
IT Architects Alliance
Jul 25, 2021 · Backend Development

Comprehensive Guide to Building a Backend Technology Stack for Startups

This article outlines a complete backend technology stack for startups, covering language choices, core components, processes, systemization, and detailed selections for project management, DNS, load balancing, CDN, RPC frameworks, service discovery, databases, messaging, logging, monitoring, configuration, deployment, and operational best practices.

BackendCICDDevOps
0 likes · 28 min read
Comprehensive Guide to Building a Backend Technology Stack for Startups
Top Architect
Top Architect
Jul 14, 2021 · Databases

Redis Read‑Write Separation Architecture: Star vs. Chain Replication

This article explains Alibaba Cloud's Redis read‑write separation architecture, comparing star and chain replication models, their performance and scalability trade‑offs, and how transparent compatibility, high availability, and high performance are achieved through redis‑proxy, HA monitoring, and optimized binlog replication.

Read-Write Separationdatabaseshigh availability
0 likes · 8 min read
Redis Read‑Write Separation Architecture: Star vs. Chain Replication
Laravel Tech Community
Laravel Tech Community
Jun 28, 2021 · Databases

Understanding and Optimizing MySQL ORDER BY Execution

This article explains how MySQL processes ORDER BY clauses, illustrates the execution steps with a full‑field index, discusses the impact of sort_buffer and max_length_for_sort_data, and shows how adding composite and covering indexes can eliminate filesort and improve query performance.

Index OptimizationOrder BySQL Performance
0 likes · 6 min read
Understanding and Optimizing MySQL ORDER BY Execution
Tencent Tech
Tencent Tech
Jun 25, 2021 · Databases

How Tencent Cloud’s Spitfire and Distributed DB Innovations Won SIGMOD 2021

Two Tencent Cloud database papers—Spitfire’s three‑tier buffer manager and a high‑performance strong‑consistency engine for distributed systems—were accepted at ACM SIGMOD 2021, showcasing innovative use of NVM, AI‑driven tuning, and cloud‑native architecture to boost performance and cost efficiency.

NVMbuffer managementcloud-native
0 likes · 5 min read
How Tencent Cloud’s Spitfire and Distributed DB Innovations Won SIGMOD 2021
Dada Group Technology
Dada Group Technology
Jun 18, 2021 · Cloud Computing

Evolution of Feed System Architecture for To Home Discovery Channel

This document outlines the architectural evolution of the Feed system for To Home Discovery Channel, addressing scalability challenges through database optimization, Elasticsearch integration, and caching strategies to manage billion-scale user data and dynamic content updates.

cloud computingdatabasesfeed system
0 likes · 13 min read
Evolution of Feed System Architecture for To Home Discovery Channel
Java Backend Technology
Java Backend Technology
Jun 3, 2021 · Databases

Why MySQL TIMESTAMP Is a Hidden Pitfall and How to Avoid It

This article explains MySQL's three time types, highlights the quirks and automatic defaults of TIMESTAMP—including the 2038 problem, high‑concurrency issues, and unexpected behavior in non‑strict mode—provides practical examples, and offers guidance on configuring server variables or switching to DATETIME for safer handling.

2038 problemTimezonedatabases
0 likes · 11 min read
Why MySQL TIMESTAMP Is a Hidden Pitfall and How to Avoid It
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 27, 2021 · Databases

Understanding Redis Memory Eviction and Expiration Strategies

This article explains Redis's memory eviction policies and expiration strategies, detailing how different eviction modes (such as noeviction, allkeys‑lru, volatile‑ttl, allkeys‑lfu) and lazy versus periodic deletion work together to manage limited memory and ensure efficient cache performance.

Expirationdatabasesmemory eviction
0 likes · 6 min read
Understanding Redis Memory Eviction and Expiration Strategies
Tencent Tech
Tencent Tech
May 12, 2021 · Big Data

How Tencent Powered China’s 7th Census with Big Data and Cloud Tech

The article explains how China’s seventh national census, covering 1.41 billion people, was conducted using fully electronic data collection, self‑service mini‑programs, massive cloud‑native infrastructure, and high‑performance databases to achieve real‑time processing and unprecedented scale.

Big Datacensusdatabases
0 likes · 8 min read
How Tencent Powered China’s 7th Census with Big Data and Cloud Tech
JD Tech
JD Tech
Apr 20, 2021 · Databases

Space-Filling Curves for Efficient Multidimensional Data Storage and Querying

This article introduces space-filling curves such as Z‑ordering, Hilbert, and XZ‑Ordering, explaining their mapping algorithms and how they transform multidimensional spatial data into one‑dimensional indices for efficient storage and querying in key‑value databases, while discussing challenges and practical examples.

Big DataSpace-filling CurvesSpatial Indexing
0 likes · 12 min read
Space-Filling Curves for Efficient Multidimensional Data Storage and Querying
Selected Java Interview Questions
Selected Java Interview Questions
Apr 18, 2021 · Databases

Understanding Master‑Slave Replication in Databases: Principles, Benefits, and Interview Questions

This article explains the concept, advantages, and inner workings of master‑slave database replication, outlines the key threads and step‑by‑step process, and provides common interview questions with concise answers for candidates preparing for database engineering roles.

Interview Preparationdatabasesmaster-slave replication
0 likes · 6 min read
Understanding Master‑Slave Replication in Databases: Principles, Benefits, and Interview Questions
ITPUB
ITPUB
Apr 15, 2021 · Databases

Master Redis Memory Limits and Eviction: Configuring Maxmemory, LRU & LFU Explained

This article explains how to set Redis's maximum memory usage via configuration files or runtime commands, details all built‑in eviction policies, demonstrates retrieving and changing these policies, and dives into the LRU and LFU algorithms—including Java sample code and Redis's approximate LRU implementation.

LFULRUdatabases
0 likes · 11 min read
Master Redis Memory Limits and Eviction: Configuring Maxmemory, LRU & LFU Explained
ITPUB
ITPUB
Apr 9, 2021 · Databases

Tencent TDSQL Reveals Infinite Database Anomalies and a Hands‑On Learning Tool

Tencent’s TDSQL team introduces a groundbreaking theory that precisely classifies an infinite set of database transaction anomalies, defines their categories via conflict‑graph analysis, and provides an open‑source Linux tool with step‑by‑step compilation instructions for interactive anomaly exploration.

Concurrency ControlLinux toolTDSQL
0 likes · 11 min read
Tencent TDSQL Reveals Infinite Database Anomalies and a Hands‑On Learning Tool
dbaplus Community
dbaplus Community
Mar 2, 2021 · Databases

How ByteDance Scaled Real‑Time Analytics with ClickHouse and Kafka Engine

This article details ByteDance's evolution from offline ClickHouse ingestion to a robust real‑time analytics pipeline, covering external transaction handling, risks of direct INSERTs, recommendation and ad‑delivery use cases, Kafka Engine design, multi‑threaded consumption, fault‑tolerance improvements, platform tooling, and future roadmap.

KafkaReal-time analyticsbackend-development
0 likes · 22 min read
How ByteDance Scaled Real‑Time Analytics with ClickHouse and Kafka Engine
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 1, 2021 · Databases

How We Scaled a High‑Volume Order System: Sharding, Migration, and Zero‑Downtime Strategies

This article details the end‑to‑end process of expanding a high‑traffic ride‑hailing order system on Alibaba Cloud, covering capacity planning, database sharding from 256 to 4096 tables, custom data‑sync middleware, validation, repair, and a gray‑release migration that achieved zero incidents.

Data MigrationZero Downtimecapacity-planning
0 likes · 17 min read
How We Scaled a High‑Volume Order System: Sharding, Migration, and Zero‑Downtime Strategies
JavaScript
JavaScript
Feb 24, 2021 · Backend Development

Essential Node.js Skills Every Backend Developer Should Master

This guide outlines the core JavaScript concepts, asynchronous programming fundamentals, package management, HTTP protocols, web frameworks, databases, caching strategies, template engines, real‑time communication, API clients, and testing tools that form a comprehensive learning roadmap for aspiring Node.js backend developers.

JavaScriptNode.jsdatabases
0 likes · 6 min read
Essential Node.js Skills Every Backend Developer Should Master
ITPUB
ITPUB
Feb 23, 2021 · Backend Development

Building a Complete Backend Stack for Startups: Languages, Services, and Tools

This guide walks through the essential layers of a backend technology stack for startups, covering language choices, core components like DNS, load balancing, CDN, RPC frameworks, databases, messaging, logging, monitoring, configuration, deployment, and operational best‑practice processes.

DevOpsMessagingarchitecture
0 likes · 31 min read
Building a Complete Backend Stack for Startups: Languages, Services, and Tools
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Feb 9, 2021 · Databases

How to Design Scalable Databases and Application Layers for Business Systems

This article explains how to achieve extensibility in business systems by addressing database scalability through horizontal and vertical sharding, middleware layers, flexible schema designs, and by applying SOA principles to application, interface, and rule‑engine layers for adaptable, high‑performance architectures.

SOAScalabilityapplication design
0 likes · 14 min read
How to Design Scalable Databases and Application Layers for Business Systems
Efficient Ops
Efficient Ops
Feb 3, 2021 · Databases

Master Redis: Core Data Types, Commands, and Advanced Features Explained

This article introduces Redis as an open‑source, in‑memory data‑structure store, explains its role as a NoSQL database, details its five fundamental data types, common commands, expiration handling, pipelines, and transactions, and shows how it fits into modern scaling architectures.

Data StructuresNoSQLTransactions
0 likes · 14 min read
Master Redis: Core Data Types, Commands, and Advanced Features Explained
Liangxu Linux
Liangxu Linux
Jan 31, 2021 · Databases

Why MySQL Replication Lags and How to Eliminate It

This article explains the root causes of MySQL master‑slave replication lag—including random replay, high master concurrency, and lock waits—and presents practical solutions such as parallel replication, reducing master load, and reading from the master to ensure data consistency.

LagMaster‑SlaveReplication
0 likes · 8 min read
Why MySQL Replication Lags and How to Eliminate It
Tencent Database Technology
Tencent Database Technology
Jan 28, 2021 · Databases

Tencent Cloud Database Kernel Research Accepted at SIGMOD and ICDE: Spitfire Buffer Manager and TLBtree Index

Tencent Cloud's native database team announced two breakthrough research papers—Spitfire, a three‑tier buffer manager for DRAM and NVM, and TLBtree, a read/write‑optimized tree index for non‑volatile memory—both accepted at top‑tier conferences SIGMOD and ICDE, highlighting novel memory‑aware storage techniques and collaborative achievements with leading universities.

ICDENon-volatile MemorySIGMOD
0 likes · 8 min read
Tencent Cloud Database Kernel Research Accepted at SIGMOD and ICDE: Spitfire Buffer Manager and TLBtree Index
21CTO
21CTO
Jan 20, 2021 · Databases

Why Time Series Databases Are the Future of Your Data

Time series databases let you retain full historical records, enabling analysis, visualization, machine learning and automation across domains like finance, weather and IoT, and the article explains why they’re essential, how they differ from traditional databases, and how to start using them.

Time Seriesdatabasesmachine learning
0 likes · 7 min read
Why Time Series Databases Are the Future of Your Data
21CTO
21CTO
Jan 6, 2021 · Databases

Why PostgreSQL, MariaDB, and Azure SQL Are Redefining the DB‑Engines Rankings

The latest DB‑Engines popularity ranking reveals Oracle, MySQL and SQL Server still dominate the top three, while PostgreSQL, MariaDB, Azure SQL Database and Snowflake surge ahead, highlighting a stable yet evolving landscape where cloud‑native databases are gaining rapid momentum.

Azure SQLDB-EnginesMariaDB
0 likes · 4 min read
Why PostgreSQL, MariaDB, and Azure SQL Are Redefining the DB‑Engines Rankings
Architecture Digest
Architecture Digest
Dec 23, 2020 · Databases

Understanding Redis Object Types and Their Underlying Data Structures

This article explains the five core Redis object types—strings, lists, hashes, sets, and sorted sets—their possible encodings, and the underlying data structures such as SDS, linked lists, hash tables, ziplists, intsets, and skiplists, including details of the redisObject layout and rehash mechanisms.

Data Structuresdatabasesencoding
0 likes · 22 min read
Understanding Redis Object Types and Their Underlying Data Structures
Programmer DD
Programmer DD
Dec 4, 2020 · Databases

What Do the 2020 DB-Engines Rankings Reveal About Today’s Most Popular Databases?

The 2020 DB-Engines ranking, based on search engine visibility, developer discussions, job postings, professional platform usage, and social media mentions, ranks 363 databases, highlighting Oracle, MySQL and SQL Server as the dominant relational leaders while showcasing the rapid rise of various NoSQL categories.

2020DB-Engines rankingNoSQL
0 likes · 6 min read
What Do the 2020 DB-Engines Rankings Reveal About Today’s Most Popular Databases?