192 0

In-storage processing of database scans and joins

Title
In-storage processing of database scans and joins
Author
오현옥
Keywords
SSD; Database; Performance; Energy; Scan; Join
Issue Date
2016-01
Publisher
ELSEVIER SCIENCE INC
Citation
INFORMATION SCIENCES, v. 327, Page. 183-200
Abstract
Flash memory-based SSD is becoming popular because of its outstanding performance compared to conventional magnetic disk drives. Today, SSDs are essentially a block device attached to a legacy host interface. As a result, the system I/O bus remains a bottleneck, and the abundant flash memory bandwidth and the computing capabilities of SSD are largely untapped. In this paper, we propose to accelerate key database operations, scan and join, for large-scale data analysis by moving data-intensive processing from the host CPU to inside flash SSDs ("in-storage processing"), close to the data source itself. To realize the idea of in-storage processing in a cost-effective manner, we deploy special-purpose compute modules using the System-on-Chip technology. While data from flash memory are transferred, a target database operation is applied to the data stream on the fly without any delay. This reduces the amount of data to transfer to the host drastically, and in turn, ensures all components along the data path in an SSD are utilized in a balanced way. Our experimental results show that in-storage processing outperforms conventional processing with a host CPU by over up to 7 x, 5 x and 47 x for scan, join, and their combination, respectively. It also turns out that in-storage processing can be realized at only I% of the total SSD cost, while offering sizable energy savings of up to 45 x compared to host processing. (C) 2015 Elsevier Inc. All rights reserved.
URI
http://www.sciencedirect.com/science/article/pii/S0020025515006003?via%3Dihubhttp://hdl.handle.net/20.500.11754/30574
ISSN
0020-0255; 1872-6291
DOI
10.1016/j.ins.2015.07.056
Appears in Collections:
COLLEGE OF ENGINEERING[S](공과대학) > INFORMATION SYSTEMS(정보시스템학과) > Articles
Files in This Item:
There are no files associated with this item.
Export
RIS (EndNote)
XLS (Excel)
XML


qrcode

Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.

BROWSE