Abstract
Today’s system users demand fast answers when querying their own databases. Their impatience still high when waiting for the results of a query when they take more than one or two seconds to appear on the screen. However, having fast querying answers it is not the only aspect that determines the quality of a database system we are using, but also the energy consumption involved with. The development of database systems increasingly economic in terms of energy consumption has led to great technological advances in this area. Today, many of the entities that manage large data base systems pay particular attention to this issue, not only for environmental reasons but also for economic reasons, obviously. In this paper we address the issue of queries energy consumption evaluation in database systems, with particular emphasis to those that are executed in a environment of a document store. Based on the information provided by the execution of a query in MongoDB, we designed and developed a process that determines the energy consumption of queries launched in a document store, approaching different alternatives in query designing, implementation and execution.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Agrawal, R., Ailamaki, A., Bernstein, P., Brewer, E., Carey, M., Chaudhuri, S., Doan, A., Florescu, D., Franklin, M., Garcia-Molina, H., Gehrke, J., Gruenwald, L., Hass, L., Halevy, A., Hellerstein, J., Ioannidis, Y., Korth, H., Kossman, D., Madden, S., Magoulas, R., Ooi, B., O’Reilly, T., Ramakrishnan, R., Sarawagi, S., Stonebraker, M., Szalay, A., Weikum, G.: The claremont report on database research. Commun. ACM 52(6), 56–65 (2009)
Belo, O., Gonçalves, R., Saraiva, J.: Establishing energy consumption plans for green star-queries in data warehousing systems. In: Proceedings of the 2015 IEEE International Conference on Green Computing and Communications (GreenCom 2015), Sydney, Australia, pp. 11–13 (2015)
Gonçalves, R., Saraiva, J., Belo, O.: Defining energy consumption plans for data querying processes. In: Proceedings of the 4th IEEE International Conference on Sustainable Computing and Communications (SustainCom 2014), Sydney, Australia, 3–5 Dec 2014
Harizopoulos, S., Shah, M., Meza, J., Ranganathan, P.: Energy efficiency: the new holy grail of data management systems research. In: CIDR (2009)
Khargharia, B., Hariri, S., Yousif, M.: Autonomic power and performance management for computing systems. In: Proceedings of 2006 IEEE International Conference on Autonomic Computing, pp. 145–154 (2006)
Kunjir, M., Birwa, P., Haritsa, J.: Peak power plays in database engines. In: Proceedings of the 15th International Conference on Extending Database Technology, pp. 444–455 (2012)
Lang, W., Patel, J.M.: Towards eco-friendly database management systems. In: CIDR (2009)
Lang, W., Kandhan, R., Patel, J.M.: Rethinking query processing for energy efficiency: slowing down to win the race. IEEE Data Eng. Bull. 34, 12–23 (2011)
Liu, K., Pinto, G., Liu, Y.: Data-oriented characterization of application-level energy optimization. In: Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), pp. 316–331 (2015)
Moniruzzaman, A., Hossain, S.: Nosql database: new era of databases for big data analytics-classification, characteristics and comparison. Int. J. Database Theory Appl. 6(4), 1–14 (2013)
MongoDB: MongoDB. https://www.mongodb.com (2016). Accessed 19 Aug 2016
Person. L.: World NoSQL Market—opportunities and forecasts, 2013–2020 (2015)
Rasmussen, N.: A.p.c. determining total cost of ownership for data centers and network room infrastructure. www.apcmedia.com/salestools/CMRP-5T9PQG/CMRP-5T9PQG_R4_EN.pdf(2011). Accessed from 3 Sept 2016
TPC-H: TPC-H, An ad-hoc decision support benchmark. http://www.tpc.org/tpch/(2016). Accessed from 19 Aug 2016
Acknowledgments
This work has been supported by COMPETE: POCI-01-0145-FEDER-007043 and FCT—Fundação para a Ciência e Tecnologia within the Project Scope: UID/CEC/00319/2013.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 ICST Institute for Computer Sciences, Social Informatics and Telecommunications Engineering
About this paper
Cite this paper
Duarte, D., Belo, O. (2018). Evaluating Query Energy Consumption in Document Stores. In: Belqasmi, F., Harroud, H., Agueh, M., Dssouli, R., Kamoun, F. (eds) Emerging Technologies for Developing Countries. AFRICATEK 2017. Lecture Notes of the Institute for Computer Sciences, Social Informatics and Telecommunications Engineering, vol 206. Springer, Cham. https://doi.org/10.1007/978-3-319-67837-5_8
Download citation
DOI: https://doi.org/10.1007/978-3-319-67837-5_8
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-67836-8
Online ISBN: 978-3-319-67837-5
eBook Packages: Computer ScienceComputer Science (R0)