| Presentation | 2021-01-26 Acceleration of Database Query Processing Using FPGA Hirohiko Ozaku, Masato Yoshimi, Celimuge Wu, Tsutomu Yoshinaga, |
|---|---|
| PDF Download Page |  PDF download Page Link |
| Abstract(in Japanese) | (See Japanese page) |
| Abstract(in English) | A bottleneck of Big data analysis is a time to transfer large amount of data to the main memory from the storage. The data transfer time occupies quite a percentage of the turnaround time due to an unbalanced rate between data transfer and computation. In order to accelerate computational time by reducing data, a mechanism installing hardware such as FPGA is expected to reduce the volume of data prior to loading to the main memory. Our research group utilizes in-datapath computing, which is a on-the-fly computation for stream data from the storage and network input to the main memory of a host machine. This paper reports an FPGA-based acceleration of aggregation query processing using the in-datapath Computing. We developed a dedicated query processing hardware on an FPGA. In addition, we confirmed that the computational speed of a On-Line Analytical Processing benchmark Query 3 is accelerated about 10 times compared to Impala, which is a distributed query engine. |
| Keyword(in Japanese) | (See Japanese page) |
| Keyword(in English) | Bigdata analysis / FPGA / query processing / aggregation query |
| Paper # | VLD2020-55,CPSY2020-38,RECONF2020-74 |
| Date of Issue | 2021-01-18 (VLD, CPSY, RECONF) |
| Conference Information | |
| Committee | CPSY / RECONF / VLD / IPSJ-ARC / IPSJ-SLDM |
|---|---|
| Conference Date | 2021/1/25(2days) |
| Place (in Japanese) | (See Japanese page) |
| Place (in English) | Online |
| Topics (in Japanese) | (See Japanese page) |
| Topics (in English) | FPGA Applications, etc. |
| Chair | Hidetsugu Irie(Univ. of Tokyo) / Yuichiro Shibata(Nagasaki Univ.) / Daisuke Fukuda(Fujitsu Labs.) / Hiroshi Inoue(Kyushu Univ.) / Yuichi Nakamura(NEC) |
| Vice Chair | Michihiro Koibuchi(NII) / Kota Nakajima(Fujitsu Lab.) / Kentaro Sano(RIKEN) / Yoshiki Yamaguchi(Tsukuba Univ.) / Kazutoshi Kobayashi(Kyoto Inst. of Tech.) |
| Secretary | Michihiro Koibuchi(Hokkaido Univ.) / Kota Nakajima(Nagoya Inst. of Tech.) / Kentaro Sano(e-trees.Japan) / Yoshiki Yamaguchi(NEC) / Kazutoshi Kobayashi(Hitachi) / (Osaka Univ.) / (Fujitsu lab.) |
| Assistant | Shugo Ogawa(Hitachi) / Eiji Arima(Univ. of Tokyo) / Hiroki Nakahara(Tokyo Inst. of Tech.) / Yukitaka Takemura(INTEL) / Takuma Nishimoto(Hitachi) |
| Paper Information | |
| Registration To | Technical Committee on Computer Systems / Technical Committee on Reconfigurable Systems / Technical Committee on VLSI Design Technologies / Special Interest Group on System Architecture / Special Interest Group on System and LSI Design Methodology |
|---|---|
| Language | JPN |
| Title (in Japanese) | (See Japanese page) |
| Sub Title (in Japanese) | (See Japanese page) |
| Title (in English) | Acceleration of Database Query Processing Using FPGA |
| Sub Title (in English) | |
| Keyword(1) | Bigdata analysis |
| Keyword(2) | FPGA |
| Keyword(3) | query processing |
| Keyword(4) | aggregation query |
| 1st Author's Name | Hirohiko Ozaku |
| 1st Author's Affiliation | The University of Electro-Communications(UEC) |
| 2nd Author's Name | Masato Yoshimi |
| 2nd Author's Affiliation | TIS Inc.(TIS) |
| 3rd Author's Name | Celimuge Wu |
| 3rd Author's Affiliation | The University of Electro-Communications(UEC) |
| 4th Author's Name | Tsutomu Yoshinaga |
| 4th Author's Affiliation | The University of Electro-Communications(UEC) |
| Date | 2021-01-26 |
| Paper # | VLD2020-55,CPSY2020-38,RECONF2020-74 |
| Volume (vol) | vol.120 |
| Number (no) | VLD-337,CPSY-338,RECONF-339 |
| Page | pp.pp.90-95(VLD), pp.90-95(CPSY), pp.90-95(RECONF), |
| #Pages | 6 |
| Date of Issue | 2021-01-18 (VLD, CPSY, RECONF) |