scholarly journals Database engines: evolution of greenness

2021 ◽  
Author(s):  
Zainab Al-Zanbouri

Information Technology uses up to 10% of the world’s electricity generation, contributing to CO2 emissions and high energy costs. Data centers consume up to 23% of this energy, and a large fraction of this energy is consumed by databases. Therefore, building an energy efficient (green) database engine will reduce associated energy consumption and CO2 emissions. To understand the factors driving database energy consumption and execution time over the course of their evolution, we conducted an empirical case study of energy consumption of two MySQL database engines, InnoDB and MyISAM, across 12 releases. Moreover, we examined the relation between four software metrics and energy consumption & execution time, to determine the software metrics affecting the greenness and performance of a database. Our analysis shows that database engines energy consumption and execution time increase as databases evolve. Moreover, the Lines of Code metric is strongly correlated with energy consumption and execution time.

2021 ◽  
Author(s):  
Zainab Al-Zanbouri

Information Technology uses up to 10% of the world’s electricity generation, contributing to CO2 emissions and high energy costs. Data centers consume up to 23% of this energy, and a large fraction of this energy is consumed by databases. Therefore, building an energy efficient (green) database engine will reduce associated energy consumption and CO2 emissions. To understand the factors driving database energy consumption and execution time over the course of their evolution, we conducted an empirical case study of energy consumption of two MySQL database engines, InnoDB and MyISAM, across 12 releases. Moreover, we examined the relation between four software metrics and energy consumption & execution time, to determine the software metrics affecting the greenness and performance of a database. Our analysis shows that database engines energy consumption and execution time increase as databases evolve. Moreover, the Lines of Code metric is strongly correlated with energy consumption and execution time.


Recycling ◽  
2020 ◽  
Vol 5 (4) ◽  
pp. 25
Author(s):  
Alessio Quintili ◽  
Beatrice Castellani

Municipal solid waste collection and transport are functional activities in waste management, with a significant energy and carbon footprint and a significant effect on the urban environment. An issue related to municipal solid waste collection and transport is their regional and municipal implementation, affected by sorting and recycling strategies at local level. An efficient collection is necessary to optimize the whole recycling process. The present paper shows the results of an energy, environmental, and economic evaluation of a case study, analyzing the fleet used for municipal solid waste collection and transport in 10 municipalities in Central Italy. The current scenario was compared with alternative scenarios on the basis of some parameters for performance evaluation: vehicles’ energy consumption, carbon footprint, routes, and costs. Results show that for passenger cars, the alternative scenario based on an entire fleet of dual compressed natural gas (CNG) vehicles led to a reduction of the CO2 emissions (−2675 kgCO2eq) in the analyzed period (January–August 2019) and a reduction of the energy consumption (−1.96 MJ km−1). An entire fleet of CNG vehicles led to an increase of CO2 emissions: +0.02 kgCO2eqkgwaste−1 (+110%) for compactors (35–75 q) and +0.09 kgCO2eqkgwaste−1 (+377%) for compactors (80–180 q). Moreover, both categories report a higher fuel consumption and specific energy consumption. For waste transport high-capacity vehicles, we propose the installation of a Stop-Start System, which leads to environmental and energy benefits (a saving of 38,332 kgCO2eq and 8.8 × 10−7 MJ km−1kgwaste−1). On three-wheeler vehicles, the installation of the Stop-Start System is completely disadvantageous.


2012 ◽  
Vol 326-328 ◽  
pp. 366-371 ◽  
Author(s):  
D. Zambrana ◽  
A. Aranda ◽  
G. Ferreira ◽  
F. Barrio

Manufacturing processes involve the input of high quality energy and/or dissipation of low quality energy to manipulate a material; similarly the input of high quality material usually leads to the generation of low quality materials. A useful output involves the operation of conventional processes including a wide variety of functions such as lubrication, air compression, cooling, heating, pumping, etc., which have, on the one hand, high energy and material consumption and, on the other hand, losses due to an inherent departure from reversible processes. This paper presents an energy-flow methodology to determine the ratio between the additional energy required per useful energy unit for the manufacturing processes. As an application of the method proposed in this work, an assembly and welding production line is shown as a case study. This process is a common technique used in the manufacturing industry and its energy consumption depends on several parameters e.g. heat and electrical input. As a result of this study, the energy consumption of the production line has been reduced by approximately 30% from the 645.94 Wh of total energy consumption, where the consumption of real useful energy is 4% of this total.


2021 ◽  
Vol 6 (2) ◽  
pp. 03-17
Author(s):  
Gazal Dandia ◽  
◽  
Pratheek Sudhakaran ◽  
Chaitali Basu ◽  
◽  
...  

