Tagged articles
Database Engine
17 articles · Page 1 of 1
The article details DongSQL’s kernel redesign—including RETURNING clause, Hint syntax, CCL concurrency control, statement outlines, and thread‑pool optimizations—showing concrete performance gains in high‑concurrency e‑commerce scenarios.
Database EngineDongSQLSQL
0 likes · 11 min read

RocksDB, an open‑source key‑value storage engine created by Facebook in 2012, delivers high performance, durability, and tunable configurations for flash and SSDs; the article details its core features, internal components such as MemTable and Bloom filters, and real‑world uses in TiDB and Apache Flink.
Database EngineFlinkLSM-tree
0 likes · 10 min read

SQLite 3.46.0 introduces extensive PRAGMA enhancements, new date‑time modifiers, support for underscore digits in numeric literals, a json_pretty() function, significant query planner optimizations, improved JSON handling, and the ability to use large hexadecimal literals as column defaults, all while maintaining its public‑domain, self‑contained nature.
Database EngineJSONPRAGMA
0 likes · 4 min read

SQLite 3.44.0 introduces enhanced aggregate functions with ORDER BY support, new scalar functions like concat(), string_agg(), expanded strftime() format specifiers, additional C APIs, stricter PRAGMA behavior, improved query planner optimizations, runtime detection of long‑double support, and default UTF‑8 handling in the Windows CLI.
Database EngineSQLSQLite
0 likes · 5 min read

SQLite 3.42.0, the widely used public-domain SQL database engine, introduces features such as FTS5 secure-delete, JSON5 support, new sqlite3_config options, enhanced query planner optimizations, CLI improvements, additional SQL functions, extended PRAGMA integrity_check, subsecond time modifiers, and various bug fixes and performance enhancements.
Database EngineFTS5JSON5
0 likes · 5 min read

This article explains the core concepts, architecture, and source‑code details of StarRocks’ Pipeline execution framework, covering BE initialization, query lifecycle management, operator splitting, PipelineBuilder processing, and the scheduling logic of PipelineDriver, with concrete code examples and diagrams to illustrate each step.
Database EnginePipelineStarRocks
0 likes · 21 min read

This article explains how ByteHouse extends ClickHouse by introducing the UniqueMergeTree engine, which adds full upsert and delete support, improves query performance, and enables real‑time audience selection scenarios while preserving scalability and reliability.
ByteHouseClickHouseDatabase Engine
0 likes · 9 min read

SQLite 3.39.3, the latest version of the widely used embedded SQL database engine, introduces RIGHT and FULL OUTER JOIN support, new binary comparison operators IS NOT DISTINCT FROM and IS DISTINCT FROM, additional APIs such as sqlite3_db_name, enhanced file‑name handling, HAVING clause for aggregates, and overall CPU optimizations reducing cycles by about 2.3%.
APIsDatabase EngineSQL
0 likes · 2 min read

This article explains how classic SQL execution engines use the volcano model and expression trees, discusses their performance drawbacks, introduces vectorized execution to reduce overhead, and describes Roaring Bitmap compression methods with container types for efficient storage and processing of integer sets.
Database EngineOperator TreeRoaring Bitmap
0 likes · 10 min read

UniqueMergeTree, a new ClickHouse table engine, addresses real‑time data update challenges by combining upsert semantics, unique key enforcement, and efficient delete‑bitmap handling, offering higher query performance at modest write cost, with detailed design, sharding strategies, conflict resolution, and performance evaluation.
ClickHouseDatabase EngineReal-time Updates
0 likes · 14 min read

SQLite version 3.38.0 introduces new JSON operators compatible with MySQL and PostgreSQL, built‑in JSON functions, added unixepoch() and auto/julianday modifiers for date/time, renamed printf() to format(), enhanced virtual table interfaces, CLI columnar output options, and query planner optimizations using Bloom filters and balanced merge trees.
Database EngineQuery PlannerSQLite
0 likes · 4 min read

This document explains the differences between OLTP and OLAP workloads, introduces the CSTORE columnar storage engine architecture, its core technologies, performance advantages, typical use cases, benchmark results, and future development plans for MySQL 8.0.
CStoreDatabase EngineMySQL
0 likes · 14 min read

Pika 3.0, a C++ open‑source Redis‑compatible storage built on RocksDB, introduces a new blackwidow engine, an improved binlog system, and a more efficient server layer, delivering higher performance, reduced disk usage, extended key length limits, and full Redis ZSET compatibility.
Database EnginePikaRocksDB
0 likes · 3 min read

The article provides a comprehensive overview of TXSQL, Tencent's heavily customized MySQL kernel, detailing its motivations, version choices, performance improvements such as read‑view and redo‑log optimizations, added functionalities like multi‑mode operation and distributed locks, stability testing, financial‑grade features, benchmark results against official MySQL releases, upcoming support for MySQL 5.7, and future development directions.
Cloud DatabaseDatabase EngineDistributed Lock
0 likes · 22 min read

This article examines why MongoDB's WiredTiger storage engine experiences intermittent write hangs, detailing the eviction cache design, hazard pointer concurrency, eviction thread model, checkpoint interactions, performance bottlenecks, and practical mitigation strategies.
Database EngineMongoDBWiredTiger
0 likes · 20 min read

This article explains the architecture and code flow of InnoDB's IO subsystem, covering read/write threads, asynchronous AIO handling, concurrency control, file prefetch strategies, and log write padding, with detailed examples of the underlying C++ structures and functions.
Database EngineIOInnoDB
0 likes · 13 min read


ITPUBOct 31, 2014 · Big Data
The interview with Fourinone creator Peng Yuan reveals the framework's evolution from a parallel computing library to a lightweight 220KB distributed system with its own NoSQL database engine, compares it to Hadoop, discusses the CoolHash design, and outlines Huawei's FusionInsight big‑data platform, while providing open‑source repository links.
Database EngineFourinoneFusionInsight
0 likes · 30 min read
