Apparatus, system, and method for database provisioning
First Claim
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.
5 Assignments
0 Petitions
Accused Products
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.
-
Citations
16 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. - View Dependent Claims (2, 3, 4)
-
-
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. - View Dependent Claims (6, 7, 8, 9, 10, 11)
-
-
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. - View Dependent Claims (13, 14, 15, 16)
-
Specification