| 主权项 |
1. A system predicting effect of cache on query elapsed response time during an application development stage, the system comprising:
a processor; and a memory coupled to the processor, wherein the processor executes a plurality of modules stored in the memory, and wherein the plurality of module comprise:
a classification module to classify a query executed on a database to obtain a query type, wherein the query is classified based on a database access pattern of the query along with a relation between one or more keys associated with the query, wherein the key refers to one or more columns referred to in the query;a determination module to:
collect one or more database statistics with respect to the query type, wherein the database statistics refers to at least one data distribution pattern in the database and at least one data access pattern of the query inside the database; anddetermine one or more cache miss factors by using the database statistics, wherein the one or more cache miss factors predicts number of access of the cache by the query not found in the database cache;a calculation module to calculate one or more time components associated with processing of the query in the database with respect to the one or more cache miss factors; anda prediction module o predict the query elapsed response time by using the one or more time related values for varying size of the database. |
