Approximating an Energy-Proportional DBMS by a Dynamic Cluster of Nodes
Approximating an Energy-Proportional DBMS by a Dynamic Cluster of Nodes
复制标题
DOI：
10.1007/978-3-319-05810-8_20
复制
发表时间：
2014-04
期刊：
影响因子：
--
通讯作者：
D. Schall;T. Härder
中科院分区：
文献类型：
--
作者：
D. Schall;T. Härder
如果我们只关注DBMS可以稳定运行在峰值性能范围内的特定应用程序，则单服务器DBMS的最高能效配置是性能最高的配置。然而，典型的DBMS活动水平--或者说他们的平均系统利用率--要低得多，而且他们的能源消耗远远不是成比例的。WattDB由商用硬件构建，是一种分布式DBMS，在计算节点集群上运行，通过动态调整集群大小来实现能量比例。在这项工作中，我们将我们之前关于能量比例存储层的发现和查询处理结合到一个单一的事务DBMS中。我们通过以不同的百分比强度运行OLTP和OLAP查询的一系列基准测试来验证我们的愿景。并行度。这些实验表明，WattDB可以动态调整以适应当前的工作负载，并重新配置自身以满足性能需求，同时将其能耗保持在最低水平。
The most energy-efficient configuration of a single-server DBMS is the highest performing one, if we exclusively focus on specific applications where the DBMS can steadily run in the peak-performance range. However, typical DBMS activity levels—or their average system utilization—are much lower and their energy use is far from beingenergy proportional. Built of commodity hardware,WattDB—a distributed DBMS—runs on a cluster of computing nodes where energy proportionality is approached by dynamically adapting the cluster size. In this work, we combine our previous findings on energy-proportional storage layers and query processing into a single, transactional DBMS. We verify our vision by a series of benchmarks running OLTP and OLAP queries with varying %intensity. degrees of parallelism. These experiments illustrate that WattDB dynamically adjusts to the workload present and reconfigures itself to satisfy performance demands while keeping its energy consumption at a minimum.