Monitoring Power Consumption by Changing Query Plan for Single Database System

Green computing or Green IT is the environmentally responsible use of computers and related resources as well as the reduction of power resource consumption. In supporting green computing and Green IT, this project is being carried out with the main purpose of creating a draft or template where it can calculate the power consumption of the computer or server when the database query is being process by implementing different type of query plan. The power consumption can be measured by using an energy saving power meter. A consolidated sample of management system will be developed as to indicate the context of the project in testing the query plan from a centralized database system. This project emphasizes on the amount of power usage (in watts) that the query plan consumed in assembling the data. It is more on focusing on the simulation of query plan in consuming power and not on developing a real-time system. Hence making the functionality and reliability of the system is not the main focus and will not be discussed in this paper work. By the end of this project, database developers would be able to see and analyze the various query plan applied in retrieving the same output under a specified condition that gives dissimilar power reading which indicates the different amount of power consumption by each query plan.