ABSTRACT
Database software can be tailored for specific application domains and their required functionality, for specific hardware and its characteristics, or for other purposes. This brief paper collects issues and techniques required or desirable for making a server-class database management system energy-efficient. The opportunities go far beyond cost functions and general performance improvements. Topics include additional layers in the memory hierarchy, I/O optimizations, data format, scheduling, adaptive query plan execution, and self management in novel ways.
This paper represents a challenge rather than a solution. Promising approaches and techniques are indicated throughout, but the challenge is to provide tools for building and tailoring experimental database software that enables research into energy-efficient database management.
- {G 03} Goetz Graefe: Executing Nested Queries. BTW Conf. 2003: 58--77.Google Scholar
- {G 03a} Goetz Graefe: Sorting and Indexing with Partitioned B-Trees. CIDR 2003.Google Scholar
- {G 04} Goetz Graefe: Write-Optimized B-Trees. VLDB 2004: 672--683. Google ScholarDigital Library
- {G 07} Goetz Graefe: Master-detail clustering using merged indexes. Informatik-Forschung und Entwicklung 21(3--4): 127--145 (2007).Google Scholar
- {G 07a} Goetz Graefe: The five-minute rule twenty years later, and how flash memory changes the rules. DaMoN 2007. Google ScholarDigital Library
- {G 97} Jim Gray, Gianfranco R. Putzolu: The 5 Minute Rule for Trading Memory for Disk Accesses and The 10 Byte Rule for Trading Memory for CPU Time. ACM SIGMOD 1987: 395--398. Google ScholarDigital Library
- {LJB 95} Harry Leslie, Rohit Jain, Dave Birdsall, Hedieh Yaghmai: Efficient Search of Multi-Dimensional B-Trees. VLDB 1995: 710--719. Google ScholarDigital Library
- {MB 06} Andreas Merkel, Frank Bellosa: Balancing power consumption in multiprocessor systems. EuroSys 2006: 403--414.Google Scholar
- {NDR 08} Dushyanth Narayanan, Austin Donnelly, Antony Rowstron: Write Off-Loading: Practical Power Management for Enterprise Storage. FAST 2008.Google Scholar
- {Q 07} http://quincywashington.us/utilities_rates.html, retrieved December 26, 2007.Google Scholar
- {RD 05} Ravishankar Ramamurthy, David J. DeWitt: Buffer-pool Aware Query Optimization. CIDR Conf. 2005: 250--261.Google Scholar
- {RMF 00} Frank Ramsak, Volker Markl, Robert Fenk, Martin Zirkel, Klaus Elhardt, Rudolf Bayer: Integrating the UB-Tree into a Database System Kernel. VLDB 2000: 263--272. Google ScholarDigital Library
- {RO 92} Mendel Rosenblum, John K. Ousterhout: The Design and Implementation of a Log-Structured File System. ACM TODS 10(1): 26--52 (1992). Google ScholarDigital Library
- {RRT 08} Ramya Raghavendra, Parthasarathy Ranganathan, Vanish Talwar, Zhikui Wang, Xiaoyun Zhu: No "Power" Struggles: Coordinated Multi-level Power Management for the Data Center. ASPLOS 2008.Google ScholarDigital Library
- {RSR 07} Suzanne Rivoire, Mehul A. Shah, Parthasarathy Ranganathan, Christos Kozyrakis: JouleSort: a balanced energy-efficiency benchmark. ACM SIGMOD 2007: 365--376. Google ScholarDigital Library
- {SAB 05} Michael Stonebraker, Daniel J. Abadi, Adam Batkin, Xuedong Chen, Mitch Cherniack, Miguel Ferreira, Edmond Lau, Amerson Lin, Samuel Madden, Elizabeth J. O'Neil, Patrick E. O'Neil, Alex Rasin, Nga Tran, Stanley B. Zdonik: C-Store: A Column-oriented DBMS. VLDB 2005: 553--564. Google ScholarDigital Library
- {SL 76} Dennis G. Severance, Guy M. Lohman: Differential Files: Their Application to the Maintenance of Large Databases. ACM TODS 1(3): 256--267 (1976). Google ScholarDigital Library
- {WBB 02} Andreas Weissel, Bjórn Beutel, Frank Bellosa: Cooperative I/O: A Novel I/O Semantics for Energy-A ware Applications. OSDI 2002.Google ScholarCross Ref
- {ZEL 02} Heng Zeng, Carla Schlatter Ellis, Alvin R. Lebeck, Amin Vahdat: ECOSystem: managing energy as a first class operating system resource. ASPLOS 2002:123--132. Google ScholarDigital Library
- {ZHN 07} Marcin Zukowski, Sándor Héman, Niels Nes, Peter A. Boncz: Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS. VLDB 2007: 723--734. Google ScholarDigital Library
Index Terms
- Database servers tailored to improve energy efficiency
Recommendations
Energy Efficiency of ORM Approaches: an Empirical Evaluation
ESEM '16: Proceedings of the 10th ACM/IEEE International Symposium on Empirical Software Engineering and MeasurementContext. Object-Relational Mapping (ORM) frameworks are widely used in business software applications to interact with database systems. Even if ORMs introduce several benefits when compared to a plain SQL approach, these techniques have known ...
Comments