query processing

Java Tech Enthusiast

Oct 3, 2024 · Databases

Understanding MySQL Architecture and SQL Execution Flow

The article outlines MySQL’s layered architecture—connector, parser, optimizer, executor, and binary log in the server layer and pluggable storage engines like InnoDB—then walks through the step‑by‑step processing of SELECT and UPDATE statements, highlighting permission checks, caching, plan selection, redo and binlog handling for crash‑safe durability.

Database ArchitectureInnoDBMySQL

0 likes · 11 min read

Understanding MySQL Architecture and SQL Execution Flow

DataFunTalk

Oct 16, 2022 · Artificial Intelligence

Query Understanding and Processing in E‑commerce Search Systems

This article explains the end‑to‑end pipeline of query understanding for e‑commerce search, covering preprocessing, segmentation, spell correction, normalization, and expansion, and discusses both academic research and industry implementations with examples and references.

Natural Language Processinge-commercequery processing

0 likes · 13 min read

Query Understanding and Processing in E‑commerce Search Systems

vivo Internet Technology

May 25, 2022 · Big Data

Understanding Druid Metadata Management and Architecture

Apache Druid manages metadata through a layered, distributed system where the Overlord coordinates ingestion tasks, MiddleManagers launch Peons to create segments, Coordinators and Historical nodes store and serve segment data, Brokers route queries, while MySQL, Zookeeper, memory, and local files synchronize metadata for fault‑tolerant, high‑performance OLAP analytics.

Big DataData ingestionDruid

0 likes · 19 min read

Understanding Druid Metadata Management and Architecture

DataFunTalk

Nov 8, 2020 · Backend Development

Design and Optimization of an In-Memory Search Engine

This article shares the author's exploration of in‑memory search engine design, covering system understanding, core architecture, thread and task models, intersection algorithms, lookup optimizations, and componentization, aiming to fill the scarce documentation on memory‑based retrieval engines.

IndexingThread modelin-memory search

0 likes · 48 min read

Design and Optimization of an In-Memory Search Engine

Architect

Jun 22, 2020 · Fundamentals

Fundamentals of Search Engine Architecture: Document Processing, Query Processing, Indexing, and Matching

This article explains the core components and processing steps of a search engine—document processor, query processor, indexing, and matching—detailing how documents are normalized, tokenized, filtered, weighted, and stored in an inverted index to support effective information retrieval.

Indexingdocument processinginformation retrieval

0 likes · 20 min read

Fundamentals of Search Engine Architecture: Document Processing, Query Processing, Indexing, and Matching

Aikesheng Open Source Community

Dec 6, 2019 · Databases

DBLE Query Process: Simple and Complex Queries Overview

This article explains DBLE's query workflow, covering basic DML handling, simple query routing and result merging, as well as complex query processing with JOIN, UNION, sub‑queries, and sharding strategies, illustrated with diagrams and code examples.

DBLEDatabase MiddlewareSQL

0 likes · 6 min read

DBLE Query Process: Simple and Complex Queries Overview

58 Tech

Jun 27, 2019 · Artificial Intelligence

Spelling Correction System for 58.com Search Engine: Rule‑Based and Statistical Methods

This article describes the design and implementation of a spelling‑correction module for 58.com’s search engine, covering common query errors, rule‑based and statistical language‑model approaches, offline dictionary generation, n‑gram and Viterbi decoding, online workflow, and practical examples.

Viterbi algorithmlanguage modelpinyin

0 likes · 15 min read

Spelling Correction System for 58.com Search Engine: Rule‑Based and Statistical Methods

JD Retail Technology

Oct 16, 2017 · Databases

Design and Evolution of JD Elastic Database: Architecture, Sharding, and Automatic Failover

This article details the evolution of JD's Elastic Database, describing the challenges of scaling MySQL, the staged solutions including sharding, JProxy, and the final elastic architecture with services like Topology, JED‑Gate, and JED‑Tablet, and explains its query processing, dynamic resharding, and automatic failover mechanisms.

Elastic ArchitectureFailoverSharding

0 likes · 11 min read

Design and Evolution of JD Elastic Database: Architecture, Sharding, and Automatic Failover