Towards Energy Efficient Query Processing in Database Management System
CONTENTS 1. ABSTRACT……………………………………………………………………………2
2. INTRODUCTION……………………………………………………………………...3
3. ANALYSIS OF ENERGY EFFICIENCY……………………………………………..3 3.1. CPU POWER MANAGEMENT………………………………………………….4 3.2. TOWARDS ECO-DBMS………………………………………………………….5 3.3. QUERY PROCESSING FRAMEWORK…………………………………………7 3.4. ENERGY COST MODEL…………………………………………………………8
4. CONCLUSION………………………………………………………………………….9
1. ABSTRACT
Database management systems (DBMSs) have largely ignored the task of managing the energy consumed during query processing. Both economic 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 over-lap, 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.
2. INTRODUCTION
Servers consume enormous amounts of energy. A recent
2. INTRODUCTION……………………………………………………………………...3
3. ANALYSIS OF ENERGY EFFICIENCY……………………………………………..3 3.1. CPU POWER MANAGEMENT………………………………………………….4 3.2. TOWARDS ECO-DBMS………………………………………………………….5 3.3. QUERY PROCESSING FRAMEWORK…………………………………………7 3.4. ENERGY COST MODEL…………………………………………………………8
4. CONCLUSION………………………………………………………………………….9
1. ABSTRACT
Database management systems (DBMSs) have largely ignored the task of managing the energy consumed during query processing. Both economic 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 over-lap, 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.
2. INTRODUCTION
Servers consume enormous amounts of energy. A recent