HeuristicDB: a hybrid storage database system using a non-volatile memory block device
HeuristicDB: a hybrid storage database system using a non-volatile memory block device
复制标题
HeuristicDB：使用非易失性内存块设备的混合存储数据库系统
DOI：
--
复制
发表时间：
2021
期刊：
影响因子：
--
通讯作者：
D. Lilja
中科院分区：
文献类型：
--
作者：
Jinfeng Yang;Bingzhe Li;D. Lilja
混合存储系统广泛应用于大数据领域，以平衡系统性能和成本。然而，由于对数据库块请求的特征理解不足，过去在该领域的研究无法充分利用新兴存储设备带来的性能提升。本研究提出了一种称为HeuristicDB的混合存储数据库系统，它使用新兴的非易失性内存（NVM）块设备作为数据库缓冲池的扩展。为了考虑NVM块设备的独特性能行为和数据库请求的块级特征，提出了一套启发式规则，将数据库（块）请求与适当的服务质量相关联，以实现缓存优先级。利用在线分析处理（OLAP）和在线事务处理（OLTP）基准测试，在MySQL上进行了基于跟踪的测试和系统实现，以评估所提出设计的有效性。实验结果表明，与现有系统相比，HeuristicDB提供了高达75%的性能提升，并且在存储和NVM块设备之间迁移的数据减少了18倍。
Hybrid storage systems are widely used in big data fields to balance system performance and cost. However, due to a poor understanding of the characteristics of database block requests, past studies in this area cannot fully utilize the performance gain from emerging storage devices. This study presents a hybrid storage database system, called HeuristicDB, which uses an emerging non-volatile memory (NVM) block device as an extension of the database buffer pool. To consider the unique performance behaviors of NVM block devices and the block-level characteristics of database requests, a set of heuristic rules that associate database (block) requests with the appropriate quality of service for the purpose of caching priority are proposed. Using online analytical processing (OLAP) and online transactional processing (OLTP) benchmarks, both trace-based examination and system implementation on MySQL are carried out to evaluate the effectiveness of the proposed design. The experimental results indicate that HeuristicDB provides up to 75% higher performance and migrates 18X fewer data between storage and the NVM block device than existing systems.
DOI：
10.1145/3132747.3132770
发表时间：
2017-10
期刊：
Proceedings of the 26th Symposium on Operating Systems Principles
影响因子：
--
作者：
Youngjin Kwon;Henrique Fingler;T. Hunt;Simon Peter;Emmett Witchel;T. Anderson
通讯作者：
Youngjin Kwon;Henrique Fingler;T. Hunt;Simon Peter;Emmett Witchel;T. Anderson