计算机应用与软件2013，Vol.30Issue(8)：81-86,6.DOI:10.3969/j.issn.1000-386x.2013.08.022
闪存数据库顺序和随机操作性能深度测试和分析
DEEP TEST AND ANALYSIS ON SEQUENTIAL AND RANDOM OPERATION PERFORMANCE OF FLASH-BASED DATABASES
摘要
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 modem 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.关键词
闪存数据库/测试/性能/随机访问/查询优化Key words
Flash-based database / Testing / Performance / Random access / Query optimisation分类
信息技术与安全科学引用本文复制引用
陈学轩,吕雁飞,崔斌..闪存数据库顺序和随机操作性能深度测试和分析[J].计算机应用与软件,2013,30(8):81-86,6.基金项目
核高基级重大专项课题(2010ZX01042-001-001-04) . （2010ZX01042-001-001-04）
