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.00014258503
Overall Rank
748 | 94.99%
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 59 citing papers.

Rank Citing Paper Year Venue Pagerank
1,228 A Study of the Fundamental Performance Characteristics of GPUs and CPUs for Database Analytics 2020 SIGMOD 0.00011425748
1,530 Pipelined Query Processing in Coprocessor Environments 2018 SIGMOD 0.00010318943
1,537 HippogriffDB: Balancing I/O and GPU Bandwidth in Big Data Analytics 2016 VLDB 0.00010296073
1,748 HetExchange: Encapsulating heterogeneous CPU-GPU parallelism in JIT compiled engines 2019 VLDB 9.7176232e-05
2,208 Mega-KV: A Case for GPUs to Maximize the Throughput of In-Memory Key-Value Stores 2015 VLDB 8.8459331e-05
2,294 Pump Up the Volume: Processing Large Data on GPUs with Fast Interconnects 2020 SIGMOD 8.67775e-05
2,464 Query Processing on Tensor Computation Runtimes 2022 VLDB 8.4081954e-05
2,468 Concurrent Analytical Query Processing with GPUs 2014 VLDB 8.402961e-05
2,606 Robust Query Processing in Co-Processor-accelerated Databases 2016 SIGMOD 8.2118469e-05
2,808 GPL: A GPU-based Pipelined Query Processing Engine 2016 SIGMOD 7.962315e-05
2,886 Efficient Join Algorithms For Large Database Tables in a Multi-GPU Environment 2021 VLDB 7.8911081e-05
3,056 MG-Join: A Scalable Join for Massively Parallel Multi-GPU Architectures 2021 SIGMOD 7.689069e-05
3,117 SABER: Window-Based Hybrid Stream Processing for Heterogeneous Architectures 2016 SIGMOD 7.6142606e-05
3,471 Tile-based Lightweight Integer Compression in GPU 2022 SIGMOD 7.258594e-05
3,495 In-Cache Query Co-Processing on Coupled CPU-GPU Architectures 2015 VLDB 7.237656e-05
3,622 Triton Join: Efficiently Scaling to a Large Join State on GPUs with Fast Interconnects 2022 SIGMOD 7.1350619e-05
3,775 Hardware-conscious Query Processing in GPU-accelerated Analytical Engines 2019 CIDR 7.0079979e-05
3,828 Orchestrating Data Placement and Query Execution in Heterogeneous CPU-GPU DBMS 2022 VLDB 6.9779559e-05
3,868 GaccO - A GPU-accelerated OLTP DBMS 2022 SIGMOD 6.9436655e-05
3,869 The Case For Heterogeneous HTAP 2017 CIDR 6.9434054e-05
3,968 Data-Parallel Query Processing on Non-Uniform Data 2020 VLDB 6.8770248e-05
3,982 TCUDB: Accelerating Database with Tensor Processors 2022 SIGMOD 6.8663329e-05
4,063 The Art of Balance: A RateupDB Experience of Building a CPU/GPU Hybrid Database Product 2021 VLDB 6.812902e-05
4,164 GPU Database Systems Characterization and Optimization 2024 VLDB 6.7560016e-05
4,210 Adaptive Work Placement for Query Processing on Heterogeneous Computing Resources 2017 VLDB 6.7206837e-05
4,650 Improving Execution Efficiency of Just-in-time Compilation based Query Processing on GPUs 2021 VLDB 6.471543e-05
4,872 GOLAP: A GPU-in-Data-Path Architecture for High-Speed OLAP 2024 SIGMOD 6.3582628e-05
4,951 CXL and the Return of Scale-Up Database Engines 2024 VLDB 6.3269877e-05
5,147 Ocelot/HyPE: Optimized Data Processing on Heterogeneous Hardware 2014 VLDB 6.2392014e-05
5,373 Distributed GPU Joins on Fast RDMA-capable Networks 2023 SIGMOD 6.1405913e-05
5,425 Vortex: Overcoming Memory Capacity Limitations in GPU-Accelerated Large-Scale Data Analytics 2025 VLDB 6.121543e-05
5,629 BOSS - An Architecture for Database Kernel Composition 2024 VLDB 6.0424626e-05
5,721 Efficiently Processing Joins and Grouped Aggregations on GPUs 2025 SIGMOD 6.0008904e-05
6,003 Terabyte-Scale Analytics in the Blink of an Eye 2026 VLDB 5.9023799e-05
6,018 Mixer: Efficiently Understanding and Retrieving Visual Content at Web-scale 2021 VLDB 5.8939406e-05
6,393 GPU-accelerated data management under the test of time 2020 CIDR 5.7858902e-05
6,499 HetCache: Synergising NVMe Storage and GPU acceleration for Memory-Efficient Analytics 2023 CIDR 5.7482323e-05
6,571 Maximus: A Modular Accelerated Query Engine for Data Analytics on Heterogeneous Systems 2025 SIGMOD 5.7278348e-05
6,685 Powerful GPUs or Fast Interconnects: Analyzing Relational Workloads on Modern GPUs 2025 VLDB 5.6936999e-05
7,089 Efficient Top-K Query Processing on Massively Parallel Hardware 2018 SIGMOD 5.5875411e-05
7,343 An Examination of CXL Memory Use Cases for In-Memory Database Management Systems using SAP HANA 2024 VLDB 5.5324561e-05
7,973 Scaling your Hybrid CPU-GPU DBMS to Multiple GPUs 2024 VLDB 5.3991259e-05
8,007 Scaling GPU-Accelerated Databases beyond GPU Memory Size 2025 VLDB 5.3916546e-05
9,145 Efficiently Joining Large Relations on Multi-GPU Systems 2025 VLDB 5.2067758e-05
9,390 Evaluating Memory-Hard Proof-of-Work Algorithms on Three Processors 2020 VLDB 5.1679017e-05
9,905 GPU Acceleration of SQL Analytics on Compressed Data 2026 VLDB 5.0983269e-05
10,399 G-CasDec: General Cascaded Decompression on GPUs 2027 SIGMOD 4.9605343e-05
10,400 HeraDB: Towards Real-time Analysis of Transaction-Centric HTAP with CPU-GPU Hybrid Query Execution 2027 SIGMOD 4.9605343e-05
10,550 L3: A GPU-Native Co-Designed Data Format for Learned Lossless Lightweight Compression 2026 SIGMOD 4.9605343e-05
10,673 TQEx: Tensor-based Query Engine Enhanced by Bridging the Gap 2026 SIGMOD 4.9605343e-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.00039323387
304 GPUTeraSort: High Performance Graphics Co-processor Sorting for Large Database Management 2006 SIGMOD 0.00021569633
332 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00020739447
360 Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs 2011 SIGMOD 0.00019959166
610 Relational Joins on Graphics Processors 2008 SIGMOD 0.00015540189
662 Fast Sort on CPUs and GPUs: A Case for Bandwidth Oblivious SIMD Sort 2010 SIGMOD 0.00014972958
1,029 A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses 2009 VLDB 0.00012380835
1,454 Fast Computation of Database Operations using Graphics Processors 2004 SIGMOD 0.0001058211
1,658 Efficient Parallel Lists Intersection and Index Compression Algorithms using Graphics Processing Units 2011 VLDB 9.945593e-05
2,104 Database Compression on Graphics Processors 2010 VLDB 9.0262021e-05
2,477 One Size Fits All? – Part 2: Benchmarking Results 2007 CIDR 8.392837e-05
2,745 Hardware Acceleration in Commercial Databases: A Case Study of Spatial Operations 2004 VLDB 8.0477409e-05
2,890 High-Throughput Transaction Executions on Graphics Processors 2011 VLDB 7.8875185e-05
8,644 Accelerating Pathology Image Data Cross-Comparison on CPU-GPU Hybrid Systems 2012 VLDB 5.2822865e-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,608 A Case for Graphics-driven Query Processing 2023 VLDB
3 5,412 Towards a Hybrid Design for Fast Query Processing in DB2 with BLU Acceleration Using Graphical Processing Units: A Technology Demonstration 2016 SIGMOD
4 6,393 GPU-accelerated data management under the test of time 2020 CIDR
5 1,228 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,206 Why it is time for a HyPE: A Hybrid Query Processing Engine for Efficient GPU Coprocessing in DBMS 2013 VLDB
8 4,164 GPU Database Systems Characterization and Optimization 2024 VLDB
9 7,200 GPUQP: Query Co-Processing Using Graphics Processors 2007 SIGMOD
10 2,468 Concurrent Analytical Query Processing with GPUs 2014 VLDB