DBScholar

Back to papers

The Yin and Yang of Processing Data Warehousing Queries on GPU Devices

Summary: A three-dimensional study of warehousing queries across workloads, software, and GPU configurations, identifying the kernel-versus-data-transfer bottleneck. An analytical performance model and open-source engine guide production-grade GPU warehouse integration. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
h658314d4fa4d58db
Venue
VLDB
Year
2013
Pagerank
0.0001407924
Overall Rank
775 | 94.80%
DOI
10.14778/2733004.2733006

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{yuan_vldb13,
        title = {{The Yin and Yang of Processing Data Warehousing Queries on GPU Devices}},
        author = {Yuan, Yuan and Lee, Rubao and Zhang, Xiaodong},
        journal = {PVLDB},
        series = {{VLDB} '13},
        volume = {6},
        number = {10},
        pages = {817--828},
        doi = {10.14778/2733004.2733006},
        url = {https://doi.org/10.14778/2733004.2733006},
        year = {2013}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 57 citing papers.

Rank Citing Paper Year Venue Pagerank
1,269 A Study of the Fundamental Performance Characteristics of GPUs and CPUs for Database Analytics 2020 SIGMOD 0.00011254742
1,534 Pipelined Query Processing in Coprocessor Environments 2018 SIGMOD 0.00010327147
1,542 HippogriffDB: Balancing I/O and GPU Bandwidth in Big Data Analytics 2016 VLDB 0.0001030858
1,748 HetExchange: Encapsulating heterogeneous CPU-GPU parallelism in JIT compiled engines 2019 VLDB 9.7289385e-05
2,202 Mega-KV: A Case for GPUs to Maximize the Throughput of In-Memory Key-Value Stores 2015 VLDB 8.8707587e-05
2,287 Pump Up the Volume: Processing Large Data on GPUs with Fast Interconnects 2020 SIGMOD 8.691301e-05
2,460 Query Processing on Tensor Computation Runtimes 2022 VLDB 8.4308406e-05
2,466 Concurrent Analytical Query Processing with GPUs 2014 VLDB 8.4182778e-05
2,601 Robust Query Processing in Co-Processor-accelerated Databases 2016 SIGMOD 8.2325291e-05
2,816 GPL: A GPU-based Pipelined Query Processing Engine 2016 SIGMOD 7.9740083e-05
2,887 Efficient Join Algorithms For Large Database Tables in a Multi-GPU Environment 2021 VLDB 7.9044174e-05
3,055 MG-Join: A Scalable Join for Massively Parallel Multi-GPU Architectures 2021 SIGMOD 7.6983202e-05
3,108 SABER: Window-Based Hybrid Stream Processing for Heterogeneous Architectures 2016 SIGMOD 7.6392673e-05
3,491 In-Cache Query Co-Processing on Coupled CPU-GPU Architectures 2015 VLDB 7.2586387e-05
3,628 Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects 2022 SIGMOD 7.1490678e-05
3,657 Tile-based Lightweight Integer Compression in GPU 2022 SIGMOD 7.1227107e-05
3,775 Hardware-conscious Query Processing in GPU-accelerated Analytical Engines 2019 CIDR 7.0261504e-05
3,862 GaccO - A GPU-accelerated OLTP DBMS 2022 SIGMOD 6.9623352e-05
3,888 Orchestrating Data Placement and Query Execution in Heterogeneous CPU-GPU DBMS 2022 VLDB 6.942437e-05
3,934 The Case For Heterogeneous HTAP 2017 CIDR 6.9145781e-05
3,962 Data-Parallel Query Processing on Non-Uniform Data 2020 VLDB 6.8916038e-05
3,974 TCUDB: Accelerating Database with Tensor Processors 2022 SIGMOD 6.8848857e-05
4,138 The Art of Balance: A RateupDB Experience of Building a CPU/GPU Hybrid Database Product 2021 VLDB 6.782996e-05
4,200 Adaptive Work Placement for Query Processing on Heterogeneous Computing Resources 2017 VLDB 6.7378729e-05
4,484 GPU Database Systems Characterization and Optimization 2024 VLDB 6.5776765e-05
4,647 Improving Execution Efficiency of Just-in-time Compilation based Query Processing on GPUs 2021 VLDB 6.4850635e-05
4,946 CXL and the Return of Scale-Up Database Engines 2024 VLDB 6.3412158e-05
4,992 GOLAP: A GPU-in-Data-Path Architecture for High-Speed OLAP 2024 SIGMOD 6.3217714e-05
5,135 Ocelot/HyPE: Optimized Data Processing on Heterogeneous Hardware 2014 VLDB 6.2568126e-05
5,376 Distributed GPU Joins on Fast RDMA-capable Networks 2023 SIGMOD 6.1555648e-05
5,543 Vortex: Overcoming Memory Capacity Limitations in GPU-Accelerated Large-Scale Data Analytics 2025 VLDB 6.0873423e-05
5,616 BOSS - An Architecture for Database Kernel Composition 2024 VLDB 6.0623704e-05
5,991 Terabyte-Scale Analytics in the Blink of an Eye 2026 VLDB 5.9219616e-05
6,008 Mixer: Efficiently Understanding and Retrieving Visual Content at Web-scale 2021 VLDB 5.9125335e-05
6,153 Efficiently Processing Joins and Grouped Aggregations on GPUs 2025 SIGMOD 5.8669913e-05
6,491 HetCache: Synergising NVMe Storage and GPU acceleration for Memory-Efficient Analytics 2023 CIDR 5.7649204e-05
6,518 GPU-accelerated data management under the test of time 2020 CIDR 5.7561332e-05
6,589 Maximus: A Modular Accelerated Query Engine for Data Analytics on Heterogeneous Systems 2025 SIGMOD 5.7401837e-05
6,671 Powerful GPUs or Fast Interconnects: Analyzing Relational Workloads on Modern GPUs 2025 VLDB 5.7125893e-05
7,068 Efficient Top-K Query Processing on Massively Parallel Hardware 2018 SIGMOD 5.6060783e-05
7,325 An Examination of CXL Memory Use Cases for In-Memory Database Management Systems using SAP HANA 2024 VLDB 5.5508106e-05
8,242 Scaling your Hybrid CPU-GPU DBMS to Multiple GPUs 2024 VLDB 5.3684987e-05
8,280 Scaling GPU-Accelerated Databases beyond GPU Memory Size 2025 VLDB 5.3616863e-05
9,364 Evaluating Memory-Hard Proof-of-Work Algorithms on Three Processors 2020 VLDB 5.1850467e-05
9,438 Efficiently Joining Large Relations on Multi-GPU Systems 2025 VLDB 5.1761941e-05
9,870 GPU Acceleration of SQL Analytics on Compressed Data 2026 VLDB 5.115241e-05
10,484 L3: A GPU-Native Co-Designed Data Format for Learned Lossless Lightweight Compression 2026 SIGMOD 4.9769913e-05
10,612 TQEx: Tensor-based Query Engine Enhanced by Bridging the Gap 2026 SIGMOD 4.9769913e-05
10,733 Scalable GPU Acceleration of Scalar Functions in Analytical Databases: Compilation, Benchmarking, and Optimization 2026 VLDB 4.9769913e-05
10,795 MGI: A Communication Framework for Data Processing in Massive GPU Infrastructures 2026 VLDB 4.9769913e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

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

Rank Cited Paper Year Venue Pagerank
61 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD 0.00039236924
304 GPUTeraSort: High Performance Graphics Co-processor Sorting for Large Database Management 2006 SIGMOD 0.00021598803
331 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.0002076806
362 Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs 2011 SIGMOD 0.00019999596
616 Relational Joins on Graphics Processors 2008 SIGMOD 0.00015554627
663 Fast Sort on CPUs and GPUs: A Case for Bandwidth Oblivious SIMD Sort 2010 SIGMOD 0.00014997516
1,034 A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses 2009 VLDB 0.00012389548
1,454 Fast Computation of Database Operations using Graphics Processors 2004 SIGMOD 0.00010596726
1,653 Efficient Parallel Lists Intersection and Index Compression Algorithms using Graphics Processing Units 2011 VLDB 9.969498e-05
2,187 Database Compression on Graphics Processors 2010 VLDB 8.891124e-05
2,478 One Size Fits All? – Part 2: Benchmarking Results 2007 CIDR 8.4063622e-05
2,749 Hardware Acceleration in Commercial Databases: A Case Study of Spatial Operations 2004 VLDB 8.0571049e-05
2,889 High-Throughput Transaction Executions on Graphics Processors 2011 VLDB 7.9034864e-05
8,628 Accelerating Pathology Image Data Cross-Comparison on CPU-GPU Hybrid Systems 2012 VLDB 5.2991344e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 3,775 Hardware-conscious Query Processing in GPU-accelerated Analytical Engines 2019 CIDR
2 8,602 A Case for Graphics-driven Query Processing 2023 VLDB
3 5,400 Towards a Hybrid Design for Fast Query Processing in DB2 with BLU Acceleration Using Graphical Processing Units: A Technology Demonstration 2016 SIGMOD
4 6,518 GPU-accelerated data management under the test of time 2020 CIDR
5 1,269 A Study of the Fundamental Performance Characteristics of GPUs and CPUs for Database Analytics 2020 SIGMOD
6 1,454 Fast Computation of Database Operations using Graphics Processors 2004 SIGMOD
7 3,202 Why it is time for a HyPE: A Hybrid Query Processing Engine for Efficient GPU Coprocessing in DBMS 2013 VLDB
8 4,484 GPU Database Systems Characterization and Optimization 2024 VLDB
9 7,190 GPUQP: Query Co-Processing Using Graphics Processors 2007 SIGMOD
10 2,466 Concurrent Analytical Query Processing with GPUs 2014 VLDB