BestHub
Sign in
Tagged articles
24 articles
Page 1 of 1
Top Architect
Top Architect
Nov 17, 2025 · Information Security

Mastering Permission Management: From Basic RBAC to Advanced Role‑Inheritance Models

This article explains why strict permission management is essential for data security, walks through the evolution of access‑control models—from simple user‑permission tables to classic RBAC, RBAC1, RBAC2, role inheritance, constraints, user groups, organizational mapping, and finally presents ideal database schemas for scalable, maintainable permission systems.

Backend SecurityRBACRole Inheritance
0 likes · 18 min read
Mastering Permission Management: From Basic RBAC to Advanced Role‑Inheritance Models
Su San Talks Tech
Su San Talks Tech
Aug 23, 2025 · Backend Development

How to Build a Robust Asynchronous Processing SDK with Spring and Kafka

This article explains how to design and implement a generic asynchronous processing SDK for Java backend services, covering its purpose, advantages, underlying principles, component choices, database schema, configuration, usage patterns, and best‑practice notes, with code examples and diagrams.

ConfigurationJava backendKafka
0 likes · 9 min read
How to Build a Robust Asynchronous Processing SDK with Spring and Kafka
Lobster Programming
Lobster Programming
Jun 9, 2025 · Databases

How to Add a Column to Billion‑Row Tables Without Downtime

This article explains a metadata‑driven approach for extending massive tables—using a separate extension table, sharding, and Elasticsearch sync—to add new fields to billion‑row databases without locking the primary table or disrupting online services.

Big DataElasticsearchdatabase schema
0 likes · 6 min read
How to Add a Column to Billion‑Row Tables Without Downtime
Java Interview Crash Guide
Java Interview Crash Guide
Aug 13, 2024 · Backend Development

How to Build a Robust Asynchronous Processing SDK with Spring and Kafka

This article explains the design, advantages, and implementation details of a generic asynchronous processing SDK that leverages Spring transactional events, Kafka messaging, XXL‑Job scheduling, and a non‑intrusive architecture to ensure data consistency, fault tolerance, and easy integration across services.

Design PatternsKafkaasynchronous processing
0 likes · 11 min read
How to Build a Robust Asynchronous Processing SDK with Spring and Kafka
vivo Internet Technology
vivo Internet Technology
Aug 7, 2024 · Databases

MySQL 5.7 DDL vs GH-OST: A Comprehensive Comparison of Online Schema Change Tools

While MySQL 5.7 native DDL methods (copy, inplace rebuild, index build, metadata‑only) vary in speed, space use, lock impact, and binlog output, GH‑OST consistently offers the fastest execution, lowest lock blocking, real‑time replication, albeit at roughly double storage cost, making it ideal for risk‑averse online schema changes.

DDLInnoDBOnline DDL
0 likes · 11 min read
MySQL 5.7 DDL vs GH-OST: A Comprehensive Comparison of Online Schema Change Tools
Ops Development & AI Practice
Ops Development & AI Practice
Apr 14, 2024 · Backend Development

Designing a Scalable Booking System: Architecture, APIs, and Go Implementation

This article outlines the functional and non‑functional requirements of a booking platform, proposes a micro‑service‑based backend architecture, presents UML component and sequence diagrams, details database schemas, defines RESTful APIs, and provides Go code examples for user registration and booking creation, offering a comprehensive design blueprint.

BackendMicroservicesSystem Architecture
0 likes · 10 min read
Designing a Scalable Booking System: Architecture, APIs, and Go Implementation
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 7, 2023 · Databases

Understanding Invisible Columns, Generated Invisible Primary Keys, and Invisible Indexes in MySQL 8.0

This article explains three relatively new MySQL 8.0 features—hidden (invisible) columns, generated invisible primary keys, and invisible indexes—detailing their purpose, how to create and use them, and practical scenarios where they can help avoid schema‑change issues or test query performance.

Generated Primary KeyInvisible ColumnsInvisible Indexes
0 likes · 11 min read
Understanding Invisible Columns, Generated Invisible Primary Keys, and Invisible Indexes in MySQL 8.0
Selected Java Interview Questions
Selected Java Interview Questions
Jul 10, 2023 · Backend Development

Designing a Unified Multi‑Account Login System with Phone, Password, and Third‑Party Authentication

This article outlines a comprehensive approach to building a scalable multi‑account login system that supports phone‑number/password, phone‑number/verification‑code, and various third‑party OAuth providers, detailing workflow steps, database schema, advantages, drawbacks, and a one‑click login integration.

