Abstract
Due to the energy consumption/resource utilization characteristics of todays centralized DB servers, the fastest configuration is also the most energy-efficient one. Extensive use of SSDs alone cannot enable a fundamental change of this overall picture, because the storage-related energy consumption is typically only a little fraction of the overall energy budget. Even, when this storage-related share is (almost) completely reduced by optimized flash-aware buffer management, the saving effect achieved may be limited by less than ~10%. Therefore, we have designed a cluster of wimpy computing nodes called WattDB, where the individual nodes are dynamically attached and detached to the cluster on demand – depending on the current workload needs –, thereby aiming at energy-proportional DB management.
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
Boncz, P.A., Manegold, S., Kersten, M.L.: Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct. PVLDB 2(2), 1648–1653 (2009)
Greenplum. Driving the Future of Data Warehousing and Analytics (2009), http://www.greenplum.com/
VoltDB. Fast, Scalable, Open-Source SQL DBMS with ACID (2010), http://voltdb.com/
Plattner, H.: SanssouciDB: An In-Memory Database for Processing Enterprise Workloads. In: Proc. BTW. LNI - P, vol. 180, pp. 2–21 (2011)
Härder, T., Schmidt, K., Ou, Y., Bächle, S.: Towards Flash Disk Use in Databases - Keeping Performance While Saving Energy? In: Proc. BTW. LNI - P, vol. 144, pp. 167–186 (2009)
Hudlet, V., Schall, D.: SSD!= SSD - An Empirical Study to Identify Common Properties and Type-specific Behavior. In: Proc. BTW. LNI - P, vol. 180, pp. 430–441 (2011)
Ou, Y., Härder, T., Schall, D.: Performance and Power Evaluation of Flash-Aware Buffer Algorithms. In: Bringas, P.G., Hameurlain, A., Quirchmayr, G. (eds.) DEXA 2010. LNCS, vol. 6261, pp. 183–197. Springer, Heidelberg (2010)
Bouganim, L., Jónsson, B.T., Bonnet, P.: uFLIP: Understanding Flash IO Patterns. In: CIDR (2009)
Graefe, G.: The five-minute rule 20 years later (and how flash memory changes the rules). Commun. ACM 52(7), 48–59 (2009)
Schall, D., Hudlet, V., Härder, T.: Enhancing Energy Efficiency of Database Applications Using SSDs. In: C3S2E, pp. 1–9 (2010)
Effelsberg, W., Härder, T.: Principles of Database Buffer Management. ACM TODS 9(4), 560–595 (1984)
Ou, Y., Härder, T., Jin, P.: CFDC: A Flash-Aware Buffer Management Algorithm for Database Systems. In: Catania, B., Ivanović, M., Thalheim, B. (eds.) ADBIS 2010. LNCS, vol. 6295, pp. 435–449. Springer, Heidelberg (2010)
Park, S., Jung, D., et al.: CFLRU: a Replacement Algorithm for Flash Memory. In: CASES, pp. 234–241 (2006)
Jung, H., Shim, H., et al.: LRU-WSR: Integration of LRU and Writes Sequence Reordering for Flash Memory. Trans. on Cons. Electr. 54(3), 1215–1223 (2008)
Seo, D., Shin, D.: Recently-evicted-first Buffer Replacement Policy for Flash Storage Devices. Trans. on Cons. Electr. 54(3), 1228–1235 (2008)
Tsirogiannis, D., Harizopoulos, S., Shah, M.A.: Analyzing the Energy Efficiency of a Database Server. In: SIGMOD, pp. 231–242 (2010)
Barroso, L.A., Hölzle, U.: The Datacenter as a Computer: An Introduction to the Design of Warehouse-Scale Machines, Synthesis Lectures on Computer Architecture. Morgan & Claypool Publishers (2009)
Albers, S.: Energy-efficient Algorithms. Commun. ACM 53(5), 86–96 (2010)
Rahm, E.: Evaluation of Closely Coupled Systems for High-Performance Database Processing. In: ICDCS, pp. 301–310 (1993)
Szalay, A.S., Bell, G.C., Huang, H.H., Terzis, A., White, A.: Low-power Amdahl-balanced Blades for Data-intensive Computing. SIGOPS Oper. Syst. Rev. 44
Li, X., Li, Z., Zhou, Y., Adve, S.: Performance-Directed Energy Management for Main Memory and Disks. Trans. Storage 1, 346–380 (2005)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Härder, T., Hudlet, V., Ou, Y., Schall, D. (2011). Energy Efficiency Is Not Enough, Energy Proportionality Is Needed!. In: Xu, J., Yu, G., Zhou, S., Unland, R. (eds) Database Systems for Adanced Applications. DASFAA 2011. Lecture Notes in Computer Science, vol 6637. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-20244-5_22
Download citation
DOI: https://doi.org/10.1007/978-3-642-20244-5_22
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-20243-8
Online ISBN: 978-3-642-20244-5
eBook Packages: Computer ScienceComputer Science (R0)