Energy Efficient Query Processing in Green Database

Authors(4) :-M. P. Saranya, K. Soni Priyanka, S. Poonam, M.Tamil Thendral

Data centers square measure renowned to consume giant amounts of energy. Since information is during all the main applications in a typical information center, building energy-aware information systems has become a lively analysis topic recently. The quantification of the energy price of information systems is a very important task in coming up with such systems. During this paper, we tend to report our recent efforts on this subject, with a spotlight on the energy price estimation of question plans throughout question improvement. We tend to begin from building a series of physical models for energy estimation of individual relative operators supported their resource consumption patterns. Since the execution of individual queries may be a combination of relative operators, we tend to use the physical models as a basis for a comprehensive energy price estimation model for entire question plans. To additional improve model accuracy underneath system dynamics and also the variations of work characteristics, we tend to develop an internet model estimation theme that dynamically corrects the static model supported advanced modeling techniques adopted from management engineering. Mistreatment the price model as a basis, the analysis model will utilize the trade-offs between power and performance of plans and helps the question optimizer choose plans that meet performance needs however lead to lower energy price. Finally, an inexperienced information framework integrated with the 2 higher than models is projected to boost a poster software. Experimental results reveal that, with reliable and correct applied math information, the projected framework during this study is able to do important energy savings and improve energy potency.

Authors and Affiliations

M. P. Saranya
Student, Computer Science and Engineering, Kingston Engineering College, Vellore, Tamil Nadu, India
K. Soni Priyanka
Student, Computer Science and Engineering, Kingston Engineering College, Vellore, Tamil Nadu, India
S. Poonam
Student, Computer Science and Engineering, Kingston Engineering College, Vellore, Tamil Nadu, India
M.Tamil Thendral
Assistant Professor, Computer Science and Engineering, Kingston Engineering College, Vellore, Tamil Nadu, India

Performance, Tools, Query Optimization, IO cost, Energy consumption.

  1. Barroso, L.A., Hölzle, U., 2007. The case for energy-proportional computing. Computer 2007 (12), 33-37.
  2. Bausch, D., Petrov, I., Buchmann, A., 2012. Making cost-based query optimization asymmetry-aware. In: Proceedings of the Eighth International Workshop on Data Management on New Hardware. ACM: New York. pp. 24-32.
  3. Beckmann, A., Meyer, U., Sanders, P., et al., 2011. Energy-efficient sorting using solid state disks. Sustain. Comput.: Inform. Syst. 1 (2), 151-163.
  4. Belady, C.L., 2007. In the data center, power and cooling costs more than the IT equipment it supports. Electron. Cool. 13 (1), 24.
  5. Bin, L., Jiong, Y., Hua, S., et al., 2013. Energy-efficient algorithms for distributed storage system based on data storage structure reconfiguration. J. Netw. Comput. Appl. 48 (1), 71-86. 6Binglei, G., Jiong, Y., et al., 2015a. 10, 202-207.
  6. Binglei, G., Jiong, Y., et al., 2015b. SQL execution power profiling and modeling. J. Comput. Appl. 12, 3362-3367.
  7. Bjørling, M., Folgoc, L.L., Mseddi, A., et al., 2010. Performing sound flash device measurements: some lessons from uFLIP. In: Proceedings of the 2010 ACM SIGMOD International Conference on Management of data. ACM: New York. pp. 1219-1222.

Publication Details

Published in : Volume 3 | Issue 3 | March-April 2018
Date of Publication : 2018-04-30
License:  This work is licensed under a Creative Commons Attribution 4.0 International License.
Page(s) : 1095-1100
Manuscript Number : CSEIT1833343
Publisher : Technoscience Academy

ISSN : 2456-3307

Cite This Article :

M. P. Saranya, K. Soni Priyanka, S. Poonam, M.Tamil Thendral, "Energy Efficient Query Processing in Green Database", International Journal of Scientific Research in Computer Science, Engineering and Information Technology (IJSRCSEIT), ISSN : 2456-3307, Volume 3, Issue 3, pp.1095-1100, March-April-2018.
Journal URL :

Article Preview

Follow Us

Contact Us