AuthenticationBackendaccount‑design
0 likes · 15 min read
Designing a Unified Multi‑Account Login System with Phone, Password, and Third‑Party Authentication
macrozheng
macrozheng
Jun 20, 2023 · Backend Development

Mastering E‑Commerce Product Module Design with the Mall Project

This article walks through the Mall project's product module—covering its architecture, feature design, database schema, and API implementation—while providing links to source code, video tutorials, and a mind‑map that together serve as a comprehensive guide for building robust e‑commerce systems.

Backend DevelopmentSpringBootapi-design
0 likes · 10 min read
Mastering E‑Commerce Product Module Design with the Mall Project
21CTO
21CTO
Nov 19, 2022 · Backend Development

Building a Scalable Coupon System for Rental Platforms: Architecture, DB Design & Concurrency

This article details the end‑to‑end design of a coupon system for a rental listing platform, covering business flow, MySQL table schemas, activity lifecycle management, state‑machine and observer patterns, high‑concurrency claim handling with Redis and MQ, and future scalability optimizations.

Coupon Systembackend designdatabase schema
0 likes · 20 min read
Building a Scalable Coupon System for Rental Platforms: Architecture, DB Design & Concurrency
Architecture Digest
Architecture Digest
Nov 14, 2022 · Backend Development

Design and Implementation of a Coupon System for a Rental Platform

This article details the design and implementation of a coupon system for a rental platform, covering business flow, database schema, backend services, caching strategies, state management, and future optimization directions to ensure reliable coupon distribution and redemption.

Coupon SystemMicroservicesbackend design
0 likes · 20 min read
Design and Implementation of a Coupon System for a Rental Platform
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Sep 25, 2022 · Backend Development

Master System Design Discussions: From Requirements to Scalable Architecture

This guide walks you through structuring a system‑design discussion—from clarifying functional and non‑functional requirements, mapping user flows and API calls, to outlining high‑level architecture, scaling strategies, and drafting a database schema—using a Twitter‑like example to illustrate each step.

ScalabilitySystem Designapi-design
0 likes · 9 min read
Master System Design Discussions: From Requirements to Scalable Architecture
macrozheng
macrozheng
May 27, 2022 · Backend Development

Designing a Scalable Coupon System: From Distribution to Redemption

This article explains the end‑to‑end design of a coupon system for e‑commerce, covering promotion types, core workflows, service architecture, database schema, distributed transaction handling, scaling strategies, rate limiting, and consistency mechanisms such as TCC.

Coupon SystemScalabilitybackend design
0 likes · 15 min read
Designing a Scalable Coupon System: From Distribution to Redemption
Programmer DD
Programmer DD
May 16, 2021 · Backend Development

Designing Scalable Multi-Account Login: Strategies, Flows, and Database Schemas

This article explains the technical design of multi‑account unified login, covering startup‑phase username/password and phone‑number authentication flows, detailed database table structures, and third‑party OAuth2 integration with practical implementation steps and diagrams.

authentication flowdatabase schemamulti‑account login
0 likes · 9 min read
Designing Scalable Multi-Account Login: Strategies, Flows, and Database Schemas
macrozheng
macrozheng
Aug 9, 2019 · Databases

Mastering Coupon System Design: Database Schemas and UI Integration

This article provides a comprehensive walkthrough of the coupon feature's database tables—including definitions for coupons, coupon history, product relations, and category relations—along with screenshots of both admin and mobile interfaces that illustrate how these tables are used in an e‑commerce system.

CouponSQLdatabase schema
0 likes · 6 min read
Mastering Coupon System Design: Database Schemas and UI Integration
macrozheng
macrozheng
Jul 25, 2019 · Databases

Mastering Order Return Database Design: Schemas, Statuses, and UI Flow

This article provides a comprehensive walkthrough of the order return and return‑reason database tables, detailing each field, status codes, and the corresponding admin and mobile UI screens that illustrate how the return process works in an e‑commerce system.

SQLdatabase schemae‑commerce
0 likes · 7 min read
Mastering Order Return Database Design: Schemas, Statuses, and UI Flow
macrozheng
macrozheng
Jul 23, 2019 · Backend Development

Mastering E‑Commerce Cart & Order Flow: Database Schema and Process Walkthrough

This article dissects the e‑commerce shopping cart database schema, explains the end‑to‑end order lifecycle—from adding items and calculating promotions to generating confirmation orders, creating orders, and handling cancellations—while highlighting key implementation details and code references for backend developers.

Shopping Cartdatabase schemae‑commerce
0 likes · 7 min read
Mastering E‑Commerce Cart & Order Flow: Database Schema and Process Walkthrough