Method and system for sharing data between subscribers of a multi-tenant database service

• US 8,577,835 B2
• Filed: 06/24/2008
• Issued: 11/05/2013
• Est. Priority Date: 06/28/2007
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Doshi, Kedar, Kuruganti, Aditya, Bhatt, Chaitanya
• Primary Examiner(s): Uddin, Mohammed R
• Application Number:
  US12/145,325
• Publication Number:
  US 20090030906A1
• Time in Patent Office: 1,960 Days
• Field of Search: 707/608, 707/622, 707/999.009
• US Class Current: 707/608
• 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

Abstract

In accordance with embodiments, there are provided mechanisms and methods for sharing data among subscribers of a multi-tenant database service. These mechanisms and methods for sharing data among subscribers of a multi-tenant database service can enable embodiments to providing controlled, limited sharing between the subscribers regardless of the physical location of the subscriber data. The ability of embodiments to provide such additional sharing capabilities may lead to more secure sharing of data within a multi-tenant on-demand database service.

Claims

1. A method for sharing of a first tenant'"'"'s data objects with a second tenant, the first and second tenants using logically distinct parts of a shared multi-tenant database, the method including:

receiving from a first tenant an offer to establish a connection and share data with a second tenant, wherein first data objects are stored in the first tenant'"'"'s logical part of the multi-tenant database system;

receiving from the second tenant an acceptance of the connection with the first tenant;

recording the connection between the first tenant and the second tenant and publishing the first data objects to the second tenant for subscription;

receiving from the second tenant a subscription to at least a subset of the first data objects; and

copying the subscribed first data objects into subscribed second data objects in the second tenant'"'"'s logical part of the shared multi-tenant database, responsive to the subscription.

2. The method of claim 1, wherein the offer is communicated by the first tenant by sending an electronic message to the second tenant.

3. The method of claim 2, wherein the offer is accepted by the second tenant utilizing the electronic message.

4. The method of claim 3, wherein the offer is accepted by the second tenant by selecting a link in the electronic message.

5. The method of claim 1, wherein it is determined whether the offer is actually from the first tenant by authenticating the first tenant.

6. The method of claim 1, wherein different data of the first tenant is shared with different other tenants.

7. The method of claim 1, wherein the sharing of the data of the first tenant with the second tenant is enabled by the first tenant publishing the data.

8. The method of claim 7, wherein the first tenant publishes the data by selecting the data utilizing a graphical user interface.

9. The method of claim 7, wherein the sharing of the data of the first tenant with the second tenant is enabled by the at least one second tenant subscribing to at least a portion of the data.

10. The method of claim 9, wherein the at least one second tenant subscribes to the data by selecting the at least a portion of the data utilizing a graphical user interface.

11. The method of claim 9, wherein the second tenant subscribes only to a subset of the data.

12. The method of claim 1, wherein the data is shared between the first tenant and the second tenant automatically based on at least one rule.

13. The method of claim 12, wherein the at least one rule defines related data that is automatically shared.

14. The method of claim 1, wherein the sharing of the data of the first tenant with the second tenant is enabled by synchronizing the data.

15. The method of claim 1, further comprising in response to a determination that the request is accepted by the at least one second subscriber, writing an indication of the acceptance of the request and an established connection to a connection table accessible to the first subscriber and the at least one second subscriber, wherein the connection table stores security information for the first subscriber and the at least one second subscriber for access by both of the first subscriber and the at least one second subscriber.

16. The method of claim 1, further including:

monitoring updates to at least the subscribed first data objects; and

copying updates to the subscribed first data objects into the subscribed second data objects.

17. The method of claim 1, wherein the multi-tenant database is an on-demand database.

18. The method of claim 17, further including the on-demand database storing the first data objects and the second data objects single multi-tenant physical table.

19. A non-transitory machine-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to carry out the steps of:

receiving from a first tenant an offer to establish a connection and share data with a second tenant, wherein first data objects are stored in the first tenant'"'"'s logical part of the multi-tenant database system;

receiving from the second tenant an acceptance of the connection with the first tenant;

recording the connection between the first tenant and the second tenant and publishing the first data objects to the second tenant for subscription;

receiving from the second tenant a subscription to at least a subset of the first data objects; and

copying the subscribed first data objects into subscribed second data objects in the second tenant'"'"'s logical part of the shared multi-tenant database, responsive to the subscription.

20. The non-transitory machine-readable storage medium of claim 19, further including:

monitoring updates to at least the subscribed first data objects; and

copying updates to the subscribed first data objects into the subscribed second data objects.

21. The non-transitory machine-readable storage medium of claim 19, wherein the multi-tenant database is an on-demand database.

22. The non-transitory machine-readable storage medium of claim 21, further including the on-demand database storing the first data objects and the second data objects in a single multi-tenant physical table.

23. An apparatus, comprising:

a processor; and

one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of;

receiving from a first tenant an offer to establish a connection and share data with a second tenant, wherein first data objects are stored in the first tenant'"'"'s logical part of the multi-tenant database system;

receiving from the second tenant an acceptance of the connection with the first tenant;

recording the connection between the first tenant and the second tenant and publishing the first data objects to the second tenant for subscription;

receiving from the second tenant a subscription to at least a subset of the first data objects; and

copying the subscribed first data objects into subscribed second data objects in the second tenant'"'"'s logical part of the shared multi-tenant database, responsive to the subscription.

24. The apparatus of claim 23, further including:

monitoring updates to at least the subscribed first data objects; and

copying updates to the subscribed first data objects into the subscribed second data objects.

25. The apparatus of claim 23, wherein the multi-tenant database is an on-demand database.

26. The apparatus of claim 25, further including the on-demand database storing the first data objects and the second data objects single multi-tenant physical table.