The Impact of Database Structure on Join Query’s Energy Consumption
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
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