Introduction: High energy consumption by buildings is a great threat to the environment and one of the major causes of climate change. With a population of 1.4 billion people and one of the fastest-growing economies in the world, India is extremely vital for the future of global energy markets. The energy demand for construction activities continues to rise and it is responsible for over one-third of global final energy consumption. Currently, buildings in India account for 35% of total energy consumption and the value is growing by 8% annually. Around 11% of total energy consumption are attributed to the commercial sector. Energy-efficient retrofitting of the built environments created in recent decades is a pressing urban challenge. Presently, most energy-efficient retrofit projects focus mainly on the engineering aspects. In this paper, we evaluate various retrofitting options, such as passive architectural interventions, active technological interventions, or a combination of both, to create the optimum result for the selected building. Methods: Based on a literature study and case examples, we identified various energy-efficient retrofit measures, and then examined and evaluated those as applied to the case study of Awas Bhawan (Rajasthan Housing Board Headquarters), Jaipur, India. For the evaluation, we developed a simulation model using EQuest for each energy measure and calculated the resultant energy savings. Then, based on the cost of implementation and the cost of energy saved, we calculated the payback period. Finally, an optimum retrofit solution was formulated with account for the payback period and ease of installation. Results and discussion: The detailed analysis of various energy-efficient retrofit measures as applied to the case study indicates that the most feasible options for retrofit resulting in optimum energy savings with short payback periods include passive architecture measures and equipment upgrades.


2021 ◽  
Vol 13 (22) ◽  
pp. 12444
Author(s):  
Qusai Mohammad Qasim Alabed ◽  
Fathin Faizah Said ◽  
Zulkefly Abdul Karim ◽  
Mohd Azlan Shah Zaidi ◽  
Mohammed Daher Alshammary

This study provides new evidence regarding the nonlinear relationship between energy consumption and economic growth in the Middle East and North Africa (MENA) region for the 1990–2014 period. The empirical estimation is conducted using a dynamic panel threshold model. We found one threshold in the relationship between energy consumption and economic growth and one threshold in the relationship between carbon dioxide (CO2) emissions and economic growth. The results indicate that energy consumption positively and significantly affects economic growth in the low energy consumption regime. In contrast, it has a negative and significant impact on economic growth in the high energy consumption regime. Moreover, CO2 emissions are positively and significantly related to economic growth in the low regime of CO2 emissions. Nevertheless, the relationship between CO2 emissions and economic growth in the high CO2 emissions regime is negative and significant. Therefore, policymakers should implement other effective energy policies, such as stricter regulations on CO2 emissions, increase energy efficiency, and replace fossil fuels with cleaner energy sources to avoid unnecessary CO2 emissions and combat global warming. Future studies should identify the root causes of failures and issues in real time for inflation and link the energy–growth nexus to achieving the 2030 Sustainable Development Goals (SDGs) Agenda, Goal 7: Affordable and Clean Energy.


Author(s):  
Hassanean Jassim ◽  
Weizhuo Lu ◽  
Thomas Olofsson

Mass hauling operations play central roles in construction projects. They typically use many haulers that consume large amounts of energy and emit significant quantities of CO2. However, practical methods for estimating the energy consumption and CO2 emissions of such operations during project planning are lacking. This paper presents a detailed model for estimating the energy consumption and CO2 emissions of mass haulers that integrates the mass hauling plan with a set of predictive equations. The mass hauling plan is generated using a planning program such as DynaRoad in conjunction with data on the productivity of selected haulers and the amount of material to be hauled during cutting, filling, borrowing, and disposal operations. This plan is then used as input for estimating the energy consumption and CO2 emissions of the selected hauling fleet. The proposed model will help planners to assess the energy and environmental performance of mass hauling plans, and to select hauler and fleet configurations that will minimize these quantities. The model was applied in a case study, demonstrating that it can reliably predict energy consumption, CO2 emissions, and hauler productivity as functions of the hauling distance for individual haulers and entire hauling fleets.


Energies ◽  
2018 ◽  
Vol 12 (1) ◽  
pp. 33 ◽  
Author(s):  
Yongming Zhang ◽  
Zhe Yan ◽  
Feng Yuan ◽  
Jiawei Yao ◽  
Bao Ding

Elevators were reported to cause an important part of building energy consumption. In general, each elevator has two operation states: The load state and power regeneration state. During operation, it has the potential to save energy by using regeneration power efficiently. In existing research, a set of energy storage devices are installed for every elevator, which is highly costly. In this paper, an energy conservation approach for elevators based on a direct current (DC) micro-grid is proposed, which has better economy. Then, an innovative energy-efficient device for the elevator group is designed based on a supercapacitor with similar characteristics and lifetimes. In a high-rise building case study, the experimental test and field data collection show that the innovative approach could result in a high energy efficiency within 15.87–23.1% and 24.1–54.5%, respectively. It is expected that the proposed method and designed device could be employed practically, saving energy consumption for elevator reconstruction.


Sign in / Sign up

Export Citation Format

Share Document