Mechanism for synchronization of hierarchical data between a mobile device and multi tenant database

1. A method, comprising:

detecting, by a computing device, a conflict between data stored at the computing device and data stored at a service provider database system; and

performing, by the computing device, a synchronization operation to synchronize one or more objects within hierarchical object data stored at the computing device with hierarchical object data stored at the service provider database system, including:

determining relationship information between database records within one or more tables stored at the computing device;

determining a first database record in a first table that has been changed;

retrieving the first database record to be synchronized in response to determining that the first database record has been changed;

using the relationship information to retrieve a set of database records related to the first database record in response to determining that the first database record has been changed, the set of database records including at least a second database record of a second table, the first database record having a field referencing the second database record; and

transmitting, by the computing device to the service provider database system, a single message indicating one or more updates to the service provider database system, the message including an identifier of the first table, an identifier of the second table, one or more fields of the first database record, and one or more fields of the second database record.

2. The method of claim 1 , wherein the synchronization operation comprises a sync up operation to upload a hierarchy of objects from the computing device to the service provider database system in response to changes to the hierarchical object data stored at the computing device.

3. The method of claim 2 , wherein the sync up operation comprises determining changes made to the hierarchical object data stored at one or more tables within the computing device.

4. The method of claim 3 , wherein the synchronization operation comprises the computing device transmitting the hierarchical object data to the service provider database system.

5. The method of claim 4 wherein the transmitted hierarchical object data represent changes to one or more objects in the hierarchical object data at the service provider database.

6. The method of claim 4 , wherein the transmitted hierarchical object data is to leave intact changes to one or more objects in the hierarchical object data at the service provider database system.

7. The method of claim 2 , wherein the synchronization operation further comprises a sync down operation to download a hierarchy of objects from the service provider database system to the computing device in response to changes to the hierarchical object data stored at the service provider database system.

8. The method of claim 7 , wherein the sync down operation comprises determining changes made to the hierarchical object data stored at one or more tables within the service provider database system.

9. The method of claim 8 , wherein the synchronization operation comprises the computing device receiving one or more objects in the hierarchical object data that have been changed at the service provider database system.

10. The method of claim 8 , wherein the synchronization operation comprises the computing device receiving all hierarchical object data from the service provider database system.

11. A non-transitory computer-readable medium having stored there on instructions that, when executed by one or more processors, are configurable to cause the one or more processors to:

detect a conflict between data stored at a computing device and data stored at a service provider database system; and

perform a synchronization operation to synchronize one or more objects within hierarchical object data stored at the computing device with hierarchical object data stored at the service provider database system, including:

determining relationship information between database records within one or more tables stored at the computing device;

determining a first database record in a first table that has been changed;

retrieving the first database record to be synchronized in response to determining that the first database record has been changed;

using the relationship information to retrieve a set of database records related to the first database record in response to determining that the first database record has been changed, the set of database records including at least a second database record of a second table, the first database record having a field referencing the second database record; and

transmitting by the computing device to the service provider database system, a single message indicating one or more updates to the service provider database system, the message including an identifier of the first table, an identifier of the second table, one or more fields of the first database record, and one or more fields of the second database record.

12. The computer-readable medium of claim 11 , wherein the synchronization operation comprises a sync up operation to upload a hierarchy of objects from the computing device to the service provider database system in response to changes to the hierarchical object data stored at the computing device.

13. The computer-readable medium of claim 12 , wherein the sync up operation comprises determining changes made to the hierarchical object data stored at one or more tables within the computing device.

14. The computer-readable medium of claim 13 , wherein the synchronization operation comprises the computing device transmitting the hierarchical object data to the service provider database system.

15. The computer-readable medium of claim 14 , wherein the transmitted hierarchical object data represent changes to one or more objects in the hierarchical object data at the service provider database system.

16. The computer-readable medium of claim 15 , wherein the transmitted hierarchical object data is to leave intact changes to one or more objects in the hierarchical object data at the service provider database system.

17. The computer-readable medium of claim 12 , wherein the synchronization operation further comprises a sync down operation to download a hierarchy, of objects from the service provider database system to the computing device in response to changes to the hierarchical object data stored at the service provider database system.

18. The computer-readable medium of claim 17 , wherein the synchronization operation comprises the computing device receiving hierarchical object data from the service provider database system.

19. The computer-readable medium of claim 18 , wherein the synchronization operation comprises the computing device receiving one or more objects in the hierarchical object data that have been changed at the service provider database system.

20. The computer-readable medium of claim 18 , wherein the synchronization operation comprises the computing device receiving all hierarchical object data from the service provider database system.

21. A mobile device comprising:

one or more processors coupled with at least one memory device, the one ormore processors configurable to cause:

detecting a conflict between data stored at the mobile device and data stored at a service provider database system; and

performing a synchronization operation to synchronize one or more objects within hierarchical object data stored at the computing device with hierarchical object data stored at the service provider database system, including:

determining relationship information between database records within one or more tables stored at the computing device;

determining a first database record in a first table that has been changed;

retrieving the first database record to be synchronized in response to determining that the first database record has been changed;

using the relationship information to retrieve a set of database records related to the first database record in response to determining that the first database record has been changed, the set of database records including at least a second database record of a second table, the first database record having a field referencing the second database record; and

transmitting, by the computing device to the service provider database system, a single message indicating one or more updates to the service provider database system, the message including an identifier of the first table, an identifier of the second table, one or more fields of the first database record, and one or more fields of the second database record.

22. The mobile device of claim 21 , wherein the synchronization operation comprises a sync up operation to upload a hierarchy of objects from the mobile device to the service provider database system in response to changes to the hierarchical object data stored at the mobile device.

23. The mobile device of claim 22 , wherein the hierarchical object data comprises a plurality of objects, each object having a corresponding one of a plurality of object types.

24. The mobile device of claim 23 , wherein the hierarchical object data further comprises a table corresponding to each of a plurality of object types.

25. The mobile device of claim 24 , wherein each object comprises a first field to store a local identifier and a second field to store a remote identifier.

26. The mobile device of claim 22 , wherein the sync up operation comprises determining changes made to the hierarchical object data stored at one or more tables within the mobile device.

27. The mobile device of claim 26 , wherein the synchronization operation further comprises a sync down operation to download a hierarchy of objects from the service provider database system to the mobile device in response to changes to the hierarchical object data stored at the service provider database system.