@inproceedings{9295d483cfd64f32aab5d86eddbda3ca,
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.",
keywords = "DRAM, Database, Energy, Hardware schemes, Layouts, Mapping, Power consumption, Query optimization, Query-directed energy management",
author = "Jayaprakash Pisharath and Alok Choudhary and Mahmut Kandemir",
note = "Copyright: Copyright 2020 Elsevier B.V., All rights reserved.; CASES 2004: International Conference on Compilers, Architecture, and Synthesis for Embedded Systems ; Conference date: 22-09-2004 Through 25-09-2004",
year = "2004",
doi = "10.1145/1023833.1023840",
language = "English (US)",
isbn = "1581138903",
series = "CASES 2004: International Conference on Compilers, Architecture, and Synthesis for Embedded Systems",
publisher = "Association for Computing Machinery",
pages = "35--45",
booktitle = "CASES 2004",
}