III: Small: Collaborative Research: Making Databases Green - An Energy-Aware DBMS Approach

III：小型：协作研究：使数据库变得绿色 - 一种节能意识 DBMS 方法

• 批准号: 1116790
• 负责人: Xiaorui Wang
• 金额: $ 22.99万
• 依托单位: University of Tennessee Knoxville
• 依托单位国家: 美国
• 项目类别: Continuing Grant
• 财政年份: 2011
• 资助国家: 美国
• 起止时间: 2011-07-01 至 2011-10-31
• 项目状态: 已结题
• 来源: https://www.nsf.gov/awardsearch/showAward?AWD_ID=1116790&HistoricalAwards=false
• 关键词: III; Small; Collaborative; Research; Making

Maintaining a sustainable society via technological innovations has been a major challenge for computing system design. In this project, we focus on the energy efficiency of an important type of computer applications, the database management systems (DBMS), which often consume a large portion of the computing resources and energy in modern data centers. The goal of this project is to design and implement a DBMS that enables significant energy conservation with graceful degradation of query processing performance. The project achieves its goal using the following approaches: (1) Dynamically exploit the energy-performance tradeoffs in DBMS as well as low-power modes of hardware systems for improved energy efficiency with performance guarantees; (2) Formulate the energy-efficient DBMS design as a feedback control problem, and adopt appropriate formal control techniques to achieve the desired performance and energy efficiency with theoretical analysis and guarantees; (3) Apply advanced multi-stage optimization methods to solve complex energy-aware storage management problems; and (4) Coordinate various control and optimization loops in different layers of the DBMS for maximized energy savings and global system stability. The broader impacts of the project are at two levels. At the society level, the reduction of energy consumption and CO2 emission by implementing the proposed energy-aware DBMS can be substantial. The project can benefit a large number of industrial sectors, the operations of which depend heavily on database-supported software such as online retailing systems, financial management software, and social networking platforms, by significantly lowering their electricity cost. At the education level, the project trains Ph.D. students in an interdisciplinary environment and enhances several courses taught at the University of Florida and the University of Tennessee at Knoxville by providing a rich set of application examples, software tools, and project opportunities. Publications, technical reports, software and experimental data from this project can be found at www.cse.usf.edu/~ytu/EDBMS.

通过技术创新维持可持续的社会一直是计算系统设计的主要挑战。在这个项目中，我们专注于重要类型的计算机应用程序的能源效率，即数据库管理系统（DBMS），该系统通常会在现代数据中心消耗大部分计算资源和能源。该项目的目的是设计和实施DBM，以优雅的查询处理性能降级，从而实现大量的节能。该项目使用以下方法实现了目标：（1）动态利用DBMS中的能量性能权衡以及硬件系统的低功率模式，以提高能源效率并保证绩效； （2）将节能DBMS设计作为反馈控制问题，并采用适当的正式控制技术，通过理论分析和保证来实现所需的性能和能源效率； （3）应用高级多阶段优化方法来解决复杂的能源感知存储管理问题； （4）在DBM的不同层中协调各种控制和优化循环，以最大化能源节省和全球系统稳定性。该项目的更广泛影响是两个层次。在社会一级，通过实施拟议的能源感知的DBM来减少能源消耗和CO2排放可能是很大的。该项目可以使大量工业领域受益，其运营很大程度上取决于数据库支持的软件，例如在线零售系统，财务管理软件和社交网络平台，通过大大降低电力成本。 在教育层面，该项目培训博士学位。在跨学科环境中的学生，通过提供丰富的申请示例，软件工具和项目机会，增强了佛罗里达大学和田纳西大学田纳西大学教授的几门课程。可以在www.cse.usf.edu/~ytu/edbms上找到该项目的出版物，技术报告，软件和实验数据。