Method and system for managing recent data in a mobile device linked to an on-demand service

• US 10,402,382 B2
• Filed: 01/11/2016
• Issued: 09/03/2019
• Est. Priority Date: 12/02/2005
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Robinson, Larry, Forsberg, Erik
• Primary Examiner(s): Gofman, Alex
• Application Number:
  US14/992,933
• Publication Number:
  US 20160125002A1
• Time in Patent Office: 1,331 Days
• Field of Search: None
• 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, including:

determining whether a user of the mobile device has permission to access a first data object managed by the on-demand database system;

determining that a most recently used set of data items at the mobile device is modified by the user within a threshold time period;

updating most recently used (MRU) data items in the on-demand database system to reflect the modified most recently used set based at least in part on adding or modifying data items from the modified most recently used set;

selecting, at the on-demand database system, data items from the first data object to form a first set of data items for potential inclusion on the mobile device, the selecting of the data items being based at least in part on a user-defined criteria filter;

selecting, at the on-demand database system, a set of one or more of the MRU data items for the first data object for potential inclusion on the mobile device, the selected set of the one or more MRU data items being selected based at least in part on activity with the MRU data items by the user;

selecting, at the on-demand database system, a second set of data items from the first data object based at least in part on each of the second set of data items being designated as able to be mobilized; and

transmitting the second set of data items for local storage at the mobile device, the second set of data items including data items from the first set of data items and from the set of one or more of the MRU data items, and excluding one or more data items that are designated as not able to be mobilized.

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

3. The method of claim 1, wherein the selecting of the data items from the first data object includes filtering data items in the first data object based on the user-defined criteria filter.

4. The method of claim 1, wherein the storing includes periodically synchronizing data between the mobile device and the on-demand database system so that the on-demand database system is updated with information about data items that have recent activity by the user on the mobile device.

5. The method of claim 1,

wherein the storing includes periodically truncating a portion of the set of one or more of the MRU data items from the second set of data items, and

wherein the truncated portion includes less than about 30% of the set of one or more of the MRU data items as determined by timestamp values associated with the set of one or more of the MRU data items.

6. 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 set of one or more of the MRU data items and the first set of data items are merged together when displayed.

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

determining access permission for a user of the mobile device to a plurality of data objects that are managed by the on-demand database system;

determining that a most recently used set of data items at the mobile device is modified by the user within a threshold time period;

updating most recently used (MRU) data items in the on-demand database system to reflect the modified most recently used set based at least in part on adding or modifying data items from the modified most recently used set;

selecting, at the on-demand database system, data items from the plurality of data objects to form a first set of data items for potential inclusion on the mobile device, the selecting of the data items being based at least in part on a user-defined criteria filter;

selecting, at the on-demand database system, one or more of the MRU data items for potential inclusion on the mobile device, the selected one or more MRU data items being based at least in part on activity with the plurality of data objects by the user;

selecting, at the on-demand database system, a second set of data items from the first data object based at least in part on each of the second set of data items being designated as able to be mobilized; and

transmitting the second set of items for local storage at the mobile device, the second set of items including data items from the first set of data items and from one or more of the MRU data items, and periodically truncating a portion of the one or more of MRU data items from the second set of items.

8. The method of claim 7, wherein the MRU data items are determined based on timestamp field values associated with data items of the plurality of data objects.

9. The method of claim 7, wherein the selecting of the data items from the plurality of data objects includes filtering data items in the plurality of data objects based on the user-defined criteria.

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

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

12. The method of claim 7, wherein the truncated portion includes less than about 30% of the one or more MRU data items as determined by timestamp values associated with the one or more MRU data items.

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

determining whether a user of the mobile device has permission to access a first data object managed by the on-demand database system;

determining that a most recently used set of data items at the mobile device is modified by the user within a threshold time period;

updating most recently used (MRU) data items in the on-demand database system to reflect the modified most recently used set based at least in part on adding or modifying data items from the modified most recently used set;

selecting, at the on-demand database system, data items from first data object to form a first set of data items for potential inclusion on the mobile device, the selecting of the data items being based at least in part on a user-defined criteria filter using a database index;

searching, at the on-demand database system, a cached set of the MRU data items that includes data items that are awaiting indexing and selecting a set of one or more of the data items that are awaiting indexing based at least in part on activity with the cached set of the MRU data items by the user;

selecting, at the on-demand database system, a second set of data items from the first data object based at least in part on each of the second set of data items being designated as able to be mobilized; and

transmitting the second set of items for local storage at the mobile device, the second set of items including data items from the first set of data items and from the selected set of one or more of the data items that are awaiting indexing, and excluding one or more data items that are designated as not able to be mobilized.

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

15. The method of claim 13, wherein the selecting of the data items from the first data object includes filtering data items in the first data object based on the user-defined criteria filter.

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

17. The method of claim 13,

wherein the storing includes periodically truncating a portion of the cached set of the MRU data items from the second set of data items, and

wherein the truncated portion includes less than about 30% of the cached set of the MRU data items as determined by timestamp values associated with the cached set of the MRU data items.

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

19. The method of claim 13, wherein the second set of data items is pushed to the mobile device by the on-demand database system prior to being stored locally at the mobile device.