Abstract
With the Era of Big Data and the spectacular development of High-Performance Computing, organizations and countries spend considerable efforts and money to control/reduce the energy consumption. In data-centric applications, DBMS are one of the major energy consumers when executing complex queries. As a consequence, integrating the energy aspects in the advanced database design becomes an economic necessity. To predict this energy, the development of mathematical cost models is one of the avenues worth exploring. In this paper, we propose a cost model for estimating the energy required to execute a workload. This estimation is obtained by the means of statistical regression techniques that consider three types of parameters related to the query execution strategies, the used deployment platform and the characteristics of the data warehouses. To evaluate the quality of our cost model, we conduct two types of experiments: one using our mathematical cost model and another using a real DBMS with dataset of TPC-H and TPC-DS benchmarks. The obtained results show the quality of our cost model.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Alonso, R., Ganguly, S.: Energy efficient query optimization. Matsushita Info Tech Lab, Citeseer (1992)
Beloglazov, A., Buyya, R., Lee, Y.C., Zomaya, A., et al.: A taxonomy and survey of energy-efficient data centers and cloud computing systems. Adv. Comput. 82(2), 47–111 (2011)
Chaudhuri, S., Narasayya, V., Ramamurthy, R.: Estimating progress of execution for sql queries. In: SIGMOD, pp. 803–814. ACM (2004)
Graefe, G.: Database servers tailored to improve energy efficiency. In: Proceedings of the 2008 EDBT Workshop on Software Engineering for Tailor-Made Data Management, pp. 24–28. ACM (2008)
Harizopoulos, S., Shah, M., Meza, J., Ranganathan, P.: Energy efficiency: the new holy grail of data management systems research. arXiv preprint (2009). arXiv:0909.1784
Intel and Oracle. Oracle exadata on intel\(^{\textregistered }\) xeon\(^{\textregistered }\) processors: Extreme performance for enterprise computing. White paper (2011)
Intel Corporation. Intel\(^{\textregistered }\) 64 and IA-32 Architectures Optimization Reference Manual, September 2014
Kunjir, M., Birwa, P.K., Haritsa, J.R.: Peak power plays in database engines. In: EDBT, pp. 444–455. ACM (2012)
Lang, W., Kandhan, R., Patel, J.M.: Rethinking query processing for energy efficiency: slowing down to win the race. IEEE Data Eng. Bull. 34(1), 12–23 (2011)
Lang, W., Patel, J.: Towards eco-friendly database management systems. arXiv preprint (2009). arXiv:0909.1767
Li, J., Nehme, R., Naughton, J.: Gslpi: a cost-based query progress indicator. In: ICDE, pp. 678–689. IEEE (2012)
McCullough, J.C., Agarwal, Y., Chandrashekar, J., Kuppuswamy, S., Snoeren, A.C., Gupta, R.K.: Evaluating the effectiveness of model-based power characterization. In: USENIX Annual Technical Conference (2011)
Poess, M., Nambiar, R.O.: Energy cost, the key challenge of today’s data centers: a power consumption analysis of tpc-c results. PVLDB 1(2), 1229–1240 (2008)
Poess, M., Nambiar, R.O., Walrath, D.: Why you should run tpc-ds: a workload analysis. In: VLDB, pp. 1138–1149. VLDB Endowment (2007)
Rodriguez-Martinez, M., Valdivia, H., Seguel, J., Greer, M.: Estimating power/energy consumption in database servers. Procedia Comput. Sci. 6, 112–117 (2011)
Schall, D., Härder, T.: Towards an energy-proportional storage system using a cluster of wimpy nodes. In: BTW, pp. 311–325 (2013)
Tu, Y.-C., Wang, X., Zeng, B., Xu, Z.: A system for energy-efficient data management. ACM SIGMOD Rec. 43(1), 21–26 (2014)
Wang, J., Feng, L., Xue, W., Song, Z.: A survey on energy-efficient data management. ACM SIGMOD Rec. 40(2), 17–23 (2011)
Xu, Z., Tu, Y.-C., Wang, X.: Exploring power-performance tradeoffs in database systems. In: ICDE, pp. 485–496 (2010)
Xu, Z., Tu, Y.-C., Wang, X.: Power modeling in database management systems. Technical report CSE/12-094, University of South Florida (2012)
Xu, Z., Tu, Y.-C., Wang, X.: Dynamic energy estimation of query plans in database systems. In: ICDCS, pp. 83–92. IEEE (2013)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Roukh, A., Bellatreche, L. (2015). Eco-Processing of OLAP Complex Queries. In: Madria, S., Hara, T. (eds) Big Data Analytics and Knowledge Discovery. DaWaK 2015. Lecture Notes in Computer Science(), vol 9263. Springer, Cham. https://doi.org/10.1007/978-3-319-22729-0_18
Download citation
DOI: https://doi.org/10.1007/978-3-319-22729-0_18
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-22728-3
Online ISBN: 978-3-319-22729-0
eBook Packages: Computer ScienceComputer Science (R0)