一种基于闪存的数据库复合存储模型

An flash-based hybrid storage model for database

针对闪存硬盘的快速发展趋势以及存取特性,提出一种数据库复合存储模型.在该模型中,数据库同时包括闪存硬盘和磁性硬盘2种设备,数据根据访问特征被存储到不同的设备中.模型使用地址映射表来转换对闪存访问,并使用滑动窗口技术,通过最近一段时间内访问的统计信息和设备本身的物理特性,自适应地动态调整页面的分布,使数据库获得更高的性能.通过基于在线事务处理应用的性能仿真测试,结果表明,该复合模型可以显著提高I/O性能,并对工作集的变化有良好的适应性.

A novel hybrid storage model was proposed for the relational databases,according to the prevalence and the IO characteristic of the flash disks.In this model,the storage media of the database consists of both magnetic and flash disk.The data in the database are deployed on the suitable media according to their access patterns.The model uses a mapping table to translate the logical accesses to the correspondent flash address.To improve the total system performance,the page deployment of the system is tuned adaptively according to the physical parameter of the devices and the recent access patterns,which are collected via the sliding windows.The experiments on the simulated OLTP workloads demonstrate that the model significantly improves the IO performance.The model is also proved to be extremely compliant with the various workloads.