Tagged articles
analytical database
11 articles · Page 1 of 1
StarRocks, an open‑source, high‑performance MPP analytical database under the Linux Foundation, offers vectorized engines, CBO optimizer, materialized views, and storage‑compute separation, integrates with BI tools and data lakes, and demonstrates superior query speed in benchmark tests against ClickHouse, Druid, and Trino.
MPPStarRocksanalytical database
0 likes · 10 min read

The article explains why analytical databases struggle with real‑time data changes due to columnar storage, complex indexes and distributed processing, and then details StarRocks' primary‑key model, adaptive update mode, bitmap indexes, row/column partial updates, and practical SQL upsert techniques to achieve low‑latency updates without sacrificing query performance.
Partial UpdatePrimary KeyReal-Time Update
0 likes · 15 min read

This article provides a comprehensive overview of Apache Doris, detailing its origins, MPP‑based analytical capabilities, data‑lake integration techniques, recent architectural enhancements, performance optimizations, community growth, and upcoming development plans, while also addressing common user questions.
Apache DorisMPPSQL
0 likes · 20 min read

This article explains the architecture and key components of distributed analytical databases, contrasting them with MPP systems, and details the design of StarRing’s ArgoDB—including its storage, compute, transaction, and SQL engines—highlighting scalability, elasticity, and resource management for modern data warehousing.
ArgoDBSQLanalytical database
0 likes · 16 min read

The article introduces DuckDB, a high‑performance embedded analytical database, outlines its new release’s storage, performance, and memory improvements, describes its C/C++ integration and build process, and lists key feature changes such as parallel execution, novel compression methods, and enhanced SQL capabilities.
CompressionDuckDBParallelism
0 likes · 3 min read

SelectDB, a new cloud‑native data warehouse built on Apache Doris, topped the ClickBench analytical database benchmark on c6a.4xlarge 500 GB gp2 instances, outpacing ClickHouse by 35% in Hot Run and 25% in Cold Run while also delivering high write throughput of over 140 MB/s.
ClickBenchClickHouseCloud Data Warehouse
0 likes · 6 min read

This article introduces Apache Doris 1.0, detailing its simplified architecture, high‑concurrency support, MPP execution engine, vectorized engine, memory‑controlled stability, multi‑source integration, upcoming lake‑house unification, storage‑compute separation, real‑time ingestion, and community growth.
Apache DorisMPPVectorized Engine
0 likes · 18 min read

On June 16, 2022 the Apache Software Foundation announced that Apache Doris has graduated from the incubator to become a Top‑Level Project, highlighting its high‑performance MPP analytical database capabilities, broad industry adoption, and a vibrant open‑source community.
Apache DorisTop-Level Projectanalytical database
0 likes · 8 min read

This article compares Apache Doris and ClickHouse across architecture, deployment, multi‑tenant management, data import, storage, query capabilities, performance testing, and cost, providing practical guidance for selecting the most suitable analytical database in large‑scale OLAP scenarios.
Apache DorisClickHouseOLAP
0 likes · 26 min read

This article details 58 Group's comprehensive evaluation of DorisDB, TiFlash, and ClickHouse for large‑scale analytical workloads, covering functional and performance benchmarks, real‑world use cases such as security analysis and DBA operations, data ingestion methods, cluster architecture, automation practices, and lessons learned.
Data IngestionDorisDBOperations
0 likes · 10 min read

This article explains how JD Cloud’s JCHDB, built on ClickHouse, achieves millisecond‑level queries on billions of rows through columnar storage, distributed multi‑master architecture, SIMD vector engine, sparse indexing, and specialized table engines, and outlines the ideal use cases and deployment details.
ClickHouseJCHDBanalytical database
0 likes · 10 min read
