BestHub
Sign in
Tagged articles
15 articles
Page 1 of 1
Java Tech Enthusiast
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 ArchitectureInnoDBQuery Processing
0 likes · 11 min read
Understanding MySQL Architecture and SQL Execution Flow
DataFunTalk
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.

Query ProcessingQuery Rewritingnatural language processing
0 likes · 13 min read
Query Understanding and Processing in E‑commerce Search Systems
vivo Internet Technology
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 DataDruidQuery Processing
0 likes · 19 min read
Understanding Druid Metadata Management and Architecture
JavaEdge
JavaEdge
Jan 26, 2022 · Databases

Inside MySQL: How the Server Handles Queries from Connection to Storage Engine

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.

Query ProcessingStorage Enginemysql
0 likes · 21 min read
Inside MySQL: How the Server Handles Queries from Connection to Storage Engine
DataFunTalk
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.

Query ProcessingThread Modelin-memory search
0 likes · 48 min read
Design and Optimization of an In-Memory Search Engine
MaGe Linux Operations
MaGe Linux Operations
Aug 1, 2020 · Databases

What Are the Core Components of MySQL? A Deep Dive

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 ArchitectureQuery ProcessingSQL
0 likes · 3 min read
What Are the Core Components of MySQL? A Deep Dive
Programmer DD
Programmer DD
Jul 10, 2020 · Fundamentals

How Search Engines Work: Inside Document and Query Processing

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
How Search Engines Work: Inside Document and Query Processing
Architect
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.

Document ProcessingQuery Processinginformation retrieval
0 likes · 20 min read
Fundamentals of Search Engine Architecture: Document Processing, Query Processing, Indexing, and Matching
dbaplus Community
dbaplus Community
Aug 29, 2019 · Databases

Inside PostgreSQL: How Queries Are Parsed, Optimized, and Executed

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
Inside PostgreSQL: How Queries Are Parsed, Optimized, and Executed
58 Tech
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.

Language ModelQuery ProcessingViterbi algorithm
0 likes · 15 min read
Spelling Correction System for 58.com Search Engine: Rule‑Based and Statistical Methods
Java Backend Technology
Java Backend Technology
Sep 20, 2018 · Databases

Unveiling MySQL: Step‑by‑Step How a SQL Query Is Executed

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 ArchitectureQuery ProcessingSQL Execution
0 likes · 10 min read
Unveiling MySQL: Step‑by‑Step How a SQL Query Is Executed
JD Retail Technology
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 ArchitectureQuery Processingdatabases
0 likes · 11 min read
Design and Evolution of JD Elastic Database: Architecture, Sharding, and Automatic Failover
ITPUB
ITPUB
May 31, 2016 · Databases

Inside PostgreSQL: How SQL Queries Are Processed from Start to Finish

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
Inside PostgreSQL: How SQL Queries Are Processed from Start to Finish
Java High-Performance Architecture
Java High-Performance Architecture
Sep 1, 2015 · Databases

How a Database Server Starts, Handles, and Completes Client Requests

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
How a Database Server Starts, Handles, and Completes Client Requests