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.00014085862
Overall Rank: 771 | 94.82%
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 7 of 57 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
10,905	ZipFlow: a Compiler-based Framework to Unleash Compressed Data Movement for Modern GPUs	2026	VLDB	4.9793485e-05
10,906	RayBooster: A Ray Tracing Engine to Accelerate SedonaDB	2026	VLDB	4.9793485e-05
10,923	TQP++: Bridging ML Compilers and Analytical Query Processing on GPUs	2026	VLDB	4.9793485e-05
10,937	RayDB: Building Databases with Ray Tracing Cores	2026	VLDB	4.9793485e-05
11,288	Concurrency Control as a Service	2025	VLDB	4.9793485e-05
11,560	X-TED: Massive Parallelization of Tree Edit Distance	2024	VLDB	4.9793485e-05
11,650	High-Performance Spatial Data Analytics: Systematic R&D for Scale-Out and Scale-Up Solutions from the Past to Now	2024	VLDB	4.9793485e-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
61	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.000392237
304	GPUTeraSort: High Performance Graphics Co-processor Sorting for Large Database Management	2006	SIGMOD	0.00021604795
331	Column-Stores vs. Row-Stores: How Different Are They Really?	2008	SIGMOD	0.0002077683
361	Design and Evaluation of Main Memory Hash Join Algorithms for Multi-core CPUs	2011	SIGMOD	0.00020006406
616	Relational Joins on Graphics Processors	2008	SIGMOD	0.00015561564
661	Fast Sort on CPUs and GPUs: A Case for Bandwidth Oblivious SIMD Sort	2010	SIGMOD	0.00015003815
1,034	A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses	2009	VLDB	0.00012394538
1,454	Fast Computation of Database Operations using Graphics Processors	2004	SIGMOD	0.00010601431
1,671	Efficient Parallel Lists Intersection and Index Compression Algorithms using Graphics Processing Units	2011	VLDB	9.9310625e-05
2,185	Database Compression on Graphics Processors	2010	VLDB	8.8948351e-05
2,476	One Size Fits All? – Part 2: Benchmarking Results	2007	CIDR	8.409729e-05
2,749	Hardware Acceleration in Commercial Databases: A Case Study of Spatial Operations	2004	VLDB	8.0607411e-05
2,889	High-Throughput Transaction Executions on Graphics Processors	2011	VLDB	7.9070124e-05
8,619	Accelerating Pathology Image Data Cross-Comparison on CPU-GPU Hybrid Systems	2012	VLDB	5.3016441e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,773	Hardware-conscious Query Processing in GPU-accelerated Analytical Engines	2019	CIDR
2	8,595	A Case for Graphics-driven Query Processing	2023	VLDB
3	5,394	Towards a Hybrid Design for Fast Query Processing in DB2 with BLU Acceleration Using Graphical Processing Units: A Technology Demonstration	2016	SIGMOD
4	6,516	GPU-accelerated data management under the test of time	2020	CIDR
5	1,268	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,200	Why it is time for a HyPE: A Hybrid Query Processing Engine for Efficient GPU Coprocessing in DBMS	2013	VLDB
8	4,480	GPU Database Systems Characterization and Optimization	2024	VLDB
9	7,188	GPUQP: Query Co-Processing Using Graphics Processors	2007	SIGMOD
10	2,466	Concurrent Analytical Query Processing with GPUs	2014	VLDB