.png){kind=icon}
返回
OurRocks: Offloading Disk Scan Directly to GPU in Write-Optimized Database System
.png){kind=icon}
OA
AI
DOI：10.1109/TC.2020.3027671.png)
.png){kind=icon}
.png){kind=icon}
分享.png){kind=icon}
收藏
摘要
En 中文
The log structured merge (LSM) tree has been widely adopted by database systems owing to its superior write performance. However, LSM-tree based databases face vulnerabilities when processing analytical queries due to the read amplification caused by its architecture and the limited use of storage devices with high bandwidth. To flexibly handle transactional and analytical workloads, we proposed and implemented OurRocks taking full advantage of NVMe SSD and GPU devices, which improves scan performance. Although the NVMe SSD serves multi GB/s I/O rates, it is necessary to solve the data transfer overhead which limits the benefits of the GPU processing. The primary idea is to offload the scan operation to the GPU with filtering predicate pushdown and resolve the bottleneck from the data transfer between devices with direct memory access (DMA). OurRocks benefits from all the features of write-optimized database systems, in addition to accelerating the analytic queries using the aforementioned idea. Experimental results indicate that OurRocks effectively leverages resources of the NVMe SSD and GPU and significantly improves the execution of queries in the YCSB and TPC-H benchmarks, compared to the conventional write-optimized database. Our research demonstrates that the proposed approach can speed up the handling of the data-intensive workloads.
Keyword:
Graphics processing units
Nonvolatile memory
Bandwidth
Central Processing Unit
Engines
Database systems
Database architectures
high performance computing
LSM-tree
query processing
AI总结
对已上传原文的论文进行重点信息的提取，主要内容包括：简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。
期刊
IF:
3.8
论文数:
5.4K
被引数:
9.8K
机构
引用论文
Facile preparation of in situ coated Ti3C2Tx/Ni0.5Zn0.5Fe2O4composites and their electromagnetic performance原位涂层Ti3C2Tx/Ni0.5Zn0.5Fe2O4 复合材料及其电磁性能.png)
RSC AdvancesOAAI
RSC AdvancesIF0
OAAI分享收藏Thermal hydraulic design and decay heat removal of a solid target for a spallation neutron sourceOAAI
OAAI分享收藏Effects of unilateral and bilateral pyramidotomy on a conditioned rapid precision grip in monkeys (Macaca fascicularis)单侧和双侧锥体切开术对猴子 (Macaca fascicularis) 条件性快速精确抓握的影响
PREAI
分享收藏
查看更多内容