Tagged articles
3 articles
Page 1 of 1
Java Baker
Java Baker
Jul 7, 2025 · Databases

Choosing the Right Database Schema for Dynamic Business Field Expansion

This article compares five common database extension strategies—from simple MySQL column additions to a hybrid MySQL‑HBase solution—detailing their implementation, advantages, drawbacks, and ideal scenarios, helping architects select the most scalable and maintainable design for evolving business data requirements.

Database designDynamic FieldsHBase
0 likes · 8 min read
Choosing the Right Database Schema for Dynamic Business Field Expansion
Architect
Architect
Jun 1, 2025 · Databases

Dynamic Extension of Fields in Billion‑Row Core Tables: Architecture and Implementation

To avoid lock, page split, and index degradation when adding fields to billion‑row core tables, this article presents a practical solution that uses dynamic field extension via configurable management, JSON‑based extension fields, and an extension‑table architecture integrated with Elasticsearch for storage and retrieval.

Dynamic FieldsElasticsearchdatabases
0 likes · 10 min read
Dynamic Extension of Fields in Billion‑Row Core Tables: Architecture and Implementation