{'fraction_non_alphanumeric': 0.01373283395755306, 'fraction_numerical': 0.0, 'mean_word_length': 5.030075187969925, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Performance Characteristics of Large Analytical Query Processing on Relational Database with SSDs

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