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: heaabe90f06b0db6c
Venue: CIDR
Year: 2025
Pagerank: 5.4549846e-05
Overall Rank: 7,774 | 47.74%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Paul Groß (Centrum Wiskunde & Informatica)
2. Daniel ten Wolde (Centrum Wiskunde & Informatica)
3. Peter Boncz (Centrum Wiskunde & Informatica)

BibTeX Citation

@inproceedings{gro_cidr25,
        address = {Amsterdam, Netherlands},
        series = {{CIDR} '25},
        title = {{Adaptive Factorization Using Linear-Chained Hash Tables}},
        booktitle = {Proceedings of the {Conference} on {Innovative} {Data} {Systems} {Research}},
        author = {Groß, Paul and Wolde, Daniel ten and Boncz, Peter},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
7,817	Parachute: Single-Pass Bi-Directional Information Passing	2025	VLDB	5.4477841e-05
9,803	ScaleCache: Scalable and Production-grade Buffer Management for Disk-based Database Systems	2025	VLDB	5.1257999e-05
10,842	The Data World Is Not Flat: Efficient Factorized Execution for Relational Systems	2026	VLDB	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 17 of 17 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
14	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.00064031282
71	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00037720227
91	On the Propagation of Errors in the Size of Join Results	1991	SIGMOD	0.0003475226
215	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00024598661
239	The Ubiquity of Large Graphs and Surprising Challenges of Graph Processing	2018	VLDB	0.000235107
315	Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems	2018	PODS	0.00021246
373	Umbra: A Disk-Based System with In-Memory Performance	2020	CIDR	0.00019711632
1,596	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB	0.00010127607
1,752	Kuzu* Graph Database Management System	2023	CIDR	9.7289339e-05
2,290	FDB: A Query Engine for Factorised Relational Databases	2012	VLDB	8.6889284e-05
2,974	Accurate Summary-based Cardinality Estimation Through the Lens of Cardinality Estimation Graphs	2022	VLDB	7.7938744e-05
3,055	The LDBC Social Network Benchmark: Business Intelligence Workload	2023	VLDB	7.6979859e-05
3,131	Every Row Counts: Combining Sketches and Sampling for Accurate Group-By Result Estimates	2019	CIDR	7.6141006e-05
3,153	Robust Join Processing with Diamond Hardened Joins	2024	VLDB	7.5883271e-05
3,204	Columnar Storage and List-based Processing for Graph Database Management Systems	2021	VLDB	7.5400217e-05
5,142	The 3D Hash Join: Building On Non-Unique Join Attributes	2022	CIDR	6.2571095e-05
5,239	DuckPGQ: Bringing SQL/PGQ to DuckDB	2023	VLDB	6.215736e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,677	Efficient Rank Join with Aggregation Constraints	2011	VLDB
2	5,142	The 3D Hash Join: Building On Non-Unique Join Attributes	2022	CIDR
3	5,530	Generalized Hash Teams for Join and Group-by	1999	VLDB
4	853	Hash-Partitioned Join Method Using Dynamic Destaging Strategy	1988	VLDB
5	10,768	One Join Order Does Not Fit All: Reducing Intermediate Results with Per-Split Query Plans	2026	VLDB
6	7,435	Efficient Computation of Quantiles over Joins	2023	PODS
7	1,596	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB
8	4,890	Can Learned Models Replace Hash Functions?	2023	VLDB
9	9,566	Saving Private Hash Join	2025	VLDB
10	10,304	Data Chunk Compaction in Vectorized Execution	2025	SIGMOD