首页> 外文期刊>Computers, IEEE Transactions on >Online Energy Estimation of Relational Operations in Database Systems
【24h】

Online Energy Estimation of Relational Operations in Database Systems

机译:数据库系统中关系操作的在线能量估计

获取原文
获取原文并翻译 | 示例

摘要

Data centers are well known to consume a large amount of energy. As databases are one of the major applications in a data center, building energy-aware database systems has become an active research topic recently. The quantification of the energy cost of database systems is an important task in design. In this paper, we report our recent efforts on this issue, with a focus on the energy cost estimation of query plans during query optimization. We start from building a series of physical models for energy estimation of individual relational operators based on their resource consumption patterns. As the execution of a query plan is a combination of multiple relational operators, we use the physical models as a basis for a comprehensive energy model for the entire query. To address the challenge of maintaining accuracy under system and workload dynamics, we develop an online scheme that dynamically adjusts model parameters based on statistical signal modeling. Our models are implemented in a real database management system and evaluated on a physical test bed. The results show that our solution achieves a high accuracy (worst-case error 13.7 percent) despite noises. Our models also help identify query plans with significantly higher energy efficiency.
机译:众所周知,数据中心消耗大量能量。由于数据库是数据中心的主要应用之一,因此,构建节能型数据库系统已成为最近的活跃研究主题。数据库系统能源成本的量化是设计中的重要任务。在本文中,我们报告了我们在此问题上的最新工作,重点是查询优化期间查询计划的能源成本估算。我们从构建一系列物理模型开始,以基于各个关系运算符的资源消耗模式对其进行能量估计。由于查询计划的执行是多个关系运算符的组合,因此我们将物理模型用作整个查询的综合能源模型的基础。为了解决在系统和工作负荷动态下保持准确性的挑战,我们开发了一种在线方案,该方案可以根据统计信号建模来动态调整模型参数。我们的模型在真实的数据库管理系统中实现,并在物理测试台上进行评估。结果表明,尽管有噪声,我们的解决方案仍可以实现较高的精度(最坏情况下的错误率为13.7%)。我们的模型还有助于确定具有明显更高能源效率的查询计划。

著录项

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号