Abstract: Methods and systems are described according to the present invention for result set caching that include receiving an informational database request and determining whether a result set corresponding to the informational database request is stored in a cache. If the result set is stored in the cache, the result set is returned in response to the informational database request. If the result set is not stored in the cache, then the informational database request is sent to a database for processing. A determination is then made whether to add the result set to the cache, where the determination is based at least in part on the cache-worthiness of the result set. According to another aspect of the present invention, a desired level of data freshness is achieved by determining whether a database request is transactional, and if so, invalidating those result sets stored in the cache that include data targeted by the transactional database request.

Abstract: A system and method for selecting database objects to be stored in a cache based on the cache-worthiness of the objects. The technique collects cache-worthiness data for a plurality of objects in a database, determines a cache-worthiness value using the collected data for each of the plurality of objects, and selects one or more of the plurality of objects to be stored in the cache, wherein the objects are selected using the values.

Abstract: The present invention provides for a system and method for delivering dynamic content to a client coupled to a network, wherein the client sends a request for the dynamic content to an origin site. The origin site is coupled to the network and also has access to a database. According to the present invention, a plurality of caches are coupled to the network, wherein each cache includes replicated data from the database and application logic to generate the dynamic content using the replicated data. A router redirects the client from the origin site to a cache selected from the plurality of caches, wherein the selected cache provides the dynamic content to the client.