| Energy-Aware Query Processing on a Parallel Database Cluster Node | |
| Amine Roukh; Ladjel Bellatreche; Nikos Tziritas; Carlos Ordonez | |
| 2016 | |
| 会议名称 | ICA3PP 2016 |
| 会议地点 | Spain |
| 英文摘要 | In the last few years, we have been seeing a significant increase in research about the energy efficiency of hardware and software components in both centralized and parallel platforms. In data centers, DBMSs are one of the major energy consumers, in which, a large amount of data is queried by complex queries running daily. Having green nodes is a pre-condition to design an energy-aware parallel database cluster. Generally, the most existing DBMSs focus on high-performance during query optimization phase, while usually ignoring the energy consumption of the queries. In this paper, we propose a methodology, supported by a tool called EnerQuery, that makes nodes of parallel database clusters saving energy when optimizing queries. To show its effectiveness, we implement our proposal on the top of PostgreSQL DBMS query optimizer. A mathematical cost model based on a machine learning technique is defined and used to estimate the energy consumption of SQL queries. |
| 收录类别 | EI |
| 语种 | 英语 |
| 内容类型 | 会议论文 |
| 源URL | [http://ir.siat.ac.cn:8080/handle/172644/10354]  |
| 专题 | 深圳先进技术研究院_数字所 |
| 作者单位 | 2016 |
| 推荐引用方式 GB/T 7714 | Amine Roukh,Ladjel Bellatreche,Nikos Tziritas,et al. Energy-Aware Query Processing on a Parallel Database Cluster Node[C]. 见:ICA3PP 2016. Spain. |
| 个性服务 |
| 查看访问统计 |
| 相关权益政策 |
| 暂无数据 |
| 收藏/分享 |
除非特别说明，本系统中所有内容都受版权保护，并保留所有权利。
修改评论