Reducing energy consumption of queries in memory-resident database systems

Jayaprakash Pisharath, Alok Choudhary, Mahmut Kandemir

Research output: Chapter in Book/Report/Conference proceedingConference contribution

7 Scopus citations

Abstract

The tremendous growth of system memories has increased the capacities and capabilities of memory-resident embedded databases, yet current embedded databases need to be tuned in order to take advantage of new memory technologies. In this paper, we study the implications of hosting memory resident databases, and propose hardware and software (query-driven) techniques to improve their performance and energy consumption. We exploit the structured organization of memories, which enables a selective mode of operation in which banks are accessed selectively. Unused banks are placed in a lower power mode based on access pattern information. We propose hardware techniques that dynamically control the memory by making the system adapt to the access patterns that arise from queries. We also propose a software (query-directed) scheme that directly modifies the queries to reduce the energy consumption by ensuring uniform bank accesses. Our results show that these optimizations could lead to at the least 40% reduction in memory energy. We also show that query-directed schemes better utilize the low-power modes, achieving up to 68% improvement.

Original languageEnglish (US)
Title of host publicationCASES 2004
Subtitle of host publicationInternational Conference on Compilers, Architecture, and Synthesis for Embedded Systems
Pages35-45
Number of pages11
StatePublished - Dec 1 2004
EventCASES 2004: International Conference on Compilers, Architecture, and Synthesis for Embedded Systems - Washington, DC, United States
Duration: Sep 22 2004Sep 25 2004

Publication series

NameCASES 2004: International Conference on Compilers, Architecture, and Synthesis for Embedded Systems

Other

OtherCASES 2004: International Conference on Compilers, Architecture, and Synthesis for Embedded Systems
CountryUnited States
CityWashington, DC
Period9/22/049/25/04

All Science Journal Classification (ASJC) codes

  • Engineering(all)

Fingerprint Dive into the research topics of 'Reducing energy consumption of queries in memory-resident database systems'. Together they form a unique fingerprint.

  • Cite this

    Pisharath, J., Choudhary, A., & Kandemir, M. (2004). Reducing energy consumption of queries in memory-resident database systems. In CASES 2004: International Conference on Compilers, Architecture, and Synthesis for Embedded Systems (pp. 35-45). (CASES 2004: International Conference on Compilers, Architecture, and Synthesis for Embedded Systems).