Abstract:
The high performance of Solid State Disk(SSD) has failed to be improved in the existing database systems. Aiming at this problem, a new connection method is proposed in this paper. The algorithm is optimized Flash database connection on the column files. Using the small size of column storage and the advantages of SSD high-speed random read, the algorithm overcomes the mismatch with the flash memory. Experimental results show that compared with the original algorithm, the query time of the new algorithm is less under the conditions of different query rate and different memory.
Key words:
flash memory,
database,
column storage,
Solid State Disk(SSD)
摘要:
固态硬盘的高性能在现有数据库系统中未能获得提升,针对该问题,提出一种连接算法,基于列存储模式,对闪存数据库连接查询进行优化。算法充分利用列存储的存储粒度小和固态硬盘高速随机读的优点,有效克服与闪存的不匹配问题。实验结果表明,与原算法相比,该算法在不同选择率和不同内存条件下的查询时间较少。
关键词:
闪存,
数据库,
列存储,
固态硬盘
CLC Number:
JIANG Jiu-Lei, WANG Jiang-Jing. Query Optimization Algorithm for Flash Memory Database in Column Storage Mode[J]. Computer Engineering, 2010, 36(24): 74-75.
姜久雷, 王江静. 列存储模式下闪存数据库的查询优化算法[J]. 计算机工程, 2010, 36(24): 74-75.