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: 14071
Venue: VLDB
Year: 2025
Pagerank: 4.1945683e-05
Overall Rank: 10,756 | 25.18%
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.00078672446
35	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.00076197749
71	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059038975
80	Weaving Relations for Cache Performance	2001	VLDB	0.00055721729
131	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.0004370331
185	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00036538405
310	The Vertica Analytic Database: C-Store 7 Years Later	2012	VLDB	0.00028132402
418	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00023729211
710	Performance Tradeoffs in Read-Optimized Databases	2006	VLDB	0.00017765454
735	Umbra: A Disk-Based System with In-Memory Performance	2020	CIDR	0.00017452467
1,263	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD	0.00012982857
1,284	Amazon Redshift Re-invented	2022	SIGMOD	0.00012837822
1,653	Query Processing Techniques for Solid State Drives	2009	SIGMOD	0.00011003558
2,229	Self-organizing Tuple Reconstruction in Column-stores	2009	SIGMOD	9.2350274e-05
2,528	Velox: Meta’s Unified Execution Engine	2022	VLDB	8.59454e-05
3,416	LeCo: Lightweight Compression via Learning Serial Correlations	2024	SIGMOD	7.1196234e-05
3,721	To Partition, or Not to Partition, That is the Join Question in a Real System	2021	SIGMOD	6.8179379e-05
3,722	Cache-Conscious Radix-Decluster Projections	2004	VLDB	6.8176075e-05
4,276	Looking Ahead Makes Query Plans Robust: Making the Initial Case with In-Memory Star Schema Data Warehouse Workloads	2017	VLDB	6.2976602e-05
4,495	ClickHouse - Lightning Fast Analytics for Everyone	2024	VLDB	6.1410277e-05
6,340	Apache Arrow DataFusion: A Fast, Embeddable, Modular Analytic Query Engine	2024	SIGMOD	5.1051018e-05
7,408	An Examination of CXL Memory Use Cases for In-Memory Database Management Systems using SAP HANA	2024	VLDB	4.7371479e-05
9,743	Databases in the Era of Memory-Centric Computing	2025	CIDR	4.2897489e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
1,112	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD	0.00013917776
7,126	Debunking the Myth of Join Ordering: Toward Robust SQL Analytics	2025	SIGMOD	4.8232367e-05
761	Materialization Optimizations for Feature Selection Workloads	2014	SIGMOD	0.00017053783
5,535	Lightweight Cardinality Estimation in LSM-based Systems	2018	SIGMOD	5.4539235e-05
8,276	DuckPGQ: Efficient Property Graph Queries in an analytical RDBMS	2023	CIDR	4.5439811e-05
8,275	Adaptive Factorization Using Linear-Chained Hash Tables	2025	CIDR	4.5439841e-05
7,427	Selection Pushdown in Column Stores using Bit Manipulation Instructions	2023	SIGMOD	4.7327406e-05
10,635	Saving Private Hash Join	2025	VLDB	4.1945683e-05
9,504	Supporting Scalable Analytics with Latency Constraints	2015	VLDB	4.3341665e-05
10,372	Data Chunk Compaction in Vectorized Execution	2025	SIGMOD	4.1945683e-05