Selective Late Materialization in Modern Analytical Databases

Summary: Classic late-materialization loses value in vectorized columnar engines; this paper redefines LM and proposes Selective Late Materialization (SLM), choosing per-attribute, per-query materialization points to minimize cost. Implemented in DuckDB, SLM outperforms early/late materialization on JOB by 14.7%/8.9% average (up to 76.7% per query) and shows similar TPC‑DS gains. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 14072
Venue: VLDB
Year: 2025
Pagerank: 4.1905499e-05
Overall Rank: 10,762 | 25.21%
DOI: 10.14778/3749646.3749717

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 23 of 23 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
30	Hashing Methods and Relational Algebra Operations	1984	VLDB	0.00078665259
35	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.00076209479
71	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059446482
80	Weaving Relations for Cache Performance	2001	VLDB	0.00055735291
132	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.00043697853
185	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00036529607
310	The Vertica Analytic Database: C-Store 7 Years Later	2012	VLDB	0.0002815547
417	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00023734582
708	Performance Tradeoffs in Read-Optimized Databases	2006	VLDB	0.00017753572
729	Umbra: A Disk-Based System with In-Memory Performance	2020	CIDR	0.00017448059
1,260	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD	0.00012990853
1,273	Amazon Redshift Re-invented	2022	SIGMOD	0.00012870386
1,635	Query Processing Techniques for Solid State Drives	2009	SIGMOD	0.00011059682
2,231	Self-organizing Tuple Reconstruction in Column-stores	2009	SIGMOD	9.2367968e-05
2,533	Velox: Meta’s Unified Execution Engine	2022	VLDB	8.5870599e-05
3,419	LeCo: Lightweight Compression via Learning Serial Correlations	2024	SIGMOD	7.1127752e-05
3,719	To Partition, or Not to Partition, That is the Join Question in a Real System	2021	SIGMOD	6.8141176e-05
3,723	Cache-Conscious Radix-Decluster Projections	2004	VLDB	6.8132331e-05
4,272	Looking Ahead Makes Query Plans Robust: Making the Initial Case with In-Memory Star Schema Data Warehouse Workloads	2017	VLDB	6.2933353e-05
4,498	ClickHouse - Lightning Fast Analytics for Everyone	2024	VLDB	6.1351257e-05
6,332	Apache Arrow DataFusion: A Fast, Embeddable, Modular Analytic Query Engine	2024	SIGMOD	5.1021765e-05
7,407	An Examination of CXL Memory Use Cases for In-Memory Database Management Systems using SAP HANA	2024	VLDB	4.7326045e-05
9,742	Databases in the Era of Memory-Centric Computing	2025	CIDR	4.2856385e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
1,110	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD	0.00013902997
7,122	Debunking the Myth of Join Ordering: Toward Robust SQL Analytics	2025	SIGMOD	4.8199209e-05
758	Materialization Optimizations for Feature Selection Workloads	2014	SIGMOD	0.00017053915
5,543	Lightweight Cardinality Estimation in LSM-based Systems	2018	SIGMOD	5.4486922e-05
8,257	DuckPGQ: Efficient Property Graph Queries in an analytical RDBMS	2023	CIDR	4.5437589e-05
8,271	Adaptive Factorization Using Linear-Chained Hash Tables	2025	CIDR	4.539672e-05
7,427	Selection Pushdown in Column Stores using Bit Manipulation Instructions	2023	SIGMOD	4.7282014e-05
10,643	Saving Private Hash Join	2025	VLDB	4.1905499e-05
9,505	Supporting Scalable Analytics with Latency Constraints	2015	VLDB	4.3300131e-05
10,384	Data Chunk Compaction in Vectorized Execution	2025	SIGMOD	4.1905499e-05