Tagged articles
Query Processing
17 articles · Page 1 of 1
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

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.
Query ProcessingQuery Rewritingnatural language processing
0 likes · 13 min read

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.
Data IngestionDruidQuery Processing
0 likes · 19 min read

This reference outlines Citus 11.x distributed PostgreSQL SQL features, covering DDL operations, DML commands, rollup cache aggregation, distributed table queries, query processing, manual query propagation, and supported SQL workarounds, with links to detailed documentation.
CitusDDLDML
0 likes · 4 min read

This article explains MySQL's client‑server architecture, detailing how the server processes connections, parses and optimizes queries, generates execution plans, and interacts with various storage engines, while also covering configuration variables, connection monitoring, and practical command examples.
MySQLOptimizerQuery Processing
0 likes · 21 min read

The article explains Snuba’s multi‑stage query processing pipeline—from parsing legacy and SnQL languages into an AST, through logical validation and transformation, storage selection, translation, physical optimization, and final ClickHouse execution—highlighting how each step optimizes queries and safeguards the infrastructure.
ASTClickHouseQuery Processing
0 likes · 11 min read

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.
IndexingQuery ProcessingTask Scheduling
0 likes · 48 min read

This article breaks down MySQL’s architecture into its five key parts—connector, parser, optimizer, executor, and storage engine—explaining each component’s role from establishing connections and handling permissions to query parsing, execution planning, and data storage, with example commands and code snippets.
Database ArchitectureMySQLQuery Processing
0 likes · 3 min read

This article explains the core components of a search engine—document processing, query processing, and matching—detailing each step from indexing to ranking, and discusses the document features that influence relevance, providing a comprehensive overview of information retrieval fundamentals.
Document ProcessingQuery Processinginformation retrieval
0 likes · 20 min read

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.
Document ProcessingQuery Processinginformation retrieval
0 likes · 20 min read

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.
Complex QueryDBLEQuery Processing
0 likes · 6 min read

This article walks through PostgreSQL’s query processing pipeline—from parsing SQL into relational algebra, through semantic analysis, query rewriting, optimization techniques like sub‑query elimination and join ordering, to the executor’s sequential scan algorithm—illustrating each step with code snippets and diagrams.
Database OptimizerPostgreSQLQuery Processing
0 likes · 14 min read


58 TechJun 27, 2019 · Artificial Intelligence
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.
Language ModelQuery ProcessingViterbi algorithm
0 likes · 15 min read

This article walks through MySQL's overall architecture, the complete query execution flow, and the exact order in which SQL clauses are parsed and processed, using diagrams and detailed explanations to reveal how a statement travels from client request to final result.
Database ArchitectureMySQLQuery Processing
0 likes · 10 min read

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 ArchitectureFailoverQuery Processing
0 likes · 11 min read


ITPUBMay 31, 2016 · Databases
This article walks through PostgreSQL's complete SQL execution pipeline, detailing each component—from the Main entry point and Postmaster process to parsing, traffic coordination, query rewriting, plan generation, and execution—while comparing its process architecture to other database systems.
Database InternalsPostgreSQLPostmaster
0 likes · 6 min read

The article outlines the step‑by‑step lifecycle of a database server—from system initialization and buffer allocation, through connection and thread management, request parsing, optimization, storage‑engine interaction, to final response delivery and cleanup—illustrated with diagrams of each stage.
Database ArchitectureQuery ProcessingRequest Handling
0 likes · 4 min read
