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

1. Yuan Yuan (Ohio State University)
2. Rubao Lee (Ohio State University)
3. Xiaodong Zhang (Ohio State University)

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 3 of 53 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
10,985	Scaling GPU-Accelerated Databases beyond GPU Memory Size	2025	VLDB	5.093636e-05
11,224	X-TED: Massive Parallelization of Tree Edit Distance	2024	VLDB	5.093636e-05
11,332	High-Performance Spatial Data Analytics: Systematic R&D for Scale-Out and Scale-Up Solutions from the Past to Now	2024	VLDB	5.093636e-05

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

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