Statistical analysis of query processing time in cache-based cloud database systems

Abstract With the proliferation of data in cloud-based systems, the performance of the data retrieval process from the database management system is becoming indispensable. Caching is one of the techniques to retrieve the data faster. It reduces the number of database accesses for similar queries, which in turn, reduces the processing time. It also facilitates in reducing the load on database servers, which results in the reduction of the overall response time. This paper is based on our caching framework for NOSQL datastores, which seeks to speed up the processing of many requests. The frequently used queries, which are expensive to reevaluate, are cached by this framework on top of a column-based datastore. In order to speed up query processing, certain queries are cached. In this study, query processing times without the influence of the database or system cache are used to evaluate the framework’s performance.