计算机应用 ›› 2010, Vol. 30 ›› Issue (11): 2962-2964.

• 数据库与数据挖掘 • 上一篇    下一篇

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

王跃清1,黄烨2,王翰虎2,陈梅3   

  1. 1. 贵州省贵阳市贵州大学花溪北校区
    2.
    3. 贵州省贵阳市贵州大学计算机学院
  • 收稿日期:2010-04-27 修回日期:2010-06-25 发布日期:2010-11-05 出版日期:2010-11-01
  • 通讯作者: 王跃清
  • 基金资助:
    贵州大学2010年研究生创新基金

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

  • Received:2010-04-27 Revised:2010-06-25 Online:2010-11-05 Published:2010-11-01

摘要: 为了有效地利用固态盘读速快以及磁盘低存储成本的特点,在磁盘和固态盘共存的混合存储结构模型下,设计并实现了一种基于页迁移思想的存储分层算法(SZA)。不同于NUMA的迁移代价计算方法,该算法按照迁移代价选择相应的存储介质,并且对不同工作负载的数据进行迁移。实验结果显示,算法有效地提升了数据库系统的I/O性能,同时大幅度地减少了对闪存的擦写次数。

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

Abstract: 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.

Key words: database storage, flash, SSD, hybrid storage architecture, page migration