Analyzing Power Consumption in Query Processing for Centralized Database System

• Main Author: Mohd Bohari, Muhammad Nasrulhaq
• Format: Final Year Project
• Language: English
• Published: UNIVERSITI TEKNOLOGI PETRONAS 2012
• Online Access: http://utpedia.utp.edu.my/6303/1/Dissertation_12753.pdf; http://utpedia.utp.edu.my/6303/

Green computing is the environmentally responsible use of computers and related resources as well as reduced power resource consumption. In supporting to green computing, this project is being carried out with the main purpose to analyze the efficient performance of query processing activity in consuming power from a centralized database by implementing different query strategies in data grouping. In achieving the goal, each data query strategy retrieved from the database is measured based on its power consumption by using an energy saving power meter. A consolidated hotel management system is developed as to indicate the context of the project in testing on the query power usage from a centralized database system. This project emphasizes on the amount of power (in watts) that the query consumed based on the size of the query and the strategy used in assembling the data. It is more focusing on the simulation of query dataset in consuming power and not on developing a real-time system. Hence, 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, readers would be able to see and analyze that various query strategies applied in retrieving the same output under a specified condition gives dissimilar power reading which indicates the different amount of power consumption by each data query.