CLOUD DATABASE SHARING

• US 20130031136A1
• Filed: 07/28/2011
• Published: 01/31/2013
• Est. Priority Date: 07/28/2011
• Status: Active Grant

• Current Assignee: International Business Machines Corporation, ServiceNow Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: SHAH, ANKUR B.
• Granted Patent: US 8,615,528 B2
• Time in Patent Office: Days
• US Class Current: 707/783
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06F 16/278 Data partitioning, e.g. horizontal or vertical partitioning
• CPC Class Codes: G06F 16/28 Databases characterised by their database models, e.g. relational or object models
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database

Abstract

A method, system and computer program product is provided achieving database sharing by providing an interface to contribute a database and a set of resources to a resource pool in a first cloud environment. The interface further allowing a user to input parameters identifying a database, a set of resources, a set of authorization credentials, and a sharing policy. The interface further comprising responsive to the user using the interface and providing the interface parameters which identify the database, the set of resources, the set of authorization credentials, and the sharing policy, adding the database, the set of resources, the set of authorization credentials, and the sharing policy to the database resource pool in the cloud environment, sharing the database, the set of resources, according to the sharing policy, and utilizing the set of authorization credentials.

Claims

1. A computer program product for achieving database sharing in a cloud, the computer program product comprising:

computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising;

computer readable program code configured to provide a first interface to contribute a first database and a first set of resources to a resource pool in a first cloud environment;

wherein the first interface allows a first user to input parameters identifying a first database, a set of resources, a set of authorization credentials, and a sharing policy;

computer readable program code configured such that responsive to the first user using the first interface and providing the first interface parameters which identify the first database, the set of resources, the set of authorization credentials, and the sharing policy, adding the first database, the set of resources, the set of authorization credentials, and the sharing policy to the database resource pool in the first cloud environment; and

the first cloud environment further configured for utilizing and sharing the first database, the set of resources, according to the sharing policy, and utilizing the set of authorization credentials.

2. The computer program product of claim 1, wherein the computer readable program code is configured to provide a consolidated view for a second database in a first virtual machine to a first application.

3. The computer program product of claim 1, wherein the computer readable program code is configured such that authentication and access to the first database is controlled by the cloud authentication.

4. The computer program product of claim 1, wherein the computer readable program code is configured such that;

responsive to a request for access to the first database by a second user, applying the sharing policy, and responsive to the sharing policy allowing a change for the second user, updating the access permissions to the first database for the second user.

5. The computer program product of claim 4, wherein the computer readable program code is also configured for allowing a predetermined action based on the second user and a condition.

6. The computer program product of claim 4, wherein the computer readable program code is also configured for the predetermined action based on a timeframe.

7. The computer program product according to claim 4, wherein the computer readable program code is also configured for the predetermined action based on information in a third database.

8. The computer program product of claim 6, wherein the computer readable program code is also configured to allow usage to the first database based on a current usage of the first database.

9. A method for achieving database sharing of an application in a cloud comprising:

providing a first interface to contribute a first database and a first set of resources to a resource pool in a first cloud environment;

the interface further comprising;

allowing a first user to input parameters identifying a first database, a set of resources, a set of authorization credentials, and a sharing policy;

responsive to the first user using the first interface and providing the first interface parameters which identify the first database, the set of resources, the set of authorization credentials, and the sharing policy, adding the first database, the set of resources, the set of authorization credentials, and the sharing policy to the database resource pool in the first cloud environment, sharing the first database, the set of resources, according to the sharing policy, and utilizing the set of authorization credentials.

10. The method of claim 9 further comprising:

providing a consolidated view for a second database in a first virtual machine to a first application

11. The method of claim 9, further comprising:

responsive to a request for access to the first database by a second user, applying the sharing policy, and responsive to the sharing policy allowing a change for the second user, updating the access permissions to the first database for the second user.

12. The method of claim 9, further comprising:

performing a predetermined action based on the second user and a condition.

13. The method of claim 10 further comprising:

performing the predetermined action based on a timeframe.

14. The method of claim 11 further comprising:

performing the predetermined action based on information in a third database.

15. A system for achieving database sharing of an application comprising:

a processor;

computer readable program code configured to provide a first interface allowing a first user to contribute a first database and a first set of resources to a resource pool in a first cloud environment;

wherein the first interface allows the first user to input a set of parameters,

the set of parameters identifying a first database, a set of resources, a set of authorization credentials, and a sharing policy;

computer readable program code configured such that responsive to the first user using the first interface and providing the first interface parameters which identify the first database, the set of resources, the set of authorization credentials, and the sharing policy, adding the first database, the set of resources, the set of authorization credentials, and the sharing policy to the database resource pool in the first cloud environment, and the first cloud environment further configured for utilizing and sharing the first database, the set of resources, according to the sharing policy, and utilizing the set of authorization credentials.

16. The system of claim 15 further comprising:

the system configured to provide a consolidated view for a second database in a first virtual machine to the first application.

17. The system of claim 15, further comprising:

the system is configured such that authentication and access to the first database is controlled by the cloud authentication.

18. The system of claim 15, further comprising:

the system is configured such that responsive to a request for access to the first database by a second user, applying the sharing policy, and responsive to the sharing policy allowing a change for the second user, updating the access permissions to the first database for the second user.

19. The system of claim 18 further comprising:

the system configured to perform the predetermined action based on a timeframe.

20. The system of claim 18 further comprising:

the system configured for making the predetermined action based on information in a third database.