Automating sharing data between users of a multi-tenant database service

• US 8,407,205 B2
• Filed: 09/11/2009
• Issued: 03/26/2013
• Est. Priority Date: 09/11/2008
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Doshi, Kedar, Wu, Yongsheng
• Primary Examiner(s): Ly, Anh
• Application Number:
  US12/557,797
• Publication Number:
  US 20100063959A1
• Time in Patent Office: 1,292 Days
• Field of Search: 707/618, 707/609, 707/610, 707/781, 707/793, 707/E17.005, 707/704, 707/E17.007
• US Class Current: 707/710
• 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 computer implemented 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; and

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;

wherein the automatically sharing the data record includes updating a second database object of the second subscriber to include a copy of the data record;

wherein the automatically sharing data includes;

(a) synchronizing the copy of the data record in the second database object with the data record of the first database object; and

(b) sending a notification to the second subscriber, and sharing the data record responsive to an indication of acceptance from the second subscriber; and

wherein the 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.

2. The computer implemented method of claim 1, 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.

3. A computer implemented 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;

wherein the automatically sharing data includes;

(a) synchronizing the copy of the data record in the database object of the second subscriber with the data record of the first subscriber; and

(b) sending a notification to the second subscriber, and sharing the data record responsive to an indication of acceptance from the second subscriber; and

wherein the 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.

4. The computer implemented method of claim 3, wherein sharing includes updating a sharing table that includes pointers to records stored in relation to pointers to subscribers.

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

6. 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;

wherein the computer readable medium includes instructions to synchronize the copy of the data record in the second database object with the data record of the first database object; and

wherein the instructions to automatically share include instructions to;

update a second database object of the second subscriber to include a copy of the data record; and

send a notification to the second subscriber, and to share the data record responsive to an indication of acceptance from the second subscriber; and

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.

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

8. The computer readable medium of claim 6, 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.

9. 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; and

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;

wherein the automatically sharing the data record includes updating a second database object of the second subscriber to include a copy of the data record;

wherein the control logic includes control logic, which when executed, causes the server to;

(a) synchronize the copy of the data record in the second database object with the data record of the first database object; and

(b) send a notification to the second subscriber, and sharing the data record responsive to an indication of acceptance from the second subscriber; and

wherein the 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.