Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask

Summary: Apples-to-apples comparison of vectorized and data-centric query processing in a single system. Vectorization hides cache-miss latency; data-centric compilation uses fewer instructions for cache-resident workloads, with SIMD and multi-core effects analyzed. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 11733
Venue: VLDB
Year: 2018
Pagerank: 0.00015940507
Overall Rank: 853 | 94.07%
DOI: 10.14778/3275366.3275370

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 7 of 57 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
10,786	Freely Moving Between the OLTP and OLAP Worlds: Hermes – an High-Performance OLAP Accelerator for MySQL	2025	VLDB	4.1945683e-05
10,969	Query Compilation Without Regrets	2024	SIGMOD	4.1945683e-05
10,989	High-Performance Query Processing with NVMe Arrays: Spilling without Killing Performance	2024	SIGMOD	4.1945683e-05
11,069	Hardware-Efficient Data Imputation through DBMS Extensibility	2024	VLDB	4.1945683e-05
11,090	Simple (yet Efficient) Function Authoring for Vectorized Engines	2024	VLDB	4.1945683e-05
11,269	Big Data Analytic Toolkit: A general-purpose, modular, and heterogeneous acceleration toolkit for data analytical engines	2023	VLDB	4.1945683e-05
11,430	AnyDB: An Architecture-less DBMS for Any Workload	2021	CIDR	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 22 of 22 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.00076197749
60	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.00064439773
113	Encapsulation of Parallelism in the Volcano Query Processing System	1990	SIGMOD	0.00046764513
241	DB2 with BLU Acceleration: So Much More than Just a Column Store	2013	VLDB	0.00031420034
305	SIMD-Scan: Ultra Fast in-Memory Table Scan using on-Chip Vector Processing Units	2009	VLDB	0.00028248614
343	Implementing Database Operations Using SIMD Instructions	2002	SIGMOD	0.00026768139
418	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00023729211
1,223	Enhancements to SQL Server Column Stores	2013	SIGMOD	0.00013207641
1,263	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD	0.00012982857
1,750	Weld: A Common Runtime for High Performance Data Analytics	2017	CIDR	0.00010683647
1,804	An Experimental Comparison of Thirteen Relational Equi-Joins in Main Memory	2016	SIGMOD	0.00010501185
1,864	Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last	2018	VLDB	0.00010280966
1,873	An Architecture for Compiling UDF-centric Workflows	2015	VLDB	0.00010253002
2,014	Voodoo - A Vector Algebra for Portable Database Performance on Modern Hardware	2016	VLDB	9.7904029e-05
2,258	SQL Server Column Store Indexes	2011	SIGMOD	9.1678883e-05
2,383	How to Architect a Query Compiler	2016	SIGMOD	8.9294108e-05
2,772	Quickstep: A Data Platform Based on the Scaling-Up Approach	2018	VLDB	8.1401661e-05
2,838	How to Architect a Query Compiler, Revisited	2018	SIGMOD	8.0408472e-05
3,882	Micro Adaptivity in Vectorwise	2013	SIGMOD	6.6690423e-05
4,262	Efficient Processing of Window Functions in Analytical SQL Queries	2015	VLDB	6.3117226e-05
4,454	Analyzing the Impact of System Architecture on the Scalability of OLTP Engines for High-Contention Workloads	2018	VLDB	6.1715229e-05
5,272	Micro-architectural Analysis of In-memory OLTP	2016	SIGMOD	5.5937875e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
2,383	How to Architect a Query Compiler	2016	SIGMOD	8.9294108e-05
5,559	Rethinking MIMD-SIMD Interplay for Analytical Query Processing in In-Memory Database Engines	2025	CIDR	5.4340893e-05
124	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB	0.00045103515
8,791	One Loop Does Not Fit All	2015	SIGMOD	4.4507369e-05
6,189	Accelerating Python UDFs in Vectorized Query Execution	2022	CIDR	5.1647573e-05
60	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.00064439773
5,723	Evolution of a Compiling Query Engine	2021	VLDB	5.3522361e-05
958	Rethinking SIMD Vectorization for In-Memory Databases	2015	SIGMOD	0.00015045316
9,857	Towards Unifying Query Interpretation and Compilation	2023	CIDR	4.269353e-05
11,850	Vectorizing an In Situ Query Engine	2016	SIGMOD	4.1945683e-05