Query Processing and Energy Consumptions in Data Centers

Authors

  • Vijaya Kumar S Department of Computer Science, Kathir College of Engineering, Coimbatore, Tamil Nadu, India
  • T.K.P. Rajagopal Department of Computer Science, Kathir College of Engineering, Coimbatore, Tamil Nadu, India
  • Seema Pillai Department of Computer Science, Kathir College of Engineering, Coimbatore, Tamil Nadu, India

DOI:

https://doi.org/10.37591/joadms.v3i2.757

Keywords:

Data, data centers, database systems, query execution plans, energy consumption plans

Abstract

Many researches are being conducted now in the field of software and hardware on energy consumption. Now a days it’s a huge challenge in front of us to handle the energy consumed for the large data centers which ideally deal with the large data transactions and storage. In the datacenters, on a daily basis many large queries are being run and a large amount of data is getting transacted, monitored and controlled. Usually all these actions are done with huge database systems which support efficient processing plans. In this paper, alternative methods to define the energy consumption plans for the database queries have been presented.

Cite this Article
Vijaya Kumar S, Rajagopal TKP, Seema Pillai. Query Processing and Energy Consumptions in Data Centers. Journal of Advanced Database Management & Systems. 2016; 3(2): 9–16p.

References

Muralikrishna M, Dewitt DJ. Equi-Depth Histograms for Estimating Selectivity Factors for Multi-Dimensional Queries. Proc. of ACM SIGMOD, Chicago. 1988.

Xu Z, Tu Y, Wang X. Exploring Power-Performance Tradeoffs in Database Systems. In ICDE. 2010; 485–496p.

Connolly TM, Begg CE. Database Systems: A Practical Approach to Design, Implementation and Management. 5th Edn. Pearson Addison Wesley; 2010.

Garcia-Molina H, Ullman JD, Widom J. Database Systems: The Complete Book. 2nd Edn. Upper Saddle River, NJ, USA: Prentice Hall Press; 2008.

Mackert LF, Lohman GM. Index Scans Using a Finite LRU Buffer: A Validated I/O Model. Transactions on Database Systems (TODS). 1989; 14(3): 401–424p.

Watts Up? Watts Up? Plug Load Meters. [online] Available at: [Accessed 20 Jul 2014].

Chaudhuri S. An Overview of Query Optimization in Relational Systems. In Proceedings of the Seventeenth ACM SIGACTSIGMOD-SIGART Symposium on Principles of Database Systems, PODS ’98. 1998; 34–43p.

Kumar R. Data Center Power, Cooling and Space: A Worrisome Outlook for the Next Two Years. 2010. Available at: https://www.gartner.com/doc/1313015/data-center-power-coolingspace [Accessed 15 Oct 2014].

Ono K, Lohman GM. Measuring the Complexity of Join Enumeration in Query Optimization. In Proc. of VLDB, Brisbane. 1990.

Ozsu MT, Valduriez P. Principles of Distributed Database Systems. Prentice-Hall; 1991.

Piatetsky-Shapiro G, Connell C. Accurate Estimation of the Number of Tuples Satisfying a Condition. In Proc. of ACMSIGMOD. 1984.

Pirahesh H, Hellerstein JM, Hasan W. Extensible/Rule Based Query Rewrite Optimization in Starburst. In Proc. of ACMSIGMOD. 1992.

Poosala V, Ioannidis Y, Haas P, et al. Improved Histograms for Selectivity Estimation. In Proc. of ACM SIGMOD, Montreal, Canada. 1996.

Seshadri P, et al. Cost Based Optimization for Magic: Algebra and Implementation. In Proc. of ACM SIGMOD, Montreal. 1996.

Seshadri P, Pirahesh H, Leung TYC. Decorrelating Complex Queries. In Proc. of the IEEE International Conference on Data Engineering. 1996.

Simmen D, Shekita E, Malkemus T. Fundamental Techniques for Order Optimization. In Proc. of ACM SIGMOD, Montreal. 1996.

Srivastava D, Dar S, Jagadish HV, Levy A. Answering Queries with Aggregation Using Views. Proc. of VLDB, Mumbai. 1996.

Yan YP, Larson PA. Eager Aggregation and Lazy Aggregation. In Proc. of VLDB Conference, Zurich. 1995.

Yang HZ, Larson PA. Query Transformation for PSJ-Queries. In Proc. of VLDB. 1987.

Downloads

Published

2016-07-19

Issue

Vol. 3 No. 2 (2016)

Section

Research Articles

License

Declaration and Copyright Transfer Form

(to be completed by authors)

I/ We, the undersigned author(s) of the submitted manuscript, hereby declare, that the above manuscript which is submitted for publication in the STM Journals(s), is not published already in part or whole (except in the form of abstract) in any journal or magazine for private or public circulation, and, is not under consideration of publication elsewhere.

  • I/We will not withdraw the manuscript after 1 week of submission as I have read the Author Guidelines and will adhere to the guidelines.
  • I/We Author(s ) have niether given nor will give this manuscript elsewhere for publishing after submitting in STM Journal(s).
  • I/ We have read the original version of the manuscript and am/ are responsible for the thought contents embodied in it. The work dealt in the manuscript is my/ our own, and my/ our individual contribution to this work is significant enough to qualify for authorship.
  •  I/We also agree to the authorship of the article in the following order:

Author’s name                                    

 

1. ________________

2. ________________

3. ________________

4. ________________

 

We  Author(s) tick this box and would request you to consider it as our signature as we agree to the terms of this Copyright Notice, which will apply to this submission if and when it is published by this journal.