DBScholar

Back to papers

Efficiently Compiling Efficient Query Plans for Modern Hardware

Summary: Introduces LLVM-based compilation of queries into compact machine code optimized for locality and predictable branches, overcoming iterator/vectorization overheads. Integrated in HyPer, it approaches hand-written C++ performance with modest compilation time. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
10473
Venue
VLDB
Year
2011
Pagerank
0.00054886415
Overall Rank
23 | 99.85%
DOI
10.14778/2002938.2002944

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{neumann_vldb11,
        title = {{Efficiently Compiling Efficient Query Plans for Modern Hardware}},
        author = {Neumann, Thomas},
        journal = {PVLDB},
        series = {{VLDB} '11},
        volume = {4},
        number = {9},
        pages = {539--550},
        doi = {10.14778/2002938.2002944},
        url = {https://doi.org/10.14778/2002938.2002944},
        year = {2011}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 199 citing papers.

Rank Citing Paper Year Venue Pagerank
38 Hekaton: SQL Server’s Memory-Optimized OLTP Engine 2013 SIGMOD 0.00047648573
66 The Snowflake Elastic Data Warehouse 2016 SIGMOD 0.00038561587
103 DuckDB: an Embeddable Analytical Database 2019 SIGMOD 0.00034161428
211 EmptyHeaded: A Relational Engine for Graph Processing 2016 SIGMOD 0.00024797217
233 Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems 2015 SIGMOD 0.00023815642
237 Amazon Redshift and the Case for Simpler Data Warehouses 2015 SIGMOD 0.0002369895
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
423 Massively Parallel Sort-Merge Joins in Main Memory Multi-Core Database Systems 2012 VLDB 0.00018725853
534 Building Efficient Query Engines in a High-Level Language 2014 VLDB 0.00017046514
547 Cypher: An Evolving Query Language for Property Graphs 2018 SIGMOD 0.00016731552
563 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.0001650812
634 Rethinking SIMD Vectorization for In-Memory Databases 2015 SIGMOD 0.00015533814
649 Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018 VLDB 0.00015320656
941 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00013078348
993 Simulation of Database-Valued Markov Chains Using SimSQL 2013 SIGMOD 0.00012789598
1,076 High-Speed Query Processing over High-Speed Networks 2016 VLDB 0.00012270109
1,199 Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads 2016 SIGMOD 0.00011703966
1,229 Weld: A Common Runtime for High Performance Data Analytics 2017 CIDR 0.00011578425
1,265 An Experimental Comparison of Thirteen Relational Equi-Joins in Main Memory 2016 SIGMOD 0.00011415709
1,367 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00011014419
1,379 Relaxed Operator Fusion for In-Memory Databases: Making Compilation, Vectorization, and Prefetching Work Together At Last 2018 VLDB 0.00010970894
1,442 An Architecture for Compiling UDF-centric Workflows 2015 VLDB 0.00010778486
1,466 A Study of the Fundamental Performance Characteristics of GPUs and CPUs for Database Analytics 2020 SIGMOD 0.0001068941
1,469 Voodoo - A Vector Algebra for Portable Database Performance on Modern Hardware 2016 VLDB 0.00010678751
1,574 Pipelined Query Processing in Coprocessor Environments 2018 SIGMOD 0.00010321274
1,740 Adopting Worst-Case Optimal Joins in Relational Database Systems 2020 VLDB 9.875587e-05
1,768 Tuplex: Data Science in Python at Native Code Speed 2021 SIGMOD 9.8041636e-05
1,797 How to Architect a Query Compiler 2016 SIGMOD 9.7368925e-05
1,798 SMOKE: Fine-grained Lineage at Interactive Speed 2018 VLDB 9.7361937e-05
1,824 Photon: A Fast Query Engine for Lakehouse Systems 2022 SIGMOD 9.6734544e-05
1,892 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.5277793e-05
1,903 Instant Loading for Main Memory Databases 2013 VLDB 9.5049156e-05
1,977 HetExchange: Encapsulating heterogeneous CPU-GPU parallelism in JIT compiled engines 2019 VLDB 9.3641101e-05
2,000 Data Management for Data Science: Towards Embedded Analytics 2020 CIDR 9.3336258e-05
2,156 Quickstep: A Data Platform Based on the Scaling-Up Approach 2018 VLDB 9.0635624e-05
2,239 An Intermediate Representation for Optimizing Machine Learning Pipelines 2019 VLDB 8.8875753e-05
2,250 Cache-Efficient Aggregation: Hashing Is Sorting 2015 SIGMOD 8.8694486e-05
2,316 Evaluating End-to-End Optimization for Data Analytics Applications in Weld 2018 VLDB 8.7596739e-05
2,488 How to Architect a Query Compiler, Revisited 2018 SIGMOD 8.5091578e-05
2,563 AnalyticDB: Real-time OLAP Database System at Alibaba Cloud 2019 VLDB 8.412445e-05
2,583 Towards Scalable Real-time Analytics: An Architecture for Scale-out of OLxP Workloads 2015 VLDB 8.3849987e-05
2,706 Major Technical Advancements in Apache Hive 2014 SIGMOD 8.2287564e-05
2,713 Robust Query Processing in Co-Processor-accelerated Databases 2016 SIGMOD 8.2122726e-05
2,769 A Layered Aggregate Engine for Analytics Workloads 2019 SIGMOD 8.1465406e-05
2,788 BtrBlocks: Efficient Columnar Compression for Data Lakes 2023 SIGMOD 8.1205155e-05
2,823 Query Processing on Tensor Computation Runtimes 2022 VLDB 8.0893814e-05
2,836 HyPer-sonic Combined Transaction AND Query Processing 2011 VLDB 8.0716718e-05
2,935 RaSQL: Greater Power and Performance for Big Data Analytics with Recursive-aggregate-SQL on Spark 2019 SIGMOD 7.9444531e-05
3,062 Adaptive Query Processing on RAW Data 2014 VLDB 7.8037446e-05
Previous Page 1 / 4 Next

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Previous Page 1 / 1 Next

Semantically Similar Papers