Authors:
Chetan Phalak
1
;
Rekha Singhal
1
and
Tanmay Jhunjhunwala
2
Affiliations:
1
Tata Consultancy Services, India
;
2
Delhi University, India
Keyword(s):
Database Buffer Cache, Data Blocks, Index Blocks, LRU, Simulator, Cache Hit, Cache Miss.
Related
Ontology
Subjects/Areas/Topics:
Business Analytics
;
Data Engineering
;
Dimensional Modeling
;
Predictive Modeling
Abstract:
Usage of an electronic media is increasing day by day and consequently the usage of applications. This fact has resulted in rapid growth of an application's data which may lead to violation of service level agreement (SLA) given to its users. To keep applications SLA compliance, it is necessary to predict the query response time before its deployment. The query response time comprises of two elements, computation time and IO access time. The latter includes time spent in getting data from disk subsystem and database/operating system (OS) cache. Correct prediction of a query performance needs to model cache behavior for growing data size. The complex nature of data storage and data access pattern by queries brings in difficulty to use only mathematical model for cache behavior prediction. In this paper, a Database Buffer Cache Simulator has been proposed, which mimics the behavior of the database buffer cache, which can be used to predict the cache misses for different types of data a
ccess by a query. The simulator has been validated using Oracle 11g and TPC-H benchmarks. The simulator is able to predict cache misses with an average error of 2%.
(More)