Hash, Sort-Merge, Broadcast: How Distributed Joins Work

Hash, Sort-Merge, Broadcast: How Distributed Joins Work

How Query Engines Think: The Tradeoffs Behind Every Data System

How StarRocks' Cost-Based Optimizer Enables High-Performance Joins in Distributed Systems

This technical deep dive explores how StarRocks, a distributed database system, achieves high-performance joins through its cost-based optim

Graph Theory Approach to Worst Case Optimal Joins in Database Query Processing

This article introduces the concept of Worst Case Optimal Joins through the lens of graph theory, using TPC-H Query 5 (Local Supplier Volume

Inside the Query Optimizer: How Engines Pick a Plan

Technical Discussion: Distributed SQL Engine Requirements for Ultra-Wide Tables in ML and Multi-Omics Data

A technical discussion about the limitations of current SQL databases and data processing systems when handling ultra-wide tables with thous