【作者】 吕雁飞； 陈学轩； 崔斌；

【Author】 Lü Yanfei,Chen Xuexuan,and Cui Bin (School of Electronics Engineering and Computer Science,Peking University,Beijing 100871)

【机构】 北京大学信息科学技术学院；

【摘要】 随着闪存容量的不断提升,技术的不断成熟,闪存数据库成为数据库的热点研究领域之一.了解闪存的IO特性,以及现有数据库产品在闪存上的性能瓶颈所在是闪存数据库设计改进的首要一步.目前广泛使用的是由闪存制造的固态硬盘,而固态硬盘与闪存芯片的特性又有很大不同.首先测试了固态硬盘的基本IO特性,接着使用TPC-B标准对部署在固态硬盘上的通用数据库产品进行了评估.分析了缓冲区大小、CPU处理能力、用户并发数等对基于闪存数据库性能的影响.最后,结合测试结果,从数据组织、数据库资源利用等多方面给出优化建议.更多还原

【Abstract】 With the development of flash technology and increment of density,flash-based database has become one of the hottest topics in database area.In order to improve the performance of flash-based database,it is the first step to understand the 10 characteristics of flash memory.Solid state disk(SSD) is the most wildly adopted flash-made product;however,the feature of SSD is different from the raw flash chip.In this case,the basic 10 features of SSD are tested,and then a flash-based DBMS with the TPC-B benchmark is evaluated.It is analyzed how buffer size,CPU capability and number of users affect the performance of database.Finally,some advices on optimization of flash-based DBMS are proposed according to our testing results.更多还原