Low Power Management of OLTP Applications Considering Disk Drive Power Saving Function

  • Norifumi Nishikawa
  • Miyuki Nakano
  • Masaru Kitsuregawa
Part of the Lecture Notes in Computer Science book series (LNCS, volume 6261)


A power-saving management for OLTP applications has become an important task for user budgets and datacenter operations. This paper presents a novel power-saving method for multiple disk drives based on knowledge of OLTP application behaviors. We report detail analysis of power consumption of disk drives and I/O characteristics of OLTP application. We then show experimental and simulation results of our power-saving methods. Our method provides substantially lower power consumption of disk drives compared to that of a conventional OLTP environment.


Database Online Transaction Processing (OLTP) Disk Drive Power-Saving 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    U.S. Environmental Protection Agency ENERGY STAR Program, Report to Congress on Server and Data Center Energy Efficiency Public Law 109-431, http://www.energystar.gov/ia/partners/prod_development/downloads/EPA_Datacenter_Report_Congress_Final1.pdf
  2. 2.
    Bauer, R.: Building the Green Data Center: Towards Best Practices and Technical Considerations. In: Storage Networking World Fall 2008 Conference (2008), http://net.educause.edu/ir/library/pdf/bauer.pdf
  3. 3.
    Chu, P.B., Riedel, E.: Green Storage II: Metrics and Measurement (2008), http://net.educause.edu/ir/library/pdf/churiedel.pdf
  4. 4.
    Reinsel, D.: White Paper Datacenter SSDs: Solid Footing for Growth, IDC #210290 (2008)Google Scholar
  5. 5.
    Poess, M., Nambiar, R.O.: Energy cost, the key challenge of today’s data centers: a power consumption analysis of TPC-C results. In: International Conference on Very Large Data Base, pp.1229–1240 (2008)Google Scholar
  6. 6.
  7. 7.
    Douglis, F., Krishnan, P., Bershad, B.: Adaptive Disk Spin-Down Policies for Mobile Computers. In: Proceedings of 2nd USENIX Symposium on Mobile and Location Independent Computing (1995)Google Scholar
  8. 8.
    Helmbold, D.P., Long, D.D.E., Sconyers, T.L., Sherrod, B.: Adaptive Disk Spin Down for Mobile Computers. In: Mobile Networks and Applications, vol. 5(4) (2000)Google Scholar
  9. 9.
    Gurumurthi, S., Sivasubramaniam, A., Kandemir, M., Franke, H.: DRPM: Dynamic Speed Control for Power Management in Server Class Disks. In: 30th Annual International Symposium on Computer Architecture (2003)Google Scholar
  10. 10.
    Zhu, Q., Chen, Z., Tan, L., Zhou, Y., Keeton, K., Wilkes, J.: Hibernator: Helping Disk Arrays Sleep through the Winter. In: Proceedings of Twentieth ACM Symposium on Operating Systems Principles (2005)Google Scholar
  11. 11.
    Papathanasiou, A.E., Scott, M.L.: Energy Efficient Prefetching and Caching. In: Proceedings of the USENIX 2004 Annual Technical Conference (2004)Google Scholar
  12. 12.
    Li, D., Wang, J.: EERAID: Energy Efficient Redundant and Inexpensive Disk Arrays. In: Proceedings of 11th Workshop on ACM SIGOPS European workshop (2004)Google Scholar
  13. 13.
    Yao, X., Wang, J.: RIMAC: A Novel Redundancy based Hierarchical Cache Architecture for Energy Efficient. In: Proceedings of High Performance Storage System 2006 EuroSys Conference (2006)Google Scholar
  14. 14.
    Colarelli, D., Grunwald, D.: Massive Arrays of Idle Disks for Storage Archives. In: Supercomputing, ACM /IEEE 2002 Conference (2002)Google Scholar
  15. 15.
    Pinheiro, E., Bianchini, R.: Energy Conservation Techniques for Disk Array Based Servers. In: Proceedings of 18th Annual International Conference on Supercomputing (2004)Google Scholar
  16. 16.
    Weddle, C., Oldham, M., Qian, J., Wang, A.A.: PARAID: A Gear-Shifting Power-Aware RAID. In: FAST’07: 5th USENIX Conference on File and Storage (2007)Google Scholar
  17. 17.
    Son, S.W., Chen, G., Kandemir, M.: Disk Layout Optimization for Reducing Energy Consumption. In: Proceedings of 19th Annual International Conference on Supercomputing (2005)Google Scholar
  18. 18.
    Gniady, C., Hu, Y.C., Lu, Y.H.: Program Counter Based Techniques for Dynamic Power Management. In: High Performance Computer Architecture (2004)Google Scholar
  19. 19.
    Heath, T., Pinheiro, E., Hom, J., Kremer, U., Bianchini, R.: Application Transformations for Energy and Performance-Aware Device Management. In: Parallel Architectures and Compilation Techniques (2002)Google Scholar
  20. 20.
    Son, S.W., Kandemir, M., Choudhary, A.: Software-Directed Disk Power Management for Scientific Applications. In: Proceedings of 19th IEEE International Parallel and Distributed Processing Symposium (2005)Google Scholar
  21. 21.
    Transaction Processing Performance Council, TPC-C, an online transaction processing benchmark, http://www.tpc.org/tpcc/
  22. 22.

Copyright information

© Springer-Verlag Berlin Heidelberg 2010

Authors and Affiliations

  • Norifumi Nishikawa
    • 1
  • Miyuki Nakano
    • 1
  • Masaru Kitsuregawa
    • 1
  1. 1.Institute of Industrial ScienceThe University of TokyoTokyoJapan

Personalised recommendations