Skip to content
Tagged articles

Table Design

18 articles · Page 1 of 1
Xiaolin Talks Programming
Xiaolin Talks Programming
Sep 5, 2026 · Backend Development

Migrating Log Platform from Elasticsearch to ClickHouse: Table Design, Materialized Views & Tuning Lessons

The author details migrating a high-volume logging platform from Elasticsearch to ClickHouse, covering schema design with ReplicatedMergeTree, Spring Boot integration via JDBC and MyBatis, materialized views for pre-aggregation, and optimization techniques like skip indexes, batch inserts, and capacity planning.

ClickHouseElasticsearchKafka
0 likes · 21 min read
Migrating Log Platform from Elasticsearch to ClickHouse: Table Design, Materialized Views & Tuning Lessons
Programmer1970
Programmer1970
Oct 25, 2025 · Backend Development

Flowable Workflow Engine: Core Table Structure Overview (Part 2)

The article details Flowable 6.8's modular, efficient, and extensible table design, explaining the five table categories (RE, RU, HI, ID, GE), naming conventions, key tables for repository, runtime, history, identity, and generic data, their functions, and how they relate to each other in the BPM engine.

BPMFlowableTable Design
0 likes · 8 min read
Flowable Workflow Engine: Core Table Structure Overview (Part 2)
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Mar 27, 2024 · Databases

9 Essential Database Optimization Techniques Every Engineer Should Master

This article presents a comprehensive guide to database performance improvement, covering index tuning, query rewriting, proper table design, caching strategies, hardware choices, server parameter tweaks, monitoring, connection pooling, and data cleanup, all illustrated with practical examples and diagrams.

Query PerformanceTable Designindex tuning
0 likes · 9 min read
9 Essential Database Optimization Techniques Every Engineer Should Master
Weimob Technology Center
Weimob Technology Center
Oct 13, 2023 · Big Data

Optimizing StarRocks Tables: Design Tips, Real‑World Cases and Monitoring Strategies

This article explains how to design efficient StarRocks tables with proper field types, partitioning and bucketing, compares update and primary‑key models, presents real‑world cases of memory and tablet issues, provides a complete table‑creation example, and outlines comprehensive monitoring metrics to keep the analytical data warehouse performant and stable.

AnalyticsPartitioningPrimary Key
0 likes · 25 min read
Optimizing StarRocks Tables: Design Tips, Real‑World Cases and Monitoring Strategies
Senior Brother's Insights
Senior Brother's Insights
Jun 6, 2022 · Databases

Comprehensive Guide to Database Object Naming and Design Standards

This guide outlines detailed naming conventions for databases, tables, columns, indexes, views, stored procedures, functions, triggers, constraints, and users, plus best practices for storage engine, charset, table design, field types, index design, and SQL usage to ensure consistency, performance, and maintainability.

Constraint GuidelinesDatabase NamingMySQL Best Practices
0 likes · 21 min read
Comprehensive Guide to Database Object Naming and Design Standards
Sohu Tech Products
Sohu Tech Products
Oct 17, 2019 · Databases

HBase Table Design Strategies and Best Practices

This article explains HBase's data model and key components, details column descriptor options such as BloomFilter, Compression, Versions, TTL, and MinVersion, and provides practical design guidelines for columns, rowkeys, high vs. wide tables, region pre‑splitting, and hotspot mitigation to achieve optimal performance.

Data ModelingHBaseNoSQL
0 likes · 17 min read
HBase Table Design Strategies and Best Practices
Sohu Tech Products
Sohu Tech Products
Oct 9, 2019 · Databases

HBase Table Design Strategies: Data Model, Column Descriptors, RowKey, Region and Performance Optimization

This article explains HBase’s data model and provides comprehensive table‑design strategies—including column‑descriptor options, row‑key best practices, high‑vs‑wide table trade‑offs, region splitting and pre‑splitting techniques—to help achieve optimal performance and scalability in large‑scale NoSQL workloads.

Column FamilyHBaseNoSQL
0 likes · 16 min read
HBase Table Design Strategies: Data Model, Column Descriptors, RowKey, Region and Performance Optimization
ITPUB
ITPUB
Aug 18, 2019 · Databases

100 Essential MySQL Interview Questions: Indexes, Transactions, and More

This comprehensive guide answers 100 common MySQL interview questions, covering index types and trade‑offs, transaction concepts and isolation levels, table design best practices, storage engine differences, and various performance‑related tips for developers.

Table Designquery optimizationstorage-engine
0 likes · 22 min read
100 Essential MySQL Interview Questions: Indexes, Transactions, and More
Java Architect Essentials
Java Architect Essentials
Jun 4, 2018 · Databases

Fundamental SQL Commands and Database Design Basics

This article provides a concise introduction to essential SQL concepts, covering database creation, manipulation, table design, constraints, indexes, and common DDL statements, making it a useful reference for beginners and experienced developers alike.

DDLSQLTable Design
0 likes · 7 min read
Fundamental SQL Commands and Database Design Basics
Architecture Digest
Architecture Digest
Oct 31, 2017 · Databases

Designing MySQL InnoDB Tables and Indexes for Business Scenarios

This article explains InnoDB storage mechanics, compares auto‑increment and business primary keys, details primary, secondary, and composite index structures, and presents practical table‑design principles and real‑world case studies from ZhaiZhai's services to guide developers in building efficient MySQL schemas.

InnoDBMySQLPrimary Key
0 likes · 12 min read
Designing MySQL InnoDB Tables and Indexes for Business Scenarios