Skip to main content
SpringerLink
Log in

Energy Efficiency Is Not Enough, Energy Proportionality Is Needed!

  • Conference paper
Database Systems for Adanced Applications (DASFAA 2011)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 6637))

Included in the following conference series:

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Boncz, P.A., Manegold, S., Kersten, M.L.: Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct. PVLDB 2(2), 1648–1653 (2009)

    Google Scholar 

  2. Greenplum. Driving the Future of Data Warehousing and Analytics (2009), http://www.greenplum.com/

  3. VoltDB. Fast, Scalable, Open-Source SQL DBMS with ACID (2010), http://voltdb.com/

  4. Plattner, H.: SanssouciDB: An In-Memory Database for Processing Enterprise Workloads. In: Proc. BTW. LNI - P, vol. 180, pp. 2–21 (2011)

    Google Scholar 

  5. 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)

    Google Scholar 

  6. 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)

    Google Scholar 

  7. 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)

    Chapter  Google Scholar 

  8. Bouganim, L., Jónsson, B.T., Bonnet, P.: uFLIP: Understanding Flash IO Patterns. In: CIDR (2009)

    Google Scholar 

  9. Graefe, G.: The five-minute rule 20 years later (and how flash memory changes the rules). Commun. ACM 52(7), 48–59 (2009)

    Article  Google Scholar 

  10. Schall, D., Hudlet, V., Härder, T.: Enhancing Energy Efficiency of Database Applications Using SSDs. In: C3S2E, pp. 1–9 (2010)

    Google Scholar 

  11. Effelsberg, W., Härder, T.: Principles of Database Buffer Management. ACM TODS 9(4), 560–595 (1984)

    Article  Google Scholar 

  12. 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)

    Chapter  Google Scholar 

  13. Park, S., Jung, D., et al.: CFLRU: a Replacement Algorithm for Flash Memory. In: CASES, pp. 234–241 (2006)

    Google Scholar 

  14. 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)

    Article  Google Scholar 

  15. Seo, D., Shin, D.: Recently-evicted-first Buffer Replacement Policy for Flash Storage Devices. Trans. on Cons. Electr. 54(3), 1228–1235 (2008)

    Article  Google Scholar 

  16. Tsirogiannis, D., Harizopoulos, S., Shah, M.A.: Analyzing the Energy Efficiency of a Database Server. In: SIGMOD, pp. 231–242 (2010)

    Google Scholar 

  17. 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)

    Google Scholar 

  18. Albers, S.: Energy-efficient Algorithms. Commun. ACM 53(5), 86–96 (2010)

    Article  Google Scholar 

  19. Rahm, E.: Evaluation of Closely Coupled Systems for High-Performance Database Processing. In: ICDCS, pp. 301–310 (1993)

    Google Scholar 

  20. 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

    Google Scholar 

  21. Li, X., Li, Z., Zhou, Y., Adve, S.: Performance-Directed Energy Management for Main Memory and Disks. Trans. Storage 1, 346–380 (2005)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Databases and Information Systems Group, University of Kaiserslautern, Germany

    Theo Härder, Volker Hudlet, Yi Ou & Daniel Schall

Authors
  1. Theo Härder
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Volker Hudlet
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Yi Ou
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Daniel Schall
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science, Hong Kong Baptist University, Kowloon Tong, KLN, Hong Kong, China

    Jianliang Xu

  2. School of Information Science and Engineering, Northeastern University, Shenyang, 110004, Liaoning, China

    Ge Yu

  3. School of Computer Science, Fudan University, 220 Handan Road, 200433, Shanghai, China

    Shuigeng Zhou

  4. Institute for Computer Science and Business Information Systems (ICB), University of Duisburg-Essen, Schützenbahn 70, 45117, Essen, Germany

    Rainer Unland

Rights and permissions

Reprints 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)

Publish with us

Policies and ethics

Search

Navigation