混合存储系统中数据库对象的加权优化放置

Weighted optimization placement for database objects in hybrid storage systems

在闪存硬盘和磁性硬盘组成的混合存储系统中,针对现有方法仅考虑存储介质的差异,没有考虑顺序读、顺序写、随机读和随机写4种访问操作对数据库系统性能贡献不同的问题,提出一种加权放置数据库对象的方法。区分不同的操作在不同存储介质上的差异,根据负载的不同赋予4种操作在性能提升上不同的权重,充分利用存储设备的性能优势和最大化性能提升为目标选择数据库对象的放置。以TPC-C作为负载的实验结果表明,与现有的方法相比,该方法能提升数据库系统的性能并延长闪存硬盘的寿命。

In the hybrid storage systems with a combination of both flash and magnetic disks,aiming at the problems that the existing method only considers differences of storage media which fails to consider different contributions made by four access operations including sequential read,sequential write,random read and random write for database systems performance,a weighted placement method for database objects was presented.The distinction was made between different operations on different storage media,according to the different loads,four operations different weights were given to the performance increase and the database object placement was selected with a goal of making full use of performance advantages of storage devices and maximized performance increase.TPC-C was used as a load in experiments.Experimental results show that compared with the existing method,the method can enhance the performance of database system and prolong the life time of flash disks.