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 to be executed on a production database, 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 in order to collect database statistics;an emulation module configured to emulate the database statistics in order to obtain an emulated database, wherein the database statistics are emulated based on a production database;a classification module configured to classify the query into at least one of a full table scan query, a fast index scan query, a primary index scan query, and a non-unique index scan query, and wherein the query is classified based upon a mode of accessing the emulated database by the query;a parameter determination module configured to determine an access pattern along with at least one parameter of the emulated database, wherein the access pattern, the at least one parameter, and the query are sensitive to size of the emulated database; anda computational module configured to
calculate an input-output access time of the query executed on the emulated database based on
a classification specific technique corresponding to the at least one of the full table scan query, the fast index scan query, the primary index scan query, and the non-unique index scan query, andthe at least one parameter; anddetermine an elapsed response time of the query to be executed on a production database based on addition of the input-output access time and a linearly extrapolated CPU time.