Granted Patent B2

US 7,680,771 · App. 11/017,490 · Granted Mar 16, 2010

Assignee: International Business Machines Corporation

Abstract

Claims (36)

1. A centralized federation apparatus implemented on a processor and a memory, the centralized federation apparatus for provisioning database resources, the centralized federation apparatus comprising:

an analysis module that analyzes a database query stream from an application to a database instance in real time, the database instance comprising a logical representation of a database and returning a result set in response to a database query from the database query stream, the database comprising physical data stored on a storage device;

the analysis module further determines that the database query stream exhibits a predetermined performance attribute;

a provision module that assigns a database resource selected from the group consisting of a second database instance stored in computer readable memory, a database server, and a cache stored in computer readable memory in response to a determination that the database query stream exhibits the predetermined performance attribute;

a move module that transfers at least a portion of the database instance to the assigned database resource such that the transfer is transparent to a client, wherein the portion of the database instance comprises metadata and structural configuration data for operating one of the second database instance, the database server, and the cache defined by the assigned database resource; and

a query module that redirects one or more database queries from the database query stream to the assigned database resource, the assigned database resource assigned in response to a value for the predetermined performance attribute of the database query stream crossing a predetermined threshold.

2. The centralized federation apparatus of claim 1 , further comprising a queue module coupled to the move module, the queue module queueing at least one database query from the database query stream substantially concurrently with the transfer of the database instance.

3. The centralized federation apparatus of claim 1 , wherein the provision module further assigns the database resource locally to the centralized federation apparatus.

4. The centralized federation apparatus of claim 1 , wherein the provision module further assigning the database resource remotely from the centralized federation apparatus.

5. A system for provisioning database resources, the system comprising:

a first database resource having data;

an application that generates a database query to be submitted to the first database resource;

a centralized federation apparatus coupled between the first database resource and the application, the centralized federation apparatus provisioning a second database resource and redirecting the database query to the second database resource, the centralized federation apparatus comprising a processor and a memory;

an analysis module that analyzes a database query stream from an application to a database instance in real time the database instance comprising a logical representation of a database and returning a result set in response to a database query from the database query stream, the database comprising physical data stored on a storage device;

the analysis module further determines that the database query stream exhibits a predetermined performance attribute;

a provision module that assigns a database resource selected from the group consisting of a second database instance stored in computer readable memory, a database server, and a cache stored in computer readable memory in response to a determination that the database query stream exhibits the predetermined performance attribute;

a move module that transfers at least a portion of the database instance to the assigned database resource such that the transfer is transparent to a client, wherein the portion of the database instance comprises metadata and structural configuration data for operating one of the second database instance, the database server, and the cache defined by the assigned database resource;

a queue module coupled to the move module, the queue module that queues at least one database query from the database query stream substantially concurrently with the transfer of the database instance such that a database query failure is avoided and the transfer is transparent to a client; and

a query module that redirects one or more database queries from the database query stream to the assigned database resource, the assigned database resource assigned in response to a value for the predetermined performance attribute of the database query stream crossing a predetermined threshold.

6. The system of claim 5 , further comprising a patrol module coupled to the analysis module, the patrol module capturing a copy of at least one of the database queries in the database query stream.

7. The system of claim 6 , further comprising a cache module and a replication module coupled to the analysis module, the cache module determining a portion of the first database resource to be cached, the replication module caching the determined portion on the second database resource.

8. The system of claim 5 , further comprising a storage area network (SAN) to which the first and second database resources are coupled.

9. The system of claim 5 , further comprising a queue module coupled to the move module, the queue module queueing, at least one database query from the database query stream substantially concurrently with the transfer of the database instance.

10. The system of claim 5 , wherein the provision module further assigns the database resource locally to the centralized federation apparatus.

11. The system of claim 5 , wherein the provision module further assigns the database resource remotely from the centralized federation apparatus.

12. A computer implemented method for provisioning database resources, the method-comprising:

analyzing, by a centralized federation apparatus, a database query stream from an application to a database instance in real time, the database instance comprising a logical representation of a database and returning a result set in response to a database query from the database query stream, the database comprising physical data stored on a storage device;

determining, by the centralized federation apparatus, when the database query stream exhibits a predetermined performance attribute;

assigning, by the centralized federation apparatus, a database resource selected from the group consisting of a second database instance stored in computer readable memory, a database server, and a cache stored in computer readable memory in response to a determination that the database query stream exhibits the predetermined performance attribute;

replicating a portion of a database from the database instance to the assigned database resources;

transferring at least a portion of the database instance to the assigned database resource such that the transfer is transparent to a client, wherein the portion of the database instance comprises metadata and structural configuration data for operating one of the second database instance, the database server, and the cache defined by the assigned database resource; and

redirecting one or more database queries from the database query stream to the assigned database resource, the assigned database resource assigned in response to a value for the predetermined performance attribute of the database query stream crossing a predetermined threshold.

13. The method of claim 12 , further comprising updating the replicated data in a cache in response to an update to the database instance.

14. The method of claim 12 , further comprising determining the portion of the database instance to be replicated on the assigned database resource.

15. The method of claim 12 , wherein assigning further comprises assigning the database resource locally to the centralized federation apparatus.

16. The method of claim 12 , wherein assigning further comprises assigning the database resource remotely from the centralized federation apparatus.

Assignments (8)

Continuity (1)