DATA CACHING FOR MOBILE APPLICATIONS

• US 20110161290A1
• Filed: 04/14/2010
• Published: 06/30/2011
• Est. Priority Date: 12/30/2009
• Status: Active Grant

• Current Assignee: Sybase Incorporated (SAP SE)
• Original Assignee: Sybase Incorporated (SAP SE)
• Inventors: Lorenz, Brian Keith, Ireland, Evan Peter, WATERMAN, Lance, Ho, Michael, Pandya, Hemal
• Granted Patent: US 8,788,458 B2
• Time in Patent Office: Days
• US Class Current: 707/621
• 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/278 Data partitioning, e.g. horizontal or vertical partitioning
• CPC Class Codes: G06F 16/9574 of access to content, e.g. by caching
• CPC Class Codes: Y10S 707/9994 Distributed or remote access

Abstract

Systems, methods, computer program product embodiments and combinations and sub-combinations thereof for data caching and cache synchronization are described herein. An embodiment includes comparing data in a cache with data stored at a data source and determining database operations needed to synchronize one or more partitions of the cache with the data source. Each cache partition is associated with mobile business object (MBO) metadata of a distinct mobile device and the determined database operations are executed to synchronize the partitions with the data source. By refreshing only those partitions which are pertinent to a given device, embodiments of the invention may increase parallelism by allowing multiple partitions to refresh concurrently. The embodiment further comprises reviewing a caching policy associated with the cache. The caching policy may be selected in a manner that reduces data traffic and redundant requests on the data source.

Claims

1. A computer implemented method for cache synchronization, comprising:

comparing data in a cache with data stored at a data source;

determining database operations needed to synchronize one or more partitions of said cache with said data source, wherein each partition is associated with mobile business object (MBO) metadata of a distinct mobile device; and

executing said database operations to synchronize said partitions with said data source.

2. The method of claim 1, further comprising:

updating a timestamp associated with synchronized data in said cache.

3. The method of claim 1, further comprising:

reviewing a caching policy associated with said cache.

4. The method of claim 1, further comprising:

reviewing a pre-defined caching schedule; and

updating data in said cache based on said caching schedule.

5. The method of claim 1, further comprising:

assigning data in said cache to a coherence window;

reviewing said coherence window when said data in said cache is accessed; and

updating data in said cache based on said coherence window.

6. The method of claim 1, further comprising:

receiving an event notification; and

updating data in said cache based on said notification,

wherein said event notification is generated based on manipulation of data in said data source.

7. The method of claim 1, further comprising:

determining key-sorted contents of said cache;

determining key-sorted contents of said data source;

comparing key-sorted contents of said cache and said data source; and

determining modified contents of said cache.

8. The method of claim 1, further comprising:

(a) updating a row in a cache table in said cache;

(b) updating a timestamp associated with said row; and

(c) updating a marker identifying step (a).

9. The method of claim 1, further comprising:

invoking a data request to said data source; and

retrieving a plurality of data rows from said data source.

10. A computer-based system for caching of data, comprising:

a caching module configured to;

compare data in a cache with data stored at a data source;

determine database operations needed to synchronize one or more partitions of said cache with said data source, wherein each partition is associated with mobile business object (MBO) metadata of a distinct mobile device; and

execute said database operations to synchronize said partitions with said data source.

11. The system of claim 10, wherein said cache further comprises:

a plurality of cache tables configured to store data retrieved from said data source.

12. An article of manufacture including a computer-readable medium having instructions stored thereon that, if executed by a computing device, cause said computing device to perform operations comprising:

comparing data in a cache with data stored at a data source;

determining database operations needed to synchronize one or more partitions of said cache with said data source, wherein each partition is associated with mobile business object (MBO) metadata of a distinct mobile device; and

executing said database operations to synchronize said partitions with said data source.

13. The article of manufacture of claim 12, said operations further comprising:

updating a timestamp associated with synchronized data in said cache.

14. The article of manufacture of claim 12, said operations further comprising:

reviewing a caching policy associated with said cache.

15. The article of manufacture of claim 12, said operations further comprising:

reviewing a pre-defined caching schedule; and

updating data in said cache based on said caching schedule.

16. The article of manufacture of claim 12, said operations further comprising:

assigning data in said cache to a coherence window;

reviewing said coherence window when said data in said cache is accessed; and

updating data in said cache based on said coherence window.

17. The article of manufacture of claim 12, said operations further comprising:

receiving an event notification; and

updating data in said cache based on said notification,

wherein said event notification is generated based on manipulation of data in said data source.

18. The article of manufacture of claim 12, said operations further comprising:

determining key-sorted contents of said cache;

determining key-sorted contents of said data source;

comparing key-sorted contents of said cache and said data source; and

determining modified contents of said cache.

19. The article of manufacture of claim 12, said operations further comprising:

(a) updating a row in a cache table in said cache;

(b) updating a timestamp associated with said row; and

(c) updating a marker identifying step (a).

20. The article of manufacture of claim 12, said operations further comprising:

invoking a data request to said data source; and

retrieving a plurality of data rows from said data source.