Selective Late Materialization in Modern Analytical Databases

Summary: Recasts late materialization for vectorized column stores as Selective Late Materialization (SLM), choosing each attribute’s materialization point independently per query. DuckDB integration improves JOB performance 14.7% over early and 8.9% over late materialization, reaching 76.7% per-query latency reduction. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 14259
Venue: VLDB
Year: 2025
Pagerank: 5.093636e-05
Overall Rank: 10,989 | 24.61%
DOI: 10.14778/3749646.3749717

Incoming Non-self Citations Over Time

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

Authors

1. Yihao Liu (Tsinghua University)
2. Shaoxuan Tang (Tsinghua University)
3. Yulong Hui (Tsinghua University)
4. Hangrui Zhou (Tsinghua University)
5. Huanchen Zhang (Tsinghua University)

BibTeX Citation

@article{liu_vldb25,
        title = {{Selective Late Materialization in Modern Analytical Databases}},
        author = {Liu, Yihao and Tang, Shaoxuan and Hui, Yulong and Zhou, Hangrui and Zhang, Huanchen},
        journal = {PVLDB},
        series = {{VLDB} '25},
        volume = {18},
        number = {11},
        pages = {4616--4628},
        doi = {10.14778/3749646.3749717},
        url = {https://doi.org/10.14778/3749646.3749717},
        year = {2025}
}

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
14	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.0006312782
18	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059284255
49	Weaving Relations for Cache Performance	2001	VLDB	0.00043781096
60	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.0003955489
80	Hashing Methods and Relational Algebra Operations	1984	VLDB	0.00036536643
103	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00034161428
186	The Vertica Analytic Database: C-Store 7 Years Later	2012	VLDB	0.00026182534
241	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00023654664
422	Umbra: A Disk-Based System with In-Memory Performance	2020	CIDR	0.00018732744
630	Performance Tradeoffs in Read-Optimized Databases	2006	VLDB	0.00015591796
818	Amazon Redshift Re-invented	2022	SIGMOD	0.00013822916
941	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD	0.00013078348
1,455	Query Processing Techniques for Solid State Drives	2009	SIGMOD	0.00010733981
1,679	Self-organizing Tuple Reconstruction in Column-stores	2009	SIGMOD	0.00010029136
1,757	Velox: Meta's Unified Execution Engine	2022	VLDB	9.8166984e-05
2,962	To Partition, or Not to Partition, That is the Join Question in a Real System	2021	SIGMOD	7.9170451e-05
3,406	Cache-Conscious Radix-Decluster Projections	2004	VLDB	7.4392655e-05
3,571	Looking Ahead Makes Query Plans Robust: Making the Initial Case with In-Memory Star Schema Data Warehouse Workloads	2017	VLDB	7.2991953e-05
3,653	ClickHouse - Lightning Fast Analytics for Everyone	2024	VLDB	7.2241143e-05
4,065	LeCo: Lightweight Compression via Learning Serial Correlations	2024	SIGMOD	6.930275e-05
5,469	Apache Arrow DataFusion: A Fast, Embeddable, Modular Analytic Query Engine	2024	SIGMOD	6.2073056e-05
7,235	An Examination of CXL Memory Use Cases for In-Memory Database Management Systems using SAP HANA	2024	VLDB	5.6655351e-05
9,890	Databases in the Era of Memory-Centric Computing	2025	CIDR	5.1997534e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	929	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
2	5,529	Debunking the Myth of Join Ordering: Toward Robust SQL Analytics	2025	SIGMOD
3	640	Materialization Optimizations for Feature Selection Workloads	2014	SIGMOD
4	4,945	Lightweight Cardinality Estimation in LSM-based Systems	2018	SIGMOD
5	6,999	DuckPGQ: Efficient Property Graph Queries in an analytical RDBMS	2023	CIDR
6	8,232	Adaptive Factorization Using Linear-Chained Hash Tables	2025	CIDR
7	7,139	Selection Pushdown in Column Stores using Bit Manipulation Instructions	2023	SIGMOD
8	10,888	Saving Private Hash Join	2025	VLDB
9	9,640	Supporting Scalable Analytics with Latency Constraints	2015	VLDB
10	10,662	Data Chunk Compaction in Vectorized Execution	2025	SIGMOD