摘要 |
Disclosed is a system for predicting an Elapsed Response Time (ERT) of a query to be executed in a production database. A db emulator module for creating an emulated database based on empty schema derived by extrapolating statistical information from the development environment. An execution plan generation module for generating a query execution plan of the query. A query classifying module for classifying each sub-query based on the operational parameters into at least one of a full table scan, a primary index scan, a fast index scan and a non-unique index scan. A time determination module for executing each sub-query on the emulated database to determine an Input Output (IO) access time and an operator time. An ERT prediction module for predicting the ERT of the query to be executed in the production database based on the IO access time, the operator time, and a network time. SYSTEM (102) PROCESSOR(S) (202) INTERFACE(S) (204) MEMORY (206) MODULES (208) DB EMULATOR MODULE (212) EXECUTION PLAN GENERATION MODULE (214) QUERY CLASSIFYING MODULE (216) TIME DETERMINATION MODULE (218) ERT PREDICTION MODULE (220) BENCHMARK AGENT MODULE (222) OTHER MODULES (224) DATA (210) EMULATED DATABASE (226) TEST DATABASE (227) OTHER DATA (228) Figure 2 |