We are currently experiencing intermittent issues impacting performance. We apologize for the inconvenience.
By Topic

A Framework for Predicting Query Response Time

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

1 Author(s)
Singhal, R. ; TCS Innovation Lab., Mumbai, India

In a typical OLTP environment, emphasis has been given on promising Service level Agreements (SLAs) for perceived query elapsed response time; the SQL queries are tested on the small size of database which may be a fraction of the production database. As time progresses the database grows and the earlier optimized queries may not hold SLA anymore. Once the application is deployed, it becomes difficult to modify the application or alter the production system. In this paper, we have discussed a framework for predicting the SQL query response time with growth of the database while being transparent to the production hardware, storage subsystem and DB Server. We have discussed various factors which can impact query response time and are also affected by the increase in the data size. We have presented a theoretical model for predicting the elapsed response time of SQL queries and also discussed a case study of Oracle lOg for implementing the proposed framework.

Published in:

High Performance Computing and Communication & 2012 IEEE 9th International Conference on Embedded Software and Systems (HPCC-ICESS), 2012 IEEE 14th International Conference on

Date of Conference:

25-27 June 2012