System and Method to Predict Elapsed Response Time for a Query during Application Development Stage

摘要

A system, method and computer program product to predict elapsed response time of a query during an application stage is disclosed. The query is executed over a database and is classified based on a mode of access of the database by the query. The database is emulated to obtain an emulated database. After classification, an access pattern of the database by the query along with one or more parameters is determined. By applying a classification specific technique over the access pattern and the one or more parameters, an input-access time of the query on the emulated database is then calculated to determine the elapsed response time of the query.

主权项

1. A system to predict elapsed response time for a query during an application development stage, the system comprising:
a processor; and a memory coupled to the processor, wherein the processor is capable of executing instructions within a plurality of modules stored in the memory, and wherein the plurality of modules comprises:
a query execution module configured to execute the query over a database;an emulation module configured to emulate the database in order to obtain an emulated database;a classification module configured to classify the query based upon a mode of access of the database by the query;a parameter determination module configured to determine an access pattern along with at least one parameter of the database, wherein the access pattern, the at least one parameter, and the query are sensitive to a size of the database; anda computational module configured to:
calculate an input-output access time of the query on the emulated database using a classification specific technique over the access pattern and the at least one parameter; anddetermine an elapsed response time of the query for the emulated database by using the input-output access time for a varying size of the database.