A Flash-Based Decomposition Storage Model

摘要

The traditional HDD-based columnar storage is an important technology to improve the performance of query-intensive database. However, some features of HDD weaken the advantages of columnar storage. In this paper, we study the advantages of SSD over HDD on columnar storage and propose a new columnar storage model based on SSD, named Flash Based Decomposition Storage Model(FBDSM). FBDSM stores each attribute of a table in a column and each column has a log table to store its recently updated data, which will be merged with original data periodically. In this way, FBDSM not only provides efficient update, but also almost has no negative impact on query performance.