Execution Engine

Tencent Cloud Developer

Jul 11, 2024 · Databases

LibraDB Execution Engine Architecture Evolution and Optimization

LibraDB, the column‑store replica of TDSQL MySQL, has evolved its execution engine from a simple scatter‑gather model to a vectorized SMP pipeline that integrates MPP parallelism, asynchronous I/O, SIMD‑accelerated aggregation and join operators, work‑stealing, and runtime filters, thereby fully exploiting CPU, memory, network and disk resources for both OLTP and analytical queries.

DatabaseExecution EngineHash Join

0 likes · 22 min read

LibraDB Execution Engine Architecture Evolution and Optimization

vivo Internet Technology

Mar 6, 2024 · Databases

Sharding-JDBC Source Code Analysis and Custom Development

The article dissects Sharding‑JDBC’s five core engines—parsing, routing, rewriting, execution, and merging—highlights production pain points, and details custom extensions such as skipping sharding for specific tables, forcing master routing, runtime configuration refresh, batch‑update handling, sharding‑condition deduplication, full‑route validation, and a simplified component wrapper to ease integration and improve performance.

Custom DevelopmentDatabase MiddlewareExecution Engine

0 likes · 55 min read

Sharding-JDBC Source Code Analysis and Custom Development

Top Architecture Tech Stack

Nov 5, 2023 · Databases

Understanding MySQL Communication Protocols, Parsing, Optimizer, Storage Engines, and Execution Engine

This article explains how MySQL establishes connections, the supported communication protocols and message formats, the lexical and syntactic parsing process, query optimization and execution plan generation, the role of different storage engines, and how the execution engine uses the plan to operate on the storage layer.

Execution EngineMySQLQuery Optimizer

0 likes · 15 min read

Understanding MySQL Communication Protocols, Parsing, Optimizer, Storage Engines, and Execution Engine

DataFunSummit

Oct 6, 2023 · Databases

OceanBase HTAP Capabilities: Architecture, Performance, and Core Technologies

This article provides a comprehensive overview of OceanBase's HTAP capabilities, detailing its core features, technical architecture, execution and storage engines, resource isolation, fast import mechanisms, performance benchmarks, and future enhancements, supported by diagrams and real‑world deployment data.

Distributed DatabaseExecution EngineHTAP

0 likes · 22 min read

OceanBase HTAP Capabilities: Architecture, Performance, and Core Technologies

DataFunTalk

Jul 30, 2023 · Databases

MatrixOne Architecture and OLAP Engine Design Overview

This article presents an in‑depth overview of MatrixOne, an open‑source hyper‑converged cloud‑native database, detailing its three‑tier architecture of compute, data and file services, and explains the design and implementation of its OLAP engine, including parser, planner, optimizer, and push‑based execution pipeline.

Execution EngineMatrixOneOLAP

0 likes · 18 min read

MatrixOne Architecture and OLAP Engine Design Overview

DataFunSummit

Jul 26, 2023 · Databases

Deep Dive into OceanBase HTAP Capabilities and Architecture

This article provides a comprehensive overview of OceanBase, an open‑source distributed database, detailing its evolution, core HTAP features, multi‑tenant architecture, execution engine optimizations, advanced query optimizer, storage engine design, resource isolation mechanisms, fast import capabilities, and performance benchmarks.

Distributed DatabaseExecution EngineHTAP

0 likes · 22 min read

Deep Dive into OceanBase HTAP Capabilities and Architecture