Multilevel caching to speedup query processing in distributed databases

Abstract

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.