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

6 Citations (Scopus)

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

Fingerprint

Energy utilization
Data storage equipment
Computer hardware
Computer systems

All Science Journal Classification (ASJC) codes

  • Engineering(all)

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).
Pisharath, Jayaprakash ; Choudhary, Alok ; Kandemir, Mahmut. / Reducing energy consumption of queries in memory-resident database systems. CASES 2004: International Conference on Compilers, Architecture, and Synthesis for Embedded Systems. 2004. pp. 35-45 (CASES 2004: International Conference on Compilers, Architecture, and Synthesis for Embedded Systems).
@inproceedings{61e8df8cabe94027abd3072ed1a3ce73,
title = "Reducing energy consumption of queries in memory-resident database systems",
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.",
author = "Jayaprakash Pisharath and Alok Choudhary and Mahmut Kandemir",
year = "2004",
month = "12",
day = "1",
language = "English (US)",
isbn = "1581138903",
series = "CASES 2004: International Conference on Compilers, Architecture, and Synthesis for Embedded Systems",
pages = "35--45",
booktitle = "CASES 2004",

}

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. 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, Washington, DC, United States, 9/22/04.

Reducing energy consumption of queries in memory-resident database systems. / Pisharath, Jayaprakash; Choudhary, Alok; Kandemir, Mahmut.

CASES 2004: International Conference on Compilers, Architecture, and Synthesis for Embedded Systems. 2004. p. 35-45 (CASES 2004: International Conference on Compilers, Architecture, and Synthesis for Embedded Systems).

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

TY - GEN

T1 - Reducing energy consumption of queries in memory-resident database systems

AU - Pisharath, Jayaprakash

AU - Choudhary, Alok

AU - Kandemir, Mahmut

PY - 2004/12/1

Y1 - 2004/12/1

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

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

UR - http://www.scopus.com/inward/record.url?scp=29144465119&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=29144465119&partnerID=8YFLogxK

M3 - Conference contribution

AN - SCOPUS:29144465119

SN - 1581138903

SN - 9781581138900

T3 - CASES 2004: International Conference on Compilers, Architecture, and Synthesis for Embedded Systems

SP - 35

EP - 45

BT - CASES 2004

ER -

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