Method and system for synchronizing a server and an on-demand database service

• US 9,244,995 B2
• Filed: 05/12/2014
• Issued: 01/26/2016
• Est. Priority Date: 10/02/2006
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Salmon, Greg, Hopkins, Chris, Verma, Anant, Collins, Jesse, Weissman, Craig
• Primary Examiner(s): DANG, THANH HA T
• Application Number:
  US14/275,777
• Publication Number:
  US 20140250065A1
• Time in Patent Office: 624 Days
• Field of Search: 707/610, 707/612, 707/620, 707/623
• US Class Current: 1/1
• CPC Class Codes: G06F 16/178 Techniques for file synchronisation in file systems
• 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: H04L 67/1095 Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
• CPC Class Codes: H04L 67/1097 for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]

Abstract

In accordance with embodiments, there are provided mechanisms and methods for synchronizing a server and an on-demand database service. These mechanisms and methods for synchronizing a server and an on-demand database service can enable embodiments to synchronize a larger amount of data. The ability of embodiments to provide such feature can enable more effective synchronization of a user-level sharing entity database with a multi-user on-demand database service.

Claims

1. A method, comprising:

receiving a request to update data of a user of a system, the data of the user being stored by the system;

in response to the request, identifying, by the system, data relevant to the user that is stored by a server separate from the system;

utilizing a data structure stored on a non-transitory computer readable storage medium of the system to determine, by the system, a portion of the data stored by the server and identified as relevant to the user that is different from the data of the user that is stored by the system, the data structure including a plurality of user identifiers each identifying one of a plurality of users of the system and a plurality of data identifiers each correlated with at least one of the user identifiers and identifying data accessible to the user associated with the correlated user identifier; and

updating, by the system, the data of the user stored by the system with the portion of the data stored by the server and identified as relevant to the user that is determined to be different from the data of the user that is stored by the system.

2. The method of claim 1, wherein the data structure includes a first table.

3. The method of claim 2, wherein a second table includes the data identifiers each correlated with corresponding data.

4. The method of claim 3, wherein the second table is used in conjunction with the first table for accessing the data using the user identifiers.

5. The method of claim 1, wherein the first server includes a user-level sharing entity.

6. The method of claim 1, wherein the system includes a multi-tenant database system.

7. The method of claim 1, wherein the server is a mail server and the identified data stored by the mail server that is relevant to the user includes contact information.

8. A non-transitory machine-readable 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 a request to update data of a user of a system, the data of the user being stored by the system;

in response to the request, identifying, by the system, data relevant to the user that is stored by a server separate from the system;

utilizing a data structure stored on a non-transitory computer readable storage medium of the system to determine, by the system, a portion of the data stored by the server and identified as relevant to the user that is different from the data of the user that is stored by the system, the data structure including a plurality of user identifiers each identifying one of a plurality of users of the system and a plurality of data identifiers each correlated with at least one of the user identifiers and identifying data accessible to the user associated with the correlated user identifier; and

updating, by the system, the data of the user stored by the system with the portion of the data stored by the server and identified as relevant to the user that is determined to be different from the data of the user that is stored by the system.

9. An apparatus, comprising:

a processor of a system; and

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

receiving a request to update data of a user of the system, the data of the user being stored by the system;

in response to the request, identifying, by the system, data relevant to the user that is stored by a server separate from the system;

utilizing a data structure stored on a non-transitory computer readable storage medium of the system to determine, by the system, a portion of the data stored by the server and identified as relevant to the user that is different from the data of the user that is stored by the system, the data structure including a plurality of user identifiers each identifying one of a plurality of users of the system and a plurality of data identifiers each correlated with at least one of the user identifiers and identifying data accessible to the user associated with the correlated user identifier; and

updating, by the system, the data of the user stored by the system with the portion of the data stored by the server and identified as relevant to the user that is determined to be different from the data of the user that is stored by the system.