Performance Characteristics of Large Analytical Query Processing on Relational Database with SSDs

  • Keisuke Suzuki
    Kitsuregawa Lab., Center for Information Fusion, Institute of Industrial Science (IIS)
  • Yuto Hayamizu
    Kitsuregawa Lab., Center for Information Fusion, Institute of Industrial Science (IIS)
  • Daisaku Yokoyama
    Kitsuregawa Lab., Center for Information Fusion, Institute of Industrial Science (IIS)
  • Miyuki Nakano
    Kitsuregawa Lab., Center for Information Fusion, Institute of Industrial Science (IIS)
  • Masaru Kitsuregawa
    Kitsuregawa Lab., Center for Information Fusion, Institute of Industrial Science (IIS) |

Bibliographic Information

Other Title
  • SSDを利用したリレーショナルデータベースにおける大規模意思決定支援クエリ処理性能の特性

Search this article

Description

The SSDs are expected new storage devices whose transfer rate are thousands faster than that of HDDs. By employing SSDs on behalf of HDDs, performance of data intensive applications is likely to be improved drastically since I/O cost of HDDs is dominant in execution time of data intensive applications. Then, different behavior of data intensive application may be observed in case of SSDs, since SSD's I/O cost is relatively small in total execution time. In this report, we analyze the difference in behaviors of hash join operation on a relational database with both HDD and SSD environment, and clarify that it is necessary to consider the cost model by taking into account characteristics of SSDs

Journal

  • IPSJ SIG Notes

    IPSJ SIG Notes 2013 (21), 1-6, 2013-07-15

    Information Processing Society of Japan (IPSJ)

Keywords

Details 詳細情報について

  • CRID
    1570854177905424640
  • NII Article ID
    110009585829
  • NII Book ID
    AN10112482
  • Text Lang
    ja
  • Data Source
    • CiNii Articles

Report a problem

Back to top