SYSTEM AND METHOD FOR IMPLEMENTING ON DEMAND CLOUD DATABASE

• US 20120296866A1
• Filed: 07/31/2012
• Published: 11/22/2012
• Est. Priority Date: 08/19/2010
• Status: Abandoned Application

• Current Assignee: Infosys Limited
• Original Assignee: Infosys Technologies Limited (Infosys Limited)
• Inventors: DODDAVULA, Shyam Kumar, SINGH, Abhishek Pratap
• Application Number:
  US13/562,374
• Publication Number:
  US 20120296866A1
• Time in Patent Office: Days
• US Class Current: 707/609
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/278 Data partitioning, e.g. horizontal or vertical partitioning
• CPC Class Codes: G06F 2209/5019 Workload prediction
• CPC Class Codes: G06F 9/5083 Techniques for rebalancing the load in a distributed system

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.

Claims

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.