|
Title:
|
ON ACCESS PATH SELECTION OF QUERIES IN MAIN MEMORY DATABASE USING A FUNCTIONAL MEMORY SYSTEM |
|
Author(s):
|
Jun Miyazaki |
|
ISBN:
|
978-972-8924-30-0 |
|
Editors:
|
Nuno Guimarães and Pedro Isaías |
|
Year:
|
2007 |
|
Edition:
|
Single |
|
Keywords:
|
main memory database, access path selection, query processing, memory system |
|
Type:
|
Full Paper |
|
First Page:
|
312 |
|
Last Page:
|
319 |
|
Language:
|
English |
|
Cover:
|
|
|
Full Contents:
|
click to dowload 
|
|
Paper Abstract:
|
In this paper, we describe on heuristic rules to choose an appropriate access path for a given query in main memory databases using a functional memory system. We have asserted that conventional cache-based memory access is not suitable for query processing in main memory databases. To cope with this problem, we have proposed three hardware supported memory access schemes. If selecting an appropriate memory access scheme from the proposed three schemes and the cache-based access, execution time of query processing can be reduced. In this paper, we derive heuristic rules which access path should be selected, and show its impact on execution time through experimentation. |
|
|
|
|
|
|
