走向生态友好的数据库管理系统
Towards Eco-friendly Database Management Systems
摘要：
数据库管理系统（DBMS）在很大程度上忽略了管理查询处理期间消耗的能量的任务。经济和环境因素都要求DBMS密切关注能源消耗。在本文中，我们处理这个问题，考虑能源消耗作为一个一流的性能目标，在DBMS中的查询处理。我们提出了两个具体的技术，可以使用的DBMS直接管理的能源消耗。这两种技术都以能耗换取性能。第一种技术称为PVC，利用现代处理器在较低处理器电压和频率下执行的能力。第二种技术称为QED，使用查询聚合来利用工作负载中查询的常见组件。在一个商业数据库管理系统和MySQL上进行的实验表明，PVC可以使处理器能耗降低49%，而响应时间仅增加3%.在MySQL上，PVC可以减少20%的能耗，而响应时间损失仅为6%。对于简单的选择查询没有谓词重叠，我们表明，量子电动力学可以用来优雅地交易响应时间的能量，减少了54%的平均响应时间增加43%的能源消耗。在本文中，我们还强调了一些研究问题，在新兴领域的节能数据处理。
英文摘要：
Database management systems (DBMSs) have largely ignored the task of managing the energy consumed during query processing. Both economical and environmental factors now require that DBMSs pay close attention to energy consumption. In this paper we approach this issue by considering energy consumption as a first-class performance goal for query processing in a DBMS. We present two concrete techniques that can be used by a DBMS to directly manage the energy consumption. Both techniques trade energy consumption for performance. The first technique, called PVC, leverages the ability of modern processors to execute at lower processor voltage and frequency. The second technique, called QED, uses query aggregation to leverage common components of queries in a workload. Using experiments run on a commercial DBMS and MySQL, we show that PVC can reduce the processor energy consumption by 49% of the original consumption while increasing the response time by only 3%. On MySQL, PVC can reduce energy consumption by 20% with a response time penalty of only 6%. For simple selection queries with no predicate overlap, we show that QED can be used to gracefully trade response time for energy, reducing energy consumption by 54% for a 43% increase in average response time. In this paper we also highlight some research issues in the emerging area of energy-efficient data processing.
机构、总结、中文摘要均由AI分析而来，可能存在错误，请以论文正文为准。
