Determining Appropriate Cache-size for Cost-effective Cloud Database Queries

Abstract

Retrieving results from the cache is one of the prominent techniques to improve the query response time and reducing load on the back-end database servers. One of the important factors that influences the performance of cache system the most, is the size of the cache. In cloud-based systems, memory is scalable and hence, size of the cache is not a critical issue. However, when the cache is overpopulated with queries and their results, in that case, the query response time increases. This is due to the fact that time for searching the cache for the desired results increases. In this paper, an appropriate cache size is calculated in terms of the number of queries, for the database-size under consideration. This paper also describes the set-up of Virtual Machine Creation (VMC) cloud, using Cloud Virtual Machine Creation (CVMC) algorithm. This facilitates the deployment of database in cloud-based systems. An appropriate cache-size for cloud-based system is determined through experimentation using Apache HBase.