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

Weighted optimization placement for database objects in hybrid storage systems

作　　者：白振中[1] 牛保宁[1] 

机构地区：[1]太原理工大学计算机科学与技术学院,山西太原030024

出　　处：《计算机工程与设计》2015年第10期2706-2711,共6页Computer Engineering and Design

基　　金：国家科技支撑项目课题基金项目(2012BAH04F02);人社部留学人员科技活动基金项目(2011-508);山西省自然科学基金项目(2010011025-2);软件工程国家重点实验室第八批开放研究基金项目(SKLSE2012-09-30)

摘　　要：在闪存硬盘和磁性硬盘组成的混合存储系统中,针对现有方法仅考虑存储介质的差异,没有考虑顺序读、顺序写、随机读和随机写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.

关 键 词：闪存硬盘 随机读 随机写 顺序读 顺序写 表 索引 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]