METHOD AND SYSTEM FOR MANAGING RECENT DATA IN A MOBILE DEVICE LINKED TO AN ON-DEMAND SERVICE

• US 20100088316A1
• Filed: 05/04/2009
• Published: 04/08/2010
• Est. Priority Date: 05/02/2008
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Robinson, Larry, Forsberg, Erik
• Granted Patent: US 8,645,376 B2
• Time in Patent Office: Days
• US Class Current: 707/737
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• 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: G06F 16/285 Clustering or classification
• CPC Class Codes: H04L 67/289 Intermediate processing functionally located close to the data consumer application, e.g. in same machine, in same home or in same sub-network
• CPC Class Codes: H04L 67/306 User profiles
• CPC Class Codes: H04L 67/55 Push-based network services
• CPC Class Codes: H04L 67/5681 Pre-fetching or pre-delivering data based on network characteristics
• CPC Class Codes: H04L 67/5682 Policies or rules for updating, deleting or replacing the stored data

Abstract

Systems and methods for managing recent data items in a database. A method typically includes determining whether a data object managed by an on demand service is designated as able to be accessed by a user at a mobile device and storing locally at a mobile device a plurality of most recently used items viewed for a data object designated as able to be accessed by a user at a mobile device. The method also typically includes determining a single most recently used set from among the stored plurality of most recently used items viewed for at least one data object designated as able to be accessed by a user at a mobile device.

Claims

1. A method of managing data stored on a mobile device in remote communication with an on-demand database system, comprising:

determining whether a first data object managed by an on demand system is designated as able to be accessed by a user of a mobile device;

determining a first set of data items from the first data object based on user-defined criteria;

determining a set of one or more most recently used (MRU) data items for the first data object, the MRU data items including data items that have been recently viewed by a user of the mobile device; and

storing locally at the mobile device a second set of data items from the first data object, the second set including data items from the first set of data items and from the MRU data items.

2. The method of claim 1, further comprising:

updating the MRU data items in a server component of the on demand service to reflect the most recently used set for the mobile device.

3. The method of claim 2, wherein the server component includes a middle tier server.

4. The method of claim 1, wherein the MRU items are determined based on timestamp field values associated with data items of the first data object.

5. The method of claim 1, wherein determining a first set of data items includes filtering data items in the first data object based on the user defined criteria.

6. The method of claim 1, wherein the steps of determining are performed in one or more components of the on demand database system remote from the mobile device.

7. The method of claim 6, wherein storing include periodically synchronizing data between the mobile device and the on demand database service so that the on demand service is updated with information about data items that have been recently viewed by the user on the mobile device.

8. The method of claim 1, further including periodically truncating a portion of the MRU data items in the second set stored at the mobile device.

9. The method of claim 8, wherein the portion truncated includes less than about 30% of the MRU data items as determined by timestamp values associated with the MRU data items.

10. The method of claim 1, further including displaying at least a portion of the second set of data items on the mobile device, wherein the MRU data items and first set of data items are merged together when displayed.

11. A method of managing data stored on a mobile device in remote communication with an on-demand database system, comprising:

determining a plurality of data objects managed by an on demand service that are designated as able to be accessed by a user of a mobile device;

determining a first set of data items from the plurality of designated data objects based on user-defined criteria;

determining one or more of most recently used (MRU) data items viewed for the plurality of designated data objects by a user of the mobile device; and

storing locally at the mobile device a second set of items from the designated plurality of data objects, the second set including data items from the first set of data items and from the MRU data items.

12. The method of claim 11, further comprising:

updating the MRU data items in a server component of the on demand service to reflect the most recently used set for the mobile device.

13. The method of claim 12, wherein the server component includes a middle tier server.

14. The method of claim 11, wherein the MRU items are determined based on timestamp field values associated with data items of the designated data objects.

15. The method of claim 11, wherein determining a first set of data items includes filtering data items in the designated data objects based on the user defined criteria.

16. The method of claim 11, wherein the steps of determining are performed in one or more components of the on demand database system remote from the mobile device.

17. The method of claim 16, wherein storing includes periodically synchronizing data between the mobile device and the on demand database system so that the on demand system is updated with information about data items that have been recently viewed by the user on the mobile device.

18. The method of claim 11, further including periodically truncating a portion of the MRU data items in the second set stored at the mobile device.

19. The method of claim 18, wherein the portion truncated includes less than about 30% of the MRU data items as determined by timestamp values associated with the MRU data items.

20. The method of claim 11, further including displaying at least a portion of the second set of data items on the mobile device, wherein the MRU data items and first set of data items are merged together when displayed.

21. An on demand database system, comprising:

a database service include database storage that stores a plurality of data objects accessible by a plurality of users;

a mobile device that communicates remotely with a component of the database service; and

one or more logic modules executing on one or more components of the database service, the logic module(s) being configured to;

determine a plurality of data objects managed by the database service that are designated as able to be accessed by a user of the mobile device;

determine a first set of data items from the plurality of designated data objects based on user-defined criteria;

determine one or more of most recently used (MRU) data items viewed for the plurality of designated data objects by the user of the mobile device; and

send data to the mobile device identifying a second set of data items for storing locally at the mobile device, the second set including data items from the first set of data items and from the MRU data items.

22. The system of claim 21, wherein the logic module(s) are further configured to update the MRU data items in a server component of the database service to reflect the most recently used set for the mobile device. tier server.

23. The system of claim 22, wherein the server component includes a middle tier server.

24. The system of claim 21, wherein the MRU items are determined based on timestamp field values associated with data items of the first data object.

25. The system of claim 21, wherein determining a first set of data items includes filtering data items in the first data object based on the user defined criteria.

26. The system of claim 21, wherein the one or more components of the on demand database system are remote from the mobile device.

27. The system of claim 26, wherein the mobile device and the on demand database service periodically synchronizes with the database service so that the on demand system is updated with information about data items that have been recently viewed by the user on the mobile device.

28. The system of claim 21, wherein the logic module(s) are further configured to periodically truncate a portion of the MRU data items in the second set stored at the mobile device.

29. The system of claim 28, wherein the portion truncated includes less than about 30% of the MRU data items as determined by timestamp values associated with the MRU data items.

30. The system of claim 21, wherein the mobile device is configured to display at least a portion of the second set of data items on the mobile device, wherein the MRU data items and first set of data items are merged together when displayed.