Multilevel caching to speedup query processing in distributed databases
Doaa S. El Zanfaly, A.S. Eldean, Reda A.A. Ammar · 2004
Query caching has been utilized efficiently to improve query processing in distributed database environments. Most prior caching techniques are based on single-level caching of previous query results. This is basically to avoid accessing the underlying databases each time a user submits the same query. In this paper, we propose a new methodology that allows caching a combination of both plans and results of prior queries in a multi-level caching architecture. The objective is to reduce the response time of distributed query processing and hence increase the system throughput.