Skip to main content
padlock icon - secure page this page is secure

The Impact of Database Structure on Join Query’s Energy Consumption

Buy Article:

$106.51 + tax (Refund Policy)

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, this paper reports the results of an experiment that has been conducted which records the time taken and the energy consumed when running Join queries which retrieve all data from three relational databases of varying structures. The paper shares the experimental setup which includes the development of three differently designed database structures, the join queries to be tested as well as the datasets which are used in the experiment. Comparing the results of the join queries run on each of the three structures, there is no significant impact of a differently structured database on the amount of energy consumed by the queries if all data are retrieved. However, if the retrieved data are selective and come from indirectly linked tables, then the database structure does matter.
No Reference information available - sign in for access.
No Citation information available - sign in for access.
No Supplementary Data.
No Article Media
No Metrics

Keywords: Energy Consumption; Join Query; Relational Database Structure

Document Type: Research Article

Affiliations: Department of Computer and Information Sciences, Universiti Teknologi PETRONAS, 32610 Bandar Seri Iskandar, Perak, Malaysia

Publication date: November 1, 2017

More about this publication?
  • ADVANCED SCIENCE LETTERS is an international peer-reviewed journal with a very wide-ranging coverage, consolidates research activities in all areas of (1) Physical Sciences, (2) Biological Sciences, (3) Mathematical Sciences, (4) Engineering, (5) Computer and Information Sciences, and (6) Geosciences to publish original short communications, full research papers and timely brief (mini) reviews with authors photo and biography encompassing the basic and applied research and current developments in educational aspects of these scientific areas.
  • Editorial Board
  • Information for Authors
  • Subscribe to this Title
  • Ingenta Connect is not responsible for the content or availability of external websites
  • Access Key
  • Free content
  • Partial Free content
  • New content
  • Open access content
  • Partial Open access content
  • Subscribed content
  • Partial Subscribed content
  • Free trial content
Cookie Policy
X
Cookie Policy
Ingenta Connect website makes use of cookies so as to keep track of data that you have filled in. I am Happy with this Find out more