Logical Level Predictive Caching in Relational Databases

摘要

A system, method, and computer-readable medium for performing a predictive caching operation in which a hit rate is improved by pre executing statements that are predicted based upon previous use patterns. More specifically, by analyzing a stream of statements provided to a server, such as a database server, patterns of usage are detected and based upon these patterns, statements provided to the server are executed before the actual application executes the predicted statements. Thus the application executes faster because the data requested is already cached based upon the predictive execution.

主权项

1. A computer-implementable method for performing a predictive caching operation, comprising:
analyzing a stream of statements provided to a database server, determining patterns of usage within the stream of statements; and, predictively pre executing statements on the database server based upon the patterns of usage within the stream of statements so as to improve performance of the server when executing the stream of statements by pre executing statements that are predicted based upon previous use patterns.