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: 11734
Venue: VLDB
Year: 2018
Pagerank: 0.00015933538
Overall Rank: 848 | 94.11%
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,792	Freely Moving Between the OLTP and OLAP Worlds: Hermes – an High-Performance OLAP Accelerator for MySQL	2025	VLDB	4.1905499e-05
10,972	Query Compilation Without Regrets	2024	SIGMOD	4.1905499e-05
10,992	High-Performance Query Processing with NVMe Arrays: Spilling without Killing Performance	2024	SIGMOD	4.1905499e-05
11,072	Hardware-Efficient Data Imputation through DBMS Extensibility	2024	VLDB	4.1905499e-05
11,093	Simple (yet Efficient) Function Authoring for Vectorized Engines	2024	VLDB	4.1905499e-05
11,271	Big Data Analytic Toolkit: A general-purpose, modular, and heterogeneous acceleration toolkit for data analytical engines	2023	VLDB	4.1905499e-05
11,433	AnyDB: An Architecture-less DBMS for Any Workload	2021	CIDR	4.1905499e-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.00076209479
59	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.0006445664
113	Encapsulation of Parallelism in the Volcano Query Processing System	1990	SIGMOD	0.0004673401
241	DB2 with BLU Acceleration: So Much More than Just a Column Store	2013	VLDB	0.00031314629
307	SIMD-Scan: Ultra Fast in-Memory Table Scan using on-Chip Vector Processing Units	2009	VLDB	0.00028226342
343	Implementing Database Operations Using SIMD Instructions	2002	SIGMOD	0.00026756534
417	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00023734582
1,223	Enhancements to SQL Server Column Stores	2013	SIGMOD	0.00013192321
1,260	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD	0.00012990853
1,751	Weld: A Common Runtime for High Performance Data Analytics	2017	CIDR	0.00010673874
1,800	An Experimental Comparison of Thirteen Relational Equi-Joins in Main Memory	2016	SIGMOD	0.00010494121
1,865	Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last	2018	VLDB	0.00010271333
1,875	An Architecture for Compiling UDF-centric Workflows	2015	VLDB	0.00010243959
2,019	Voodoo - A Vector Algebra for Portable Database Performance on Modern Hardware	2016	VLDB	9.7814175e-05
2,262	SQL Server Column Store Indexes	2011	SIGMOD	9.1629311e-05
2,383	How to Architect a Query Compiler	2016	SIGMOD	8.9198524e-05
2,777	Quickstep: A Data Platform Based on the Scaling-Up Approach	2018	VLDB	8.1346418e-05
2,843	How to Architect a Query Compiler, Revisited	2018	SIGMOD	8.0334687e-05
3,881	Micro Adaptivity in Vectorwise	2013	SIGMOD	6.6638918e-05
4,257	Efficient Processing of Window Functions in Analytical SQL Queries	2015	VLDB	6.3050642e-05
4,452	Analyzing the Impact of System Architecture on the Scalability of OLTP Engines for High-Contention Workloads	2018	VLDB	6.1693569e-05
5,273	Micro-architectural Analysis of In-memory OLTP	2016	SIGMOD	5.5919449e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
2,383	How to Architect a Query Compiler	2016	SIGMOD	8.9198524e-05
5,567	Rethinking MIMD-SIMD Interplay for Analytical Query Processing in In-Memory Database Engines	2025	CIDR	5.4288714e-05
124	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB	0.0004501099
8,788	One Loop Does Not Fit All	2015	SIGMOD	4.4464764e-05
6,191	Accelerating Python UDFs in Vectorized Query Execution	2022	CIDR	5.1598046e-05
59	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.0006445664
5,734	Evolution of a Compiling Query Engine	2021	VLDB	5.3471832e-05
959	Rethinking SIMD Vectorization for In-Memory Databases	2015	SIGMOD	0.00015034808
9,856	Towards Unifying Query Interpretation and Compilation	2023	CIDR	4.2652623e-05
11,858	Vectorizing an In Situ Query Engine	2016	SIGMOD	4.1905499e-05