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

通过技术创新来维持可持续发展的社会已经成为计算系统设计的主要挑战。在这个项目中，我们专注于一个重要类型的计算机应用程序的能源效率，数据库管理系统（DBMS），这往往消耗了很大一部分的计算资源和能源在现代数据中心。这个项目的目标是设计和实现一个数据库管理系统，使显着的节能与优雅的查询处理性能的退化。该项目通过以下方法实现了目标：（1）动态地利用数据库管理系统中的能量-性能权衡以及硬件系统的低功耗模式，在保证性能的前提下提高能量效率：（2）将能量有效的数据库管理系统设计描述为一个反馈控制问题，并采用适当的形式化控制技术，在理论分析和保证的前提下实现期望的性能和能量效率;（3）应用高级多阶段优化方法来解决复杂的节能存储管理问题;（4）协调DBMS不同层中的各种控制和优化循环，以实现最大限度的节能和全局系统稳定性。该项目的广泛影响体现在两个层面。在社会层面上，通过实施所提出的能量感知DBMS来减少能源消耗和CO2排放可以是实质性的。该项目可以使大量工业部门受益，这些行业的运营严重依赖数据库支持的软件，如在线零售系统，财务管理软件和社交网络平台，大大降低了电力成本。 在教育层面，该项目培养博士。在跨学科的环境中，通过提供一组丰富的应用实例、软件工具和项目机会，为学生提供培训，并增强了佛罗里达大学和田纳西大学诺克斯维尔分校教授的几门课程。该项目的出版物、技术报告、软件和实验数据可在www.cse.usf.edu/~ytu/EDBMS上找到。

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.