混合结构数据库中基于页迁移的存储分层算法  

Storage zoning algorithm based on page migration for database with hybrid architecture

作　　者：王跃清[1] 黄烨[1] 王翰虎[1,2] 陈梅[1] 

机构地区：[1]贵州大学计算机科学与信息学院,贵阳550025 [2]贵州星辰科技开发有限公司,贵阳550001

出　　处：《计算机应用》2010年第11期2962-2964,共3页journal of Computer Applications

基　　金：贵州省科技计划工业攻关基金资助项目(黔科合GY字[2008]3035);贵阳市2010年科技攻关项目([2010]筑科工合同字第28号);贵州大学2010年研究生创新基金资助项目(校研理工[2010033])

摘　　要：为了有效地利用固态盘读速快以及磁盘低存储成本的特点,在磁盘和固态盘共存的混合存储结构模型下,设计并实现了一种基于页迁移思想的存储分层算法(SZA)。不同于NUMA的迁移代价计算方法,该算法按照迁移代价选择相应的存储介质,并且对不同工作负载的数据进行迁移。实验结果显示,算法有效地提升了数据库系统的I/O性能,同时大幅度地减少了对闪存的擦写次数。To effectively take advantage of high read speed of Solid-State Disk （SSD）＇s and low cost of disk storage, under a mixed structure which is the coexistence of disk and SSD, a storage zoning algorithm based on page migration named SZA was proposed. A different calculating method of migration cost from NUMA was presented. The SZA algorithm was explained to choose corresponding storage medium based on the cost of migration. Migrating activity was processed on different workload of data. The simulation results show that the algorithm improves I/O performance effectively and the erasing times of flash have been reduced significantly.

关 键 词：数据库存储 固态盘 混合存储结构 页迁移 

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