loading
Documents

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Chetan Phalak 1 ; Rekha Singhal 1 and Tanmay Jhunjhunwala 2

Affiliations: 1 Tata Consultancy Services, India ; 2 Delhi University, India

ISBN: 978-989-758-193-9

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 ac cess 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)

PDF ImageFull Text

Download
Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 52.87.176.39

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Phalak, C.; Singhal, R. and Jhunjhunwala, T. (2016). Database Buffer Cache Simulator to Study and Predict Cache Behavior for Query Execution.In Proceedings of the 5th International Conference on Data Management Technologies and Applications - Volume 1: DATA, ISBN 978-989-758-193-9, pages 71-78. DOI: 10.5220/0005936800710078

@conference{data16,
author={Chetan Phalak. and Rekha Singhal. and Tanmay Jhunjhunwala.},
title={Database Buffer Cache Simulator to Study and Predict Cache Behavior for Query Execution},
booktitle={Proceedings of the 5th International Conference on Data Management Technologies and Applications - Volume 1: DATA,},
year={2016},
pages={71-78},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005936800710078},
isbn={978-989-758-193-9},
}

TY - CONF

JO - Proceedings of the 5th International Conference on Data Management Technologies and Applications - Volume 1: DATA,
TI - Database Buffer Cache Simulator to Study and Predict Cache Behavior for Query Execution
SN - 978-989-758-193-9
AU - Phalak, C.
AU - Singhal, R.
AU - Jhunjhunwala, T.
PY - 2016
SP - 71
EP - 78
DO - 10.5220/0005936800710078

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.