Apache Calcite: A Platform for Building Advanced SQL Optimizers on Java
summary
Apache Calcite is presented as a Java platform for building advanced cost-based SQL optimizers from reusable components so teams avoid implementing optimizers from scratch. The talk covers theoretical problems of query optimization, Calcite’s architecture and core algorithms, and shows examples of integrating Calcite into real Java products.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 3:20What is Apache Calcite
- 8:55SQL query processing stages
- 13:28Query intermediate representation
- 17:38Query optimization rules
- 25:45Plan cost estimation
- 31:43Cost-based optimization
- 36:44Operator physical properties
- 43:45Cascades algorithm
- 52:05Optimizer limitations
- 55:14Calcite additional features
- 56:19Q&A
related talks
39mBuilding modern SQL query optimizers with Apache Calcite
41mStreaming SQL
01h 04mQuery Optimization and Acceleration at Dremio
31mWriting a Streaming SQL & Materialized View Engine
57mHow modern SQL databases arrive at algorithms you never dreamed of
41mHydra's Heads – Vladimir Ozerov
14mAn introduction to Apache Kylin Business Intelligence ...
43mCaching and Beyond - Smarter Data Processing with Java