System and method for implementing on demand cloud database

Abstract

A method for dynamic management of one or more cloud database nodes is provided. The method enables gathering information related to usage of one or more cloud database nodes. The method further enables comparing time required by the one or more cloud database nodes for responding to one or more requests with a predetermined threshold. Furthermore, the method enables provisioning one or more new cloud database nodes or removing one or more new cloud database nodes based on at least one of: the gathered information, the comparison and a combination thereof.

1 . A method for dynamic management of one or more cloud database nodes, the method comprising:
 gathering information related to usage of one or more cloud database nodes;   comparing time required by the one or more cloud database nodes for responding to one or more requests with a predetermined threshold; and   provisioning one or more new cloud database nodes or removing one or more new cloud database nodes based on at least one of: the gathered information, the comparison and a combination thereof.   
     
     
         2 . The method of  claim 1 , wherein gathering information related to usage of one or more cloud database nodes comprises:
 gathering information on current usage of one or more cloud database nodes; and   gathering information on future usage of one or more cloud database nodes.   
     
     
         3 . The method of  claim 2 , wherein the current usage information comprises at least one of: number of entities stored in the one or more cloud database nodes and number of requests received at the one or more cloud database nodes. 
     
     
         4 . The method of  claim 2 , wherein the future usage information comprises at least one of: number of entities expected to be stored in the one or more cloud database nodes and number of requests expected to be received at the one or more cloud database nodes. 
     
     
         5 . The method of  claim 1 , wherein comparing time required by the cloud database nodes for responding to one or more requests with a predetermined threshold comprises determining if time required for responding to one or more requests by the cloud database nodes is less than a predetermined threshold. 
     
     
         6 . The method of  claim 5 , wherein provisioning one or more cloud database nodes based on the gathered information, comparison and combination thereof comprises adding one or more cloud database node instances using a cloud provider application API. 
     
     
         7 . The method of  claim 1 , wherein comparing time required by the cloud database nodes for responding to one or more requests with a predetermined threshold comprises determining if time required for responding to one or more requests by the cloud database nodes is more than the predetermined threshold. 
     
     
         8 . The method of  claim 7 , wherein removing one or more cloud database nodes based on the gathered information, comparison and combination thereof comprises deleting one or more cloud database node instances using a cloud provider application API. 
     
     
         9 . The method of  claim 1 , wherein comparing time required by the cloud database nodes for responding to one or more requests with a predetermined threshold comprises determining if time required for responding to one or more requests by the cloud database nodes is equal to the predetermined threshold. 
     
     
         10 . The method of  claim 1 , wherein the predetermined threshold comprises at least one of: response time threshold, throughput threshold and resource utilization threshold. 
     
     
         11 . The method of  claim 1 , wherein the one or more cloud database nodes comprise cloud database node instances and cloud database server instances. 
     
     
         12 . The method of  claim 1  further comprising updating a routing module with information related to the provisioning or removal of one or more cloud database nodes. 
     
     
         13 . The method of  claim 1  further comprising repartitioning entities across provisioned and existing cloud database node instances, wherein the repartitioning ascertains even distribution of entities across the node instances. 
     
     
         14 . The method of  claim 1  further comprising replicating entities across provisioned and existing cloud database node instances. 
     
     
         15 . The method of  claim 1  further comprising versioning entities across provisioned and existing cloud database node instances. 
     
     
         16 . A system for dynamic management of one or more cloud database nodes, the system comprising:
 a cloud database management console configured to facilitate a user to at least in part gather information related to usage of one or more cloud database node instances and to monitor response time of services provided by the one or more cloud database node instances; and   a cloud infrastructure module configured to facilitate provisioning or removal of one or more cloud database node instances using the cloud database management console.   
     
     
         17 . The system of  claim 16 , wherein the cloud database management console comprises a web based user interface configured to receive one or more requests. 
     
     
         18 . The system of  claim 16 , wherein the cloud database management console comprises one or more software modules configured to facilitate addition and/or deletion of one or more cloud database node instances using a cloud provider Application Programming Interface (API). 
     
     
         19 . A computer program product for dynamic management of one or more cloud database nodes, the computer program product comprising:
 program instruction means for gathering information related to usage of one or more cloud database nodes;   program instruction means for comparing time required by the one or more cloud database nodes for responding to one or more requests with a predetermined threshold; and   program instruction means for provisioning one or more new cloud database nodes or removing one or more new cloud database nodes based on at least one of: the gathered information, the comparison and a combination thereof.