Apparatus, system, and method for database provisioning

• US 7,680,771 B2
• Filed: 12/20/2004
• Issued: 03/16/2010
• Est. Priority Date: 12/20/2004
• Status: Active Grant

• Current Assignee: X Corp. (f/k/a Twitter, Inc.) (X Holdings Corp.)
• Original Assignee: International Business Machines Corporation
• Inventors: Luniewski, Allen William, Myers Haas, Laura, Zeller, Hansjorg, Cialini, Enzo, Iyer, Balakrishna Raghavendra, Subrahmonia, Jayashree, Wadia, Noshir Cavas
• Primary Examiner(s): Ali; Mohammad
• Assistant Examiner(s): Darno; Patrick A
• Application Number:
  US11/017,490
• Publication Number:
  US 20060136448A1
• Time in Patent Office: 1,912 Days
• Field of Search: 707 3- 4, 707/5
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

An apparatus, system, and method are disclosed for provisioning database resource within a grid database system. The apparatus comprises an analysis module and a provision module. The analysis module analyzes a data query stream from an application to a database instance and determines that 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, a database server, or a cache. The provisioning of the new database resource advantageously is substantially transparent to a client on the database system.

Claims

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.