Applying the Open‑Closed Principle and Bitmask Design for Extensible System Architecture

The article explains the six SOLID design principles, emphasizes the importance of the Open‑Closed principle, and demonstrates how to achieve extensible database schemas and APIs using type fields, extendable JSON columns, bitmap role encoding, and strategy/template patterns with concrete Java code examples.

Database designDesign PatternsOpen/Closed Principle

0 likes · 15 min read

Applying the Open‑Closed Principle and Bitmask Design for Extensible System Architecture

dbaplus Community

Oct 2, 2022 · Backend Development

Cutting Invalid Data: How Zhaunzhuan Optimized Its Product Service for 3× Faster Performance

This article examines how Zhaunzhuan's product service, a core component of its e‑commerce platform, was optimized by reducing unnecessary data transmission, applying cache‑aside patterns, redesigning Redis storage, and introducing a field‑marking approach, resulting in dramatically lower GC overhead, network traffic, and response times.

GraphQLbitmaskdata optimization

0 likes · 14 min read

Cutting Invalid Data: How Zhaunzhuan Optimized Its Product Service for 3× Faster Performance

ITFLY8 Architecture Home

Nov 30, 2016 · Databases

How to Store Multiple Item States Efficiently Using Bitmasking in Databases

This article explains how to represent several status flags for a single record—such as hot, new, and sale—by using binary bitmask fields, compares traditional association‑table and delimited‑string approaches, and shows Oracle SQL and Java techniques for querying and manipulating these bit‑encoded values.

Backendbitmasksql

0 likes · 4 min read

How to Store Multiple Item States Efficiently Using Bitmasking in Databases