Tagged articles

8 articles

Page 1 of 1

May 5, 2023 · Databases

Mastering Subquery Unnesting: Turn Correlated Queries into Fast Joins

This article explains why correlated subqueries are a performance bottleneck, introduces the Apply (Correlated Join) operator and a systematic set of transformation rules that push Apply down and replace subqueries with efficient joins, covering scalar, existential, and quantified subqueries, aggregation handling, and set operations, all illustrated with TPC‑H examples.

Apply OperatorDatabase EnginesDecorrelate

0 likes · 17 min read

Mastering Subquery Unnesting: Turn Correlated Queries into Fast Joins

Java Architecture Diary

Sep 19, 2022 · Databases

ClickHouse vs Oracle vs esProc SPL: Real‑World TPC‑H Benchmark Reveals Surprising Performance Gaps

A comprehensive TPC‑H benchmark compares ClickHouse, Oracle, and the open‑source esProc SPL across simple and complex queries, showing ClickHouse excels at single‑table scans, while SPL consistently outperforms both in complex calculations and offers more concise code.

ClickHouseColumnar StorageDatabase Performance

0 likes · 12 min read

ClickHouse vs Oracle vs esProc SPL: Real‑World TPC‑H Benchmark Reveals Surprising Performance Gaps

Architect's Tech Stack

Aug 15, 2022 · Databases

Performance Comparison of ClickHouse, Oracle, and esProc SPL Using TPC‑H Benchmarks

This article benchmarks ClickHouse, Oracle, and the open‑source esProc SPL on the TPC‑H suite, showing ClickHouse excels at simple scans, Oracle handles many complex queries, while SPL consistently outperforms both in speed and code simplicity across a range of workloads.

ClickHouseColumnar StorageDatabase Performance

0 likes · 12 min read

Performance Comparison of ClickHouse, Oracle, and esProc SPL Using TPC‑H Benchmarks

Alibaba Cloud Developer

May 27, 2021 · Databases

How OceanBase Set a New TPC‑H Record and the Future of HTAP Databases

OceanBase achieved a world‑record TPC‑H performance of 15.26 million QphH, illustrating its HTAP capabilities and detailing the technical evolution, challenges, and future direction of hybrid transactional/analytical processing in modern distributed databases.

Database PerformanceHTAPHybrid Transactional Analytical Processing

0 likes · 18 min read

How OceanBase Set a New TPC‑H Record and the Future of HTAP Databases

AntTech

May 21, 2021 · Databases

OceanBase HTAP: Technical Insights Behind the TPC‑H World Record

This article explains how OceanBase, a distributed relational database, achieved a new TPC‑H world record, discusses the evolution of HTAP technology, the architectural challenges of combining transactional and analytical workloads, and the future direction of the product.

HTAPHybrid Transactional Analytical ProcessingOceanBase

0 likes · 17 min read

OceanBase HTAP: Technical Insights Behind the TPC‑H World Record

Alibaba Cloud Developer

May 21, 2021 · Databases

How OceanBase Crushed the TPC‑H Benchmark with HTAP Innovation

OceanBase, the distributed relational database from Ant Group, set a new TPC‑H world record by leveraging its HTAP architecture, blending transaction and analytical processing, and the article details the technical evolution, challenges, and future direction of this hybrid database technology.

HTAPHybrid ProcessingOceanBase

0 likes · 17 min read

How OceanBase Crushed the TPC‑H Benchmark with HTAP Innovation

ITPUB

Oct 19, 2020 · Databases

How Many Rows Can an InnoDB B+ Tree Store? A Deep Dive into Page Size and Tree Height

This article explains how InnoDB’s B+ tree storage works, calculates the approximate number of rows a single tree can hold based on page size, record size, and tree height, and shows how to determine the tree height from the tablespace file.

B+TreeDatabase StorageIndex Height

0 likes · 9 min read

How Many Rows Can an InnoDB B+ Tree Store? A Deep Dive into Page Size and Tree Height

Architects Research Society

Jan 30, 2020 · Databases

PostgreSQL 11 JIT Expression Compiler: Benchmark Results with TPC‑H Q1

The article explains PostgreSQL 11’s new JIT expression compiler, describes how it was benchmarked using the TPC‑H Q1 query on a 22 GB dataset, presents performance improvements over PostgreSQL 10, and provides details on the testing environment, configuration files, and future expectations.

BenchmarkJITPostgreSQL

0 likes · 11 min read

PostgreSQL 11 JIT Expression Compiler: Benchmark Results with TPC‑H Q1