index design | BestHub

DeWu Technology

Apr 9, 2025 · Databases

Understanding Elasticsearch Indexes, Mappings, and Shard Architecture

The article explains Elasticsearch indexes as logical namespaces for JSON documents, details how mappings define immutable field types such as text, keyword, and numeric, describes primary and replica shard roles, and offers practical guidance on alias usage, shard sizing, replica settings, and performance optimizations to ensure cluster stability.

ElasticsearchPerformanceSharding

0 likes · 20 min read

Understanding Elasticsearch Indexes, Mappings, and Shard Architecture

php中文网 Courses

Aug 14, 2023 · Backend Development

PHP Data Caching: Structures, Index Design Principles, and Code Examples

This article explains PHP data caching techniques—including memory, file, and database caches—provides practical code samples, and outlines key index design principles such as uniqueness, expiration, hotspot optimization, efficient updates, and hierarchical caching to improve performance.

Rediscachingdatabase cache

0 likes · 5 min read

PHP Data Caching: Structures, Index Design Principles, and Code Examples

Architect's Guide

Jan 26, 2023 · Databases

Primary Key and Index Design for Distributed Databases

The article explains why auto‑increment primary keys are unsuitable for sharded databases, recommends globally unique ordered identifiers, and details index and global‑table strategies—including redundant tables, index tables, and embedding shard information in keys—to achieve efficient single‑shard queries.

Distributed DatabasesSQLSharding

0 likes · 10 min read

Primary Key and Index Design for Distributed Databases

IT Architects Alliance

Sep 15, 2022 · Databases

Designing Indexes and Primary Keys for Distributed Database Architectures

Effective index and primary key design in distributed database architectures requires using globally unique, ordered identifiers instead of auto‑increment keys, embedding shard information in keys, employing auxiliary index tables, and handling global tables to ensure queries target a single shard, thereby preserving scalability and performance.

Distributed DatabasesShardingUUID

0 likes · 11 min read

Designing Indexes and Primary Keys for Distributed Database Architectures

Top Architect

Aug 11, 2022 · Databases

Primary Key and Index Design for Distributed Databases

The article explains why auto‑increment primary keys are unsuitable for sharded databases, recommends using globally unique ordered identifiers such as UUIDs or Snowflake IDs, and discusses index design strategies—including index tables, embedding shard keys, and handling global tables—to ensure efficient single‑shard queries.

Distributed DatabasesShardingUUID

0 likes · 10 min read

Qunar Tech Salon

Nov 24, 2021 · Databases

Comprehensive Guide to Elasticsearch Index Design, Settings, and Mapping

This article provides a detailed guide on Elasticsearch index design, covering index settings, shard and replica planning, mapping strategies, complex types, lifecycle management, template usage, and practical best‑practice recommendations for large‑scale log data clusters.

Big DataElasticsearchindex design

0 likes · 27 min read

Comprehensive Guide to Elasticsearch Index Design, Settings, and Mapping

Full-Stack Internet Architecture

May 10, 2021 · Databases

MySQL Index Design Principles and Common Index Pitfalls

This article explains MySQL index fundamentals, covering primary and unique indexes, best practices for choosing indexed columns, handling functions and large fields, avoiding excessive or frequently updated indexes, and enumerates typical scenarios where indexes become ineffective.

Database OptimizationMySQLSQL

0 likes · 12 min read

MySQL Index Design Principles and Common Index Pitfalls

Selected Java Interview Questions

Mar 6, 2020 · Databases

Best Practices for Choosing Database Indexes

This article outlines essential principles for selecting and managing database indexes, covering unique indexes, indexing frequently sorted or filtered columns, limiting index count, using short or prefix indexes, removing unused indexes, left‑most prefix matching, column cardinality, avoiding functions on indexed columns, and extending existing indexes.

MySQLQuery Optimizationdatabase indexing

0 likes · 7 min read

Best Practices for Choosing Database Indexes

Big Data Technology Architecture

Feb 5, 2020 · Big Data

Elasticsearch Index Design: Scaling to PB/TP Levels and Best Practices

This article provides a comprehensive guide on designing Elasticsearch indices for massive data volumes, covering shard and replica sizing, mapping strategies, rollover templates, curator cleanup, tokenization choices, query type selection, and multi‑table association techniques to achieve efficient, reliable search at PB‑scale.

CuratorElasticsearchRollover

0 likes · 24 min read

Elasticsearch Index Design: Scaling to PB/TP Levels and Best Practices

Architect's Tech Stack

Jul 25, 2019 · Databases

Database Command and Design Standards

The article outlines comprehensive MySQL database standards covering naming conventions, table and column design, index strategies, SQL development practices, and operational guidelines to improve performance, maintainability, and security, including recommendations on data types, character sets, reserved fields, binary data storage, and safe query patterns.

DatabaseSQL Best Practicesindex design

0 likes · 21 min read

DataFunTalk

Dec 6, 2018 · Databases

HBase RowKey and Index Design: Principles, Practices, and Case Studies

This article introduces HBase fundamentals, explores effective RowKey and secondary index design principles, discusses demand analysis, presents techniques such as reversing, salting, hashing, and reviews real-world case studies for OpenTSDB, JanusGraph, and GeoMesa, offering practical guidance for scalable NoSQL data modeling.

Big DataDatabase ArchitectureHBase

0 likes · 19 min read

HBase RowKey and Index Design: Principles, Practices, and Case Studies

Youzan Coder

Nov 24, 2018 · Databases

Youzan Database Technology Open Day 2018 – Sessions on RDS System, MySQL Index Design, and Operations

At Youzan’s 2018 Database Technology Open Day in Hangzhou, 53 companies and 64 participants heard sessions on the evolving RDS architecture, MySQL index design best practices, the ZanDB operations platform, and classic MySQL performance case studies, while showcasing micro‑mall integration and outlining upcoming data‑archiving and multi‑data‑center initiatives.

DatabaseMySQLPerformance Tuning

0 likes · 5 min read

Youzan Database Technology Open Day 2018 – Sessions on RDS System, MySQL Index Design, and Operations

Architecture Digest

Jul 9, 2018 · Databases

Elasticsearch Index Design and Sharding Principles

This article outlines practical guidelines for designing Elasticsearch indices, comparing single versus time‑based indexes, detailing mapping settings, shard allocation strategies, and deduplication methods, while providing concrete examples and code snippets for effective search infrastructure management.

Data ModelingElasticsearchSharding

0 likes · 5 min read

Elasticsearch Index Design and Sharding Principles