Adaptive Factorization Using Linear-Chained Hash Tables

Summary: Adds adaptive factorized aggregations and runtime-chosen worst-case-optimal joins to DuckDB via a collision-free linear-chained hash table that enables efficient factorized/WCOJ execution. Decisions use on-the-fly sketches, heuristics, and ML to obtain stats from subqueries/Parquet, yielding near-optimal performance with explainable low-cost alternatives. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 548
Venue: CIDR
Year: 2025
Pagerank: 4.539672e-05
Overall Rank: 8,271 | 42.52%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
8,711	Parachute: Single-Pass Bi-Directional Information Passing	2025	VLDB	4.4582346e-05
10,789	ScaleCache: Scalable and Production-grade Buffer Management for Disk-based Database Systems	2025	VLDB	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 16 of 16 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
35	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.00076209479
100	On the Propagation of Errors in the Size of Join Results	1991	SIGMOD	0.00050033475
185	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00036529607
327	The Ubiquity of Large Graphs and Surprising Challenges of Graph Processing	2018	VLDB	0.00027312381
417	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00023734582
729	Umbra: A Disk-Based System with In-Memory Performance	2020	CIDR	0.00017448059
2,281	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB	9.122455e-05
2,962	Kuzu* Graph Database Management System	2023	CIDR	7.8069285e-05
3,088	FDB: A Query Engine for Factorised Relational Databases	2012	VLDB	7.5940302e-05
3,516	Accurate Summary-based Cardinality Estimation Through the Lens of Cardinality Estimation Graphs	2022	VLDB	7.018912e-05
3,670	The LDBC Social Network Benchmark: Business Intelligence Workload	2023	VLDB	6.8557811e-05
3,706	Every Row Counts: Combining Sketches and Sampling for Accurate Group-By Result Estimates	2019	CIDR	6.8232992e-05
4,017	Columnar Storage and List-based Processing for Graph Database Management Systems	2021	VLDB	6.5276062e-05
4,466	Robust Join Processing with Diamond Hardened Joins	2024	VLDB	6.1545841e-05
6,523	The 3D Hash Join: Building On Non-Unique Join Attributes	2022	CIDR	5.0228804e-05
7,021	DuckPGQ: Bringing SQL/PGQ to DuckDB	2023	VLDB	4.8546368e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
8,663	Advancing Fact Attribution for Query Answering: Aggregate Queries and Novel Algorithms	2025	VLDB	4.4676883e-05
12,199	Efficient Rank Join with Aggregation Constraints	2011	VLDB	4.1905499e-05
6,523	The 3D Hash Join: Building On Non-Unique Join Attributes	2022	CIDR	5.0228804e-05
5,329	Generalized Hash Teams for Join and Group-by	1999	VLDB	5.5652298e-05
549	Hash-Partitioned Join Method Using Dynamic Destaging Strategy	1988	VLDB	0.00020348047
8,065	Efficient Computation of Quantiles over Joins	2023	PODS	4.5899218e-05
2,281	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB	9.122455e-05
5,323	Can Learned Models Replace Hash Functions?	2023	VLDB	5.5671086e-05
10,643	Saving Private Hash Join	2025	VLDB	4.1905499e-05
10,384	Data Chunk Compaction in Vectorized Execution	2025	SIGMOD	4.1905499e-05