Database Paper Browser

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
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 50 of 57 citing papers.

Rank Citing Paper Year Venue Pagerank
1,324 Starling: A Scalable Query Engine on Cloud Functions 2020 SIGMOD 0.00012585081
1,884 Tuplex: Data Science in Python at Native Code Speed 2021 SIGMOD 0.00010206514
2,242 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.2124242e-05
2,445 Data Management for Data Science: Towards Embedded Analytics 2020 CIDR 8.7999299e-05
2,472 Photon: A Fast Query Engine for Lakehouse Systems 2022 SIGMOD 8.7156826e-05
2,659 HetExchange: Encapsulating heterogeneous CPU-GPU parallelism in JIT compiled engines 2019 VLDB 8.3615158e-05
2,914 Quantifying TPC-H Choke Points and Their Optimizations 2020 VLDB 7.9197583e-05
3,260 Query Processing on Tensor Computation Runtimes 2022 VLDB 7.3091312e-05
3,280 A Layered Aggregate Engine for Analytics Workloads 2019 SIGMOD 7.2813732e-05
3,807 HedgeCut: Maintaining Randomised Trees for Low-Latency Machine Unlearning 2021 SIGMOD 6.7428898e-05
4,184 CoroBase: Coroutine-Oriented Main-Memory Database Engine 2021 VLDB 6.3718449e-05
4,269 Maximizing Persistent Memory Bandwidth Utilization for OLAP Workloads 2021 SIGMOD 6.2950779e-05
4,498 ClickHouse - Lightning Fast Analytics for Everyone 2024 VLDB 6.1351257e-05
4,509 ALP: Adaptive Lossless floating-Point Compression 2023 SIGMOD 6.1251244e-05
4,520 The FastLanes Compression Layout: Decoding >100 Billion Integers per Second with Scalar Code 2023 VLDB 6.1119645e-05
4,700 Tensors: An abstraction for general data processing 2021 VLDB 5.9810592e-05
5,734 Evolution of a Compiling Query Engine 2021 VLDB 5.3471832e-05
5,741 Babelfish: Efficient Execution of Polyglot Queries 2022 VLDB 5.3450701e-05
6,116 Database Processing-in-Memory: An Experimental Study 2020 VLDB 5.1995375e-05
6,218 Charting the Design Space of Query Execution using VOILA 2021 VLDB 5.1462707e-05
6,294 Free Join: Unifying Worst-Case Optimal and Traditional Joins 2023 SIGMOD 5.1202075e-05
6,332 Apache Arrow DataFusion: A Fast, Embeddable, Modular Analytic Query Engine 2024 SIGMOD 5.1021765e-05
6,377 Mitigating the Impedance Mismatch between Prediction Query Execution and Database Engine 2025 SIGMOD 5.0860948e-05
6,668 Mainlining Databases: Supporting Fast Transactional Workloads on Universal Columnar Data File Formats 2021 VLDB 4.9647176e-05
6,694 WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications 2024 SIGMOD 4.9552327e-05
6,703 YeSQL: “You extend SQL” with Rich and Highly Performant User-Defined Functions in Relational Databases 2022 VLDB 4.9514593e-05
6,863 Declarative Sub-Operators for Universal Data Processing 2023 VLDB 4.9003859e-05
7,324 BOSS - An Architecture for Database Kernel Composition 2024 VLDB 4.7565238e-05
7,331 MorphStore: Analytical Query Engine with a Holistic Compression-Enabled Processing Model 2020 VLDB 4.7558046e-05
7,456 BSX : Subgraph Matching with Batch Backtracking Search 2025 SIGMOD 4.7205339e-05
7,472 The Case for Deep Query Optimisation 2020 CIDR 4.7156624e-05
7,817 Hardware-Oblivious SIMD Parallelism for In-Memory Column-Stores 2020 CIDR 4.6400608e-05
8,098 Modularis: Modular Relational Analytics over Heterogeneous Distributed Platforms 2021 VLDB 4.5824106e-05
8,101 Micro-architectural Analysis of OLAP: Limitations and Opportunities 2020 VLDB 4.581825e-05
8,257 DuckPGQ: Efficient Property Graph Queries in an analytical RDBMS 2023 CIDR 4.5437589e-05
8,368 Interleaved Multi-Vectorizing 2020 VLDB 4.5295768e-05
8,477 Excalibur: A Virtual Machine for Adaptive Fine-grained JIT-Compiled Query Execution based on VOILA 2023 VLDB 4.4971772e-05
8,580 Efficient Execution of User-Defined Functions in SQL Queries 2023 VLDB 4.4876382e-05
8,623 Adaptive Code Generation for Data-Intensive Analytics 2021 VLDB 4.4786182e-05
8,689 Boosting Efficiency of External Pipelines by Blurring Application Boundaries 2022 CIDR 4.4619184e-05
8,856 Composable Data Management: An Execution Overview 2024 VLDB 4.4303659e-05
9,122 Dynamic Speculative Optimizations for SQL Compilation in Apache Spark 2020 VLDB 4.3877539e-05
9,765 The UDFBench Benchmark for General-purpose UDF Queries 2025 VLDB 4.2815042e-05
9,900 AnyBlox: A Framework for Self-Decoding Datasets 2025 VLDB 4.2539423e-05
10,238 TurboLynx: Schemaless Graph Engine Strikes Back for General-Purpose Analytics 2026 VLDB 4.1905499e-05
10,271 OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning 2026 VLDB 4.1905499e-05
10,307 Global Hash Tables Strike Back! An Analysis of Parallel GROUP BY Aggregation 2026 VLDB 4.1905499e-05
10,384 Data Chunk Compaction in Vectorized Execution 2025 SIGMOD 4.1905499e-05
10,452 LingoDB-CT: Understanding LingoDB's Inner Workings 2025 SIGMOD 4.1905499e-05
10,714 Extensible and Robust Evaluation of Similarity Queries 2025 VLDB 4.1905499e-05
Previous Page 1 / 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
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
Previous Page 1 / 1 Next

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