Abstract: Various embodiments of a computer-implemented method, system and computer program product maintain a cache in a distributed environment comprising a front-end server and a back-end server. One or more data sources are accessible to the back-end server. The front-end server and the back-end server support a first query language having more functionality than a second query language supported by a replication component. The data of the front-end cache is described at the front-end server using said first query language. A shadow cache that matches the front-end cache is created at the back-end server. The back-end server changes data in the shadow cache in response to changes in at least a portion of the data in one or more data sources. Data is replicated between the shadow cache and the front-end cache. The data that is replicated from the shadow cache to the front-end cache is described using the second query language.

Abstract: An apparatus, system, and method are disclosed for provisioning database resource within a grid database system. The federation apparatus includes an analysis module and a provision module. The analysis module analyzes a data query stream from an application to a database instance and determines if the data query stream exhibits a predetermined performance attribute. The provision module provisions a database resource in response to a determination that the data query stream exhibits the predetermined performance attribute. The provisioned database resource may be a database instance or a cache. The provisioning of the new database resource advantageously is substantially transparent to a client on the database system.