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
10931
Venue
VLDB
Year
2013
Pagerank
0.00013792901
Overall Rank
823 | 94.36%
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 53 citing papers.

Rank Citing Paper Year Venue Pagerank
1,466 A Study of the Fundamental Performance Characteristics of GPUs and CPUs for Database Analytics 2020 SIGMOD 0.0001068941
1,574 Pipelined Query Processing in Coprocessor Environments 2018 SIGMOD 0.00010321274
1,666 HippogriffDB: Balancing I/O and GPU Bandwidth in Big Data Analytics 2016 VLDB 0.00010068964
1,977 HetExchange: Encapsulating heterogeneous CPU-GPU parallelism in JIT compiled engines 2019 VLDB 9.3641101e-05
2,498 Mega-KV: A Case for GPUs to Maximize the Throughput of In-Memory Key-Value Stores 2015 VLDB 8.5016595e-05
2,504 Concurrent Analytical Query Processing with GPUs 2014 VLDB 8.4963369e-05
2,566 Pump Up the Volume: Processing Large Data on GPUs with Fast Interconnects 2020 SIGMOD 8.4116562e-05
2,713 Robust Query Processing in Co-Processor-accelerated Databases 2016 SIGMOD 8.2122726e-05
2,823 Query Processing on Tensor Computation Runtimes 2022 VLDB 8.0893814e-05
2,848 GPL: A GPU-based Pipelined Query Processing Engine 2016 SIGMOD 8.0538815e-05
3,060 SABER: Window-Based Hybrid Stream Processing for Heterogeneous Architectures 2016 SIGMOD 7.8062155e-05
3,134 Efficient Join Algorithms For Large Database Tables in a Multi-GPU Environment 2021 VLDB 7.7231028e-05
3,227 MG-Join: A Scalable Join for Massively Parallel Multi-GPU Architectures 2021 SIGMOD 7.6217889e-05
3,471 In-Cache Query Co-Processing on Coupled CPU-GPU Architectures 2015 VLDB 7.3885861e-05
3,791 Hardware-conscious Query Processing in GPU-accelerated Analytical Engines 2019 CIDR 7.1235328e-05
3,890 GaccO - A GPU-accelerated OLTP DBMS 2022 SIGMOD 7.0435206e-05
3,895 The Case For Heterogeneous HTAP 2017 CIDR 7.0416054e-05
4,089 TCUDB: Accelerating Database with Tensor Processors 2022 SIGMOD 6.9096857e-05
4,144 Tile-based Lightweight Integer Compression in GPU 2022 SIGMOD 6.8744592e-05
4,243 Orchestrating Data Placement and Query Execution in Heterogeneous CPU-GPU DBMS 2022 VLDB 6.8073248e-05
4,376 Adaptive Work Placement for Query Processing on Heterogeneous Computing Resources 2017 VLDB 6.7364442e-05
4,535 Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects 2022 SIGMOD 6.6419266e-05
4,585 Data-Parallel Query Processing on Non-Uniform Data 2020 VLDB 6.6175897e-05
4,603 The Art of Balance: A RateupDB Experience of Building a CPU/GPU Hybrid Database Product 2021 VLDB 6.6105578e-05
4,861 CXL and the Return of Scale-Up Database Engines 2024 VLDB 6.4747307e-05
5,092 Ocelot/HyPE: Optimized Data Processing on Heterogeneous Hardware 2014 VLDB 6.3669454e-05
5,422 GPU Database Systems Characterization and Optimization 2024 VLDB 6.2245373e-05
5,587 Distributed GPU Joins on Fast RDMA-capable Networks 2023 SIGMOD 6.1596139e-05
5,778 GOLAP: A GPU-in-Data-Path Architecture for High-Speed OLAP 2024 SIGMOD 6.0918646e-05
5,807 Improving Execution Efficiency of Just-in-time Compilation based Query Processing on GPUs 2021 VLDB 6.0805143e-05
6,043 Mixer: Efficiently Understanding and Retrieving Visual Content at Web-scale 2021 VLDB 5.9966613e-05
6,065 Vortex: Overcoming Memory Capacity Limitations in GPU-Accelerated Large-Scale Data Analytics 2025 VLDB 5.9895288e-05
6,487 HetCache: Synergising NVMe Storage and GPU acceleration for Memory-Efficient Analytics 2023 CIDR 5.8651793e-05
6,835 GPU-accelerated data management under the test of time 2020 CIDR 5.7584924e-05
7,058 BOSS - An Architecture for Database Kernel Composition 2024 VLDB 5.7154673e-05
7,235 An Examination of CXL Memory Use Cases for In-Memory Database Management Systems using SAP HANA 2024 VLDB 5.6655351e-05
7,370 Efficient Top-K Query Processing on Massively Parallel Hardware 2018 SIGMOD 5.6313494e-05
7,432 Powerful GPUs or Fast Interconnects: Analyzing Relational Workloads on Modern GPUs 2025 VLDB 5.6199783e-05
7,591 Efficiently Processing Joins and Grouped Aggregations on GPUs 2025 SIGMOD 5.5900315e-05
7,959 Terabyte-Scale Analytics in the Blink of an Eye 2026 VLDB 5.5181056e-05
8,053 Maximus: A Modular Accelerated Query Engine for Data Analytics on Heterogeneous Systems 2025 SIGMOD 5.4990605e-05
8,808 Scaling your Hybrid CPU-GPU DBMS to Multiple GPUs 2024 VLDB 5.3661351e-05
9,180 Evaluating Memory-Hard Proof-of-Work Algorithms on Three Processors 2020 VLDB 5.3065675e-05
9,333 Efficiently Joining Large Relations on Multi-GPU Systems 2025 VLDB 5.2887551e-05
10,260 L3: A GPU-Native Co-Designed Data Format for Learned Lossless Lightweight Compression 2026 SIGMOD 5.093636e-05
10,409 TQEx: Tensor-based Query Engine Enhanced by Bridging the Gap 2026 SIGMOD 5.093636e-05
10,541 Scalable GPU Acceleration of Scalar Functions in Analytical Databases: Compilation, Benchmarking, and Optimization 2026 VLDB 5.093636e-05
10,580 GPU Acceleration of SQL Analytics on Compressed Data 2026 VLDB 5.093636e-05
10,588 RayDB: Building Databases with Ray Tracing Cores 2026 VLDB 5.093636e-05
10,889 Concurrency Control as a Service 2025 VLDB 5.093636e-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
60 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD 0.0003955489
305 GPUTeraSort: High Performance Graphics Co-processor Sorting for Large Database Management 2006 SIGMOD 0.00021872796
345 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00020656723
360 Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs 2011 SIGMOD 0.00020182846
631 Relational Joins on Graphics Processors 2008 SIGMOD 0.00015591241
678 Fast Sort on CPUs and GPUs: A Case for Bandwidth Oblivious SIMD Sort 2010 SIGMOD 0.00015061068
1,022 A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses 2009 VLDB 0.00012602841
1,452 Fast Computation of Database Operations using Graphics Processors 2004 SIGMOD 0.00010745803
1,655 Efficient Parallel Lists Intersection and Index Compression Algorithms using Graphics Processing Units 2011 VLDB 0.00010103504
2,232 Database Compression on Graphics Processors 2010 VLDB 8.8970926e-05
2,451 One Size Fits All? – Part 2: Benchmarking Results 2007 CIDR 8.560157e-05
2,741 Hardware Acceleration in Commercial Databases: A Case Study of Spatial Operations 2004 VLDB 8.1851944e-05
2,885 High-Throughput Transaction Executions on Graphics Processors 2011 VLDB 7.9969529e-05
8,580 Accelerating Pathology Image Data Cross-Comparison on CPU-GPU Hybrid Systems 2012 VLDB 5.4082911e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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