AUTOMATING SHARING DATA BETWEEN USERS OF A MULTI-TENANT DATABASE SERVICE

• US 20100063959A1
• Filed: 09/11/2009
• Published: 03/11/2010
• Est. Priority Date: 09/11/2008
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Wu, Yongsheng, Doshi, Kedar
• Granted Patent: US 8,407,205 B2
• Time in Patent Office: Days
• US Class Current: 707/618
• 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

Systems, methods, and apparatus for automating sharing data between subscribers of a multi-tenant database service. Users or customers associated with one organization that is a tenant of the multi-tenant database system are enabled to share data objects such as leads, opportunities, accounts, contacts, cases, tasks and custom objects, (or other data objects) and other information with their business partners (e.g., users or customers associated with a different organization that is a tenant) and get real-time updates on the shared data.

Claims

1. A method for automatically sharing data between subscribers to a multi-tenant database service, the method comprising:

receiving a specification of at least one sharing rule from a first subscriber to a multi-tenant on-demand database service, the first subscriber being associated with a first organization that shares database resources of the multi-tenant on-demand database service with a second organization;

automatically evaluating the sharing rule to identify whether a data record of a first data object accessible to the first subscriber is to be shared with a second subscriber of the second organization that does not have access to the data record; and

if so

automatically sharing the data record with the second subscriber.

2. The method of claim 1, wherein sharing includes updating a sharing table that includes pointers to records stored in relation to pointers to subscribers.

3. The method of claim 1, wherein sharing includes updating a second database object of the second subscriber to include a copy of the data record.

4. The method of claim 3, further including synchronizing the copy of the data record in the second database object with the data record of the first database object.

5. The method of claim 4, wherein synchronizing includes automatically updating the copy of the data record in the second database object responsive to the data record of the first database object being modified by the first subscriber.

6. The method of claim 4, wherein synchronizing includes automatically updating the copy of the data record in the second database object responsive to the data record being modified in the first database object in response to a workflow rule, or a trigger.

7. The method of claim 1, wherein automatically sharing includes sending a notification to the second subscriber, and sharing the data record responsive to an indication of acceptance from the second subscriber.

8. A method for automatically sharing data between subscribers to a multi-tenant database service, the method comprising:

receiving a request to share data of a first subscriber to an on demand database service with at least one second subscriber to the on-demand database service, the request including at least one rule, wherein the first subscriber and second subscriber do not share access to the others data;

automatically determining whether a data record accessible by the first subscriber is to be shared with the second subscriber based at least in part on application of the at least one rule; and

if so

automatically sharing the data record of the first subscriber with the at least one second subscriber.

9. The method of claim 8, wherein sharing includes updating a sharing table that includes pointers to records stored in relation to pointers to subscribers.

10. The method of claim 8, wherein sharing includes updating a database object of the second subscriber to include a copy of the data record.

11. The method of claim 10, further including synchronizing the copy of the data record in the database object of the second subscriber with the data record of the first subscriber.

12. The method of claim 11, wherein synchronizing includes automatically updating the copy of the data record in the database object of the second subscriber responsive to the data record of the first subscriber being modified by the first subscriber.

13. The method of claim 11, wherein synchronizing includes automatically updating the copy of the data record in the database object of the second subscriber responsive to the data record of the first subscriber being modified in response to a workflow rule, or a trigger.

14. The method of claim 8, wherein automatically sharing includes sending a notification to the second subscriber, and sharing the data record responsive to an indication of acceptance from the second subscriber.

15. A tangible computer readable medium that stores code for automatically sharing data between subscribers to a multi-tenant database service, the code including instructions, implemented by one or more processors, to:

receive a specification of at least one sharing rule from a first subscriber to a multi-tenant on-demand database service, the first subscriber being associated with a first organization that shares database resources of the multi-tenant on-demand database service with a second organization;

automatically evaluate the sharing rule to identify whether a data record of a first data object accessible to the first subscriber is to be shared with a second subscriber of the second organization that does not have access to the data record; and

if so

automatically share the data record with the second subscriber.

16. The computer readable medium of claim 15, wherein the instructions to share include instructions to update a sharing table that includes pointers to records stored in relation to pointers to subscribers.

17. The computer readable medium of claim 15, wherein the instructions to share include instructions to update a second database object of the second subscriber to include a copy of the data record.

18. The computer readable medium of claim 17, further including instructions to synchronize the copy of the data record in the second database object with the data record of the first database object.

19. The computer readable medium of claim 18, wherein the instructions to synchronize include instructions to automatically update the copy of the data record in the second database object responsive to the data record of the first database object being modified by the first subscriber.

20. The computer readable medium of claim 18, wherein the instructions to synchronize include instructions to automatically update the copy of the data record in the second database object responsive to the data record being modified in the first database object in response to a workflow rule, or a trigger.

21. The computer readable medium of claim 15, wherein the instructions to automatically share include instructions to send a notification to the second subscriber, and to share the data record responsive to an indication of acceptance from the second subscriber.

22. A multi-tenant on demand database system, comprising;

a database that stores database objects for a plurality of organizations/tenants, wherein users of each tenant only have access to data base objects associated with that tenant; and

a server configured with control logic, which when executed, causes the server to;

receive a specification of at least one sharing rule from a first subscriber to a multi-tenant on-demand database service, the first subscriber being associated with a first organization that shares database resources of the multi-tenant on-demand database service with a second organization;

automatically evaluate the sharing rule to identify whether a data record of a first data object accessible to the first subscriber is to be shared with a second subscriber of the second organization that does not have access to the data record; and

if so

automatically share the data record with the second subscriber.