DBScholar

Back to papers

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
h4cd8307d6fa5af46
Venue
VLDB
Year
2018
Pagerank
0.00015609823
Overall Rank
606 | 95.94%
DOI
10.14778/3275366.3275370
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{kersten_vldb18,
        title = {{Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask}},
        author = {Kersten, Timo and Leis, Viktor and Kemper, Alfons and Neumann, Thomas and Pavlo, Andrew and Boncz, Peter},
        journal = {PVLDB},
        series = {{VLDB} '18},
        volume = {11},
        number = {13},
        pages = {2209--2222},
        doi = {10.14778/3275366.3275370},
        url = {https://doi.org/10.14778/3275366.3275370},
        year = {2018}
}

Incoming Citations (Sorted by Pagerank)

Showing 10 of 60 citing papers.

Previous Page 2 / 2 Next

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
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.00063972112
21 Efficiently Compiling Efficient Query Plans for Modern Hardware 2011 VLDB 0.00056737487
93 Encapsulation of Parallelism in the Volcano Query Processing System 1990 SIGMOD 0.00034518001
161 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00027629724
215 Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age 2014 SIGMOD 0.00024554257
218 SIMD-Scan: Ultra Fast in-Memory Table Scan using on-Chip Vector Processing Units 2009 VLDB 0.00024342426
289 Implementing Database Operations Using SIMD Instructions 2002 SIGMOD 0.00021955394
894 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00013179915
946 Enhancements to SQL Server Column Stores 2013 SIGMOD 0.00012911968
1,197 Weld: A Common Runtime for High Performance Data Analytics 2017 CIDR 0.00011548039
1,269 An Experimental Comparison of Thirteen Relational Equi-Joins in Main Memory 2016 SIGMOD 0.00011236561
1,350 Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last 2018 VLDB 0.00010934877
1,449 An Architecture for Compiling UDF-centric Workflows 2015 VLDB 0.00010597074
1,475 Voodoo - A Vector Algebra for Portable Database Performance on Modern Hardware 2016 VLDB 0.00010525713
1,756 How to Architect a Query Compiler 2016 SIGMOD 9.7053947e-05
1,773 SQL Server Column Store Indexes 2011 SIGMOD 9.6751471e-05
2,147 Quickstep: A Data Platform Based on the Scaling-Up Approach 2018 VLDB 8.9595129e-05
2,433 How to Architect a Query Compiler, Revisited 2018 SIGMOD 8.4614165e-05
3,111 Micro Adaptivity in Vectorwise 2013 SIGMOD 7.6224912e-05
3,438 Efficient Processing of Window Functions in Analytical SQL Queries 2015 VLDB 7.2807703e-05
3,905 Analyzing the Impact of System Architecture on the Scalability of OLTP Engines for High-Contention Workloads 2018 VLDB 6.9146292e-05
4,918 Micro-architectural Analysis of In-memory OLTP 2016 SIGMOD 6.3447212e-05
Previous Page 1 / 1 Next

Semantically Similar Papers