Home // DBKDA 2016, The Eighth International Conference on Advances in Databases, Knowledge, and Data Applications // View article

Some Heuristic Approaches for Reducing Energy Consumption on Database Systems

Authors:
Miguel Guimarães
João Saraiva
Orlando Belo

Keywords: data centers; database management systems; querying execution plans, database queries consumption, green queries; consumption heuristics.

Abstract:
Today, one of the major concerns of administrators and managers of data centers is related with the cost of the energy that each database component consumes when involved in activities and processes they manage. In fact, it is not necessary to conduct a detailed assessment to realize that the cost of energy consumed in this type of systems is really great. So, it is not surprising the significant growing interest that researchers have in this domain. Various techniques have been developed to assess the energy consumption on database systems, demonstrating their utility in managing the power they use to consume. Basically, they come to confirm the paradigm shift on the issue of energy concern in database systems towards the reduction of its consumption. In this paper, we present and discuss a set of heuristics that we suggest to reduce, in particular, the energy consumption on the execution of a given query inside a relational database system. With this work, we intend to contribute to design and implement more efficient queries in terms of energy, i.e., green queries, based on the analysis of the various components that are used in their physical implementation, reducing as much as possible their energy consumption, taking into consideration the characteristics of the database operators used and the querying execution plans established for them.

Pages: 49 to 53

Copyright: Copyright (c) IARIA, 2016

Publication date: June 26, 2016

Published in: conference

ISSN: 2308-4332

ISBN: 978-1-61208-486-2

Location: Lisbon, Portugal

Dates: from June 26, 2016 to June 30, 2016