arXivDaily arXiv每日学术速递 周一至周五更新
arXiv周末暂无论文更新,休息一下吧,周末愉快~~
arXiv 1201.0226cs.DB
收藏

面向DBMS的经济高效的存储配置

Towards Cost-Effective Storage Provisioning for DBMSs

Ning Zhang, Junichi Tatemura, Jignesh M. Patel, Hakan Hacıgümüş

摘要:

当考虑如何在具有复杂I/O子系统的机器上提供资源时,数据中心运营商面临着一系列令人困惑的选择。现代I/O子系统通常具有快速,高性能但昂贵的SSD与便宜但相对较慢(用于随机访问)的传统硬盘驱动器的丰富组合。数据中心运营商需要确定如何为特定工作负载提供I/O资源,以便遵守现有的服务水平协议(SLA),同时最小化运行工作负载的总运营成本(TOC),其中TOC包括摊销的硬件成本和运行时间能量成本。本文的重点是介绍这个新的问题,TOC为基础的存储分配,铸造的框架,是兼容传统的DBMS查询优化和查询处理体系结构。我们还提出了一个基于经验的解决方案,这个问题,称为DOT。我们已经在PostgreSQL中实现了DOT,并且使用TPC-H和TPC-C的实验表明DOT在各种设置中显著降低了TOC。

英文摘要:

Data center operators face a bewildering set of choices when considering how to provision resources on machines with complex I/O subsystems. Modern I/O subsystems often have a rich mix of fast, high performing, but expensive SSDs sitting alongside with cheaper but relatively slower (for random accesses) traditional hard disk drives. The data center operators need to determine how to provision the I/O resources for specific workloads so as to abide by existing Service Level Agreements (SLAs), while minimizing the total operating cost (TOC) of running the workload, where the TOC includes the amortized hardware costs and the run time energy costs. The focus of this paper is on introducing this new problem of TOC-based storage allocation, cast in a framework that is compatible with traditional DBMS query optimization and query processing architecture. We also present a heuristic-based solution to this problem, called DOT. We have implemented DOT in PostgreSQL, and experiments using TPC-H and TPC-C demonstrate significant TOC reduction by DOT in various settings.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