DEEP TEST AND ANALYSIS ON SEQUENTIAL AND RANDOM OPERATION PERFORMANCE OF FLASH-BASED DATABASES

Chen Xuexuan,Lü Yanfei,Cui Bin
DOI: https://doi.org/10.3969/j.issn.1000-386x.2013.08.022
2013-01-01
Abstract:Flash memory has begun to be more widely used by both the individuals and the enterprises as an available novel storage medium for the alternative of magnetic disks.Although the solid state disks(SSDs) significantly outperform the magnetic disks in I / O speed,the performance of flash-based database systems has not been speeded up correspondingly yet due to lack of consideration of the features of flash memory.Detailed testing and studying on the difference between sequential and random operations performance of SSDs in this paper further proves that modern SSDs has preferably faster random access speed.We then choose the representative database benchmarks and adjust the query plans of various queries to observe the performances of database system in different query plans.We find that some of the query plans can better capture the random access characteristics of SSDs,and one of them runs even 6 times faster than the default query plans.Finally,we summarise the shortcoming of the encounter of traditional database system against the medium of SSD and put forward some suggestions in regard to optimisation.
What problem does this paper attempt to address?