Apparatus, system, and method for database provisioning

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.

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.