| |
Motivation
Database applications are a very common workload. Nevertheless,
there are very few works on analyzing the memory behavior of
this type of workload. This is becomming more important as memory
prices are decreasing.
Our Work
Our group has presented a preliminary analysis of part of the
TPC-D benchmark in the Third International Symposium on
High-Performance Computer Architecture, February 1997 .
This work, with title
The Memory Performance of DSS Commercial Workloads in
Shared-Memory Multiprocessors is available on the web.
Conclusions
From our preliminary work we found out that:
- Query memory behavior depends on data access method (index
or sequential scan);
- We found spatial and temporal locality in some of the
queries;
- Simple data prefetching optimization has potential for
improving the query execution.
|
