DBScholar

Back to papers

SIMD-Scan: Ultra Fast in-Memory Table Scan using on-Chip Vector Processing Units

Summary: SIMD-Scan accelerates compressed column-store scans using on-chip SIMD units in commodity CPUs, avoiding GPUs/FPGAs, hardware changes, and data copies. An SSE implementation in SAP BW demonstrates substantial speedups and analyzes multicore scaling. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
h51356daf2d854d53
Venue
VLDB
Year
2009
Pagerank
0.00024363532
Overall Rank
219 | 98.53%
DOI
10.14778/1687627.1687671

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{willhalm_vldb09,
        title = {{SIMD-Scan: Ultra Fast in-Memory Table Scan using on-Chip Vector Processing Units}},
        author = {Willhalm, Thomas and Popovici, Nicolae and Boshmaf, Yazan and Plattner, Hasso and Zeier, Alexander and Schaffner, Jan},
        journal = {PVLDB},
        series = {{VLDB} '09},
        doi = {10.14778/1687627.1687671},
        url = {https://doi.org/10.14778/1687627.1687671},
        year = {2009}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 59 citing papers.

Rank Citing Paper Year Venue Pagerank
21 Efficiently Compiling Efficient Query Plans for Modern Hardware 2011 VLDB 0.00056855599
163 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.0002749118
228 Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems 2015 SIGMOD 0.00023920439
282 FAST: Fast Architecture Sensitive Tree Search on Modern CPUs and GPUs 2010 SIGMOD 0.00022264207
327 Impala: A Modern, Open-Source SQL Engine for Hadoop 2015 CIDR 0.0002095191
575 Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth 2012 SIGMOD 0.00016132182
605 Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018 VLDB 0.00015647561
627 Rethinking SIMD Vectorization for In-Memory Databases 2015 SIGMOD 0.00015460957
873 BitWeaving: Fast Scans for Main Memory Data Processing 2013 SIGMOD 0.00013338838
906 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00013160654
1,116 A Comprehensive Study of Main-Memory Partitioning and its Application to Large-Scale Comparison- and Radix-Sort 2014 SIGMOD 0.00011962096
1,335 Fast Updates on Read-Optimized Databases Using Multi-Core CPUs 2012 VLDB 0.0001099401
1,723 ByteSlice: Pushing the Envelop of Main Memory Data Processing with a New Storage Layout 2015 SIGMOD 9.7931223e-05
1,931 Instant Loading for Main Memory Databases 2013 VLDB 9.3474242e-05
1,973 Decomposed Bounded Floats for Fast Compression and Queries 2021 VLDB 9.2834606e-05
1,995 Track Join: Distributed Joins with Minimal Network Traffic 2014 SIGMOD 9.2169073e-05
2,019 Speeding Up Set Intersections in Graph Algorithms using SIMD Instructions 2018 SIGMOD 9.1750421e-05
2,137 Quickstep: A Data Platform Based on the Scaling-Up Approach 2018 VLDB 8.9777553e-05
2,185 Database Compression on Graphics Processors 2010 VLDB 8.8948351e-05
2,314 BtrBlocks: Efficient Columnar Compression for Data Lakes 2023 SIGMOD 8.6533171e-05
2,628 WideTable: An Accelerator for Analytical Data Processing 2014 VLDB 8.2053454e-05
2,952 Column Sketches: A Scan Accelerator for Rapid and Robust Predicate Evaluation 2018 SIGMOD 7.8153507e-05
2,998 Instant Recovery for Main-Memory Databases 2015 CIDR 7.7688331e-05
3,122 Analytics in Motion: High Performance Event-Processing AND Real-Time Analytics in the Same Database 2015 SIGMOD 7.6236292e-05
3,181 The FastLanes Compression Layout: Decoding >100 Billion Integers per Second with Scalar Code 2023 VLDB 7.5625307e-05
3,393 CloudRAMSort: Fast and Efficient Large-Scale Distributed RAM Sort on Shared-Nothing Cluster 2012 SIGMOD 7.3471344e-05
3,599 Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe? 2017 SIGMOD 7.1773938e-05
3,655 Tile-based Lightweight Integer Compression in GPU 2022 SIGMOD 7.1260841e-05
3,970 The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates 2014 VLDB 6.8895992e-05
4,048 Fast Scans on Key-Value Stores 2017 VLDB 6.8304396e-05
4,055 Scaling Up Concurrent Main-Memory Column-Store Scans: Towards Adaptive NUMA-aware Data and Task Placement 2015 VLDB 6.8270333e-05
4,810 UpBit: Scalable In-Memory Updatable Bitmap Indexing 2016 SIGMOD 6.4050834e-05
4,989 GOLAP: A GPU-in-Data-Path Architecture for High-Speed OLAP 2024 SIGMOD 6.3247654e-05
5,213 A Padded Encoding Scheme to Accelerate Scans by Leveraging Skew 2015 SIGMOD 6.2250048e-05
5,423 Joins on Encoded and Partitioned Data 2014 VLDB 6.1360461e-05
5,471 Good to the Last Bit: Data-Driven Encoding with CodecDB 2021 SIGMOD 6.1181669e-05
5,618 BinDex: A Two-Layered Index for Fast and Robust Scans 2020 SIGMOD 6.0630987e-05
5,801 OLTPShare: The Case for Sharing in OLTP Workloads 2018 VLDB 5.9901054e-05
6,041 Page As You Go: Piecewise Columnar Access In SAP HANA 2016 SIGMOD 5.9063503e-05
6,392 Selection Pushdown in Column Stores using Bit Manipulation Instructions 2023 SIGMOD 5.800848e-05
6,414 Evaluating Multi-GPU Sorting with Modern Interconnects 2022 SIGMOD 5.7927521e-05
6,417 MorphStore: Analytical Query Engine with a Holistic Compression-Enabled Processing Model 2020 VLDB 5.791405e-05
6,441 Grizzly: Efficient Stream Processing Through Adaptive Query Compilation 2020 SIGMOD 5.7834762e-05
7,180 On-Off Sketch: A Fast and Accurate Sketch on Persistence 2021 VLDB 5.5928753e-05
7,481 CUBIT: Concurrent Updatable Bitmap Indexing 2025 VLDB 5.5128501e-05
7,491 AHEAD: Adaptable Data Hardening for On-the-Fly Hardware Error Detection during Database Query Processing 2018 SIGMOD 5.5104779e-05
8,228 Operational Analytics Data Management Systems 2016 VLDB 5.3736562e-05
8,274 Scaling GPU-Accelerated Databases beyond GPU Memory Size 2025 VLDB 5.3642256e-05
8,384 AWARE: Workload-aware, Redundancy-exploiting Linear Algebra 2023 SIGMOD 5.3421754e-05
8,563 Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems 2022 VLDB 5.3138647e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 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