BestHub
Sign in
YiSu Grain
Author

YiSu Grain

A fleeting mayfly in the world, a single grain in the boundless sea.

83
Articles
0
Likes
227
Views
0
Comments
Recent Articles

Latest from YiSu Grain

83 recent articles
YiSu Grain
YiSu Grain
Jul 10, 2026 · Fundamentals

Software Development Models: Pick the Right One by Spotting Keywords, Not by Memorizing

The article explains how to quickly identify the appropriate software development model for exam scenarios by matching key project characteristics—such as requirement stability, risk level, and need for incremental delivery—to models like Waterfall, V‑Model, Prototype, Spiral, Incremental, Iterative, and Agile, rather than memorizing definitions.

Agileincrementaliterative
0 likes · 13 min read
Software Development Models: Pick the Right One by Spotting Keywords, Not by Memorizing
YiSu Grain
YiSu Grain
Jul 9, 2026 · Backend Development

Mapping Database & Architecture Patterns onto an E‑Commerce High‑Concurrency Diagram

This article reviews weeks 8‑13 of a system‑architecture course—covering indexes, ACID, MVCC, high availability, performance tuning, and case‑study templates—and shows how to combine those concepts into a complete e‑commerce high‑concurrency solution with caching, load‑balancing, async processing, database optimization, HA clustering, and concurrency control.

Database OptimizationHigh Concurrencycaching
0 likes · 18 min read
Mapping Database & Architecture Patterns onto an E‑Commerce High‑Concurrency Diagram
YiSu Grain
YiSu Grain
Jul 9, 2026 · Fundamentals

How to Write Score‑Winning Answers for Architecture Case Questions

The article explains why simply listing technical terms in a software‑exam case study earns no points and provides a step‑by‑step method—identifying problems, mapping them to architectural patterns, and phrasing solutions as concrete, business‑focused sentences that score well.

Case StudyPerformance Optimizationarchitecture-design
0 likes · 14 min read
How to Write Score‑Winning Answers for Architecture Case Questions
YiSu Grain
YiSu Grain
Jul 9, 2026 · Backend Development

Why Adding Cache First Is the Wrong Move for Slow Systems

The article explains that performance tuning should start with pinpointing bottlenecks using response time, throughput, concurrency and resource utilization metrics, then choose appropriate measures—caching, async processing, database tuning, horizontal scaling, and rate‑limiting—rather than blindly adding a cache.

Performance OptimizationRate Limitingasynchronous-processing
0 likes · 12 min read
Why Adding Cache First Is the Wrong Move for Slow Systems
YiSu Grain
YiSu Grain
Jul 8, 2026 · Databases

Why a Transfer Can’t Just Deduct Money – A Simple Guide to ACID Transactions

The article uses a simple money‑transfer scenario to introduce database transactions, explains the four ACID properties, illustrates common concurrency anomalies such as dirty reads, non‑repeatable reads and phantom reads, and outlines the four isolation levels with their trade‑offs and default settings in MySQL and Oracle.

ACIDDatabase TransactionsMySQL
0 likes · 8 min read
Why a Transfer Can’t Just Deduct Money – A Simple Guide to ACID Transactions
YiSu Grain
YiSu Grain
Jul 7, 2026 · Databases

Why Databases Skip the First Page: How Indexes Speed Up Queries

The article explains how database indexes act like a book's table of contents, reducing full‑table scans and disk I/O by using B+Tree structures, and compares clustered, non‑clustered, and covering indexes while highlighting their benefits and trade‑offs.

B+ TreeCovering IndexMySQL
0 likes · 11 min read
Why Databases Skip the First Page: How Indexes Speed Up Queries
YiSu Grain
YiSu Grain
Jul 7, 2026 · Fundamentals

Why You Don't Need to Send an SMS Immediately After an Order – Understanding Kafka and Message Queues

The article explains how using a message queue such as Kafka lets an order service return quickly by handling non‑critical tasks like SMS, points, and logging asynchronously, thereby improving latency, decoupling services, and smoothing traffic spikes while also covering Kafka's core concepts and trade‑offs.

KafkaPeak Shavingasynchronous-processing
0 likes · 11 min read
Why You Don't Need to Send an SMS Immediately After an Order – Understanding Kafka and Message Queues