Business data access client for online/offline client use

• US 8,037,110 B2
• Filed: 12/27/2007
• Issued: 10/11/2011
• Est. Priority Date: 12/27/2007
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Tennisberg, Targo, Kapadia, Arshish, Raj, Kaushik, Sevilmis, Tarkan, Nazeeruddin, Mohammed, Paranthaman, Sundar, Koronthaly, David, Salgado, Rolando Jimenez
• Primary Examiner(s): AL HASHEMI, SANA A
• Application Number:
  US11/964,868
• Publication Number:
  US 20090171679A1
• Time in Patent Office: 1,384 Days
• Field of Search: 707/200, 707/688, 707/791, 707/793, 707/795, 707/802, 707/804
• US Class Current: 707/804
• CPC Class Codes: G06F 16/24552 Database cache management
• CPC Class Codes: G06Q 30/0281 Customer communication at a business location, e.g. providing product or service information, consulting

Abstract

Architecture for uninterrupted access to business data by enabling work on rich client machines to be stored in a local business data cache that is always available. A dispatching mechanism executes read/write requests against the local cache transparently to a client application, an automatic synchronization mechanism propagates changes bi-directionally when the client goes online and a live connection with the corresponding backend data source is available. A declarative data access model is employed based on operation stereotyping and grouping that enables client applications to transparently execute create, read, update, delete, query (CRUDQ) and association operations against the local cache as if executed against the actual business data source. The architecture supports the offline creation of entities and sets of related entities when the entity identifiers are generated by the business data source and offline navigation of entity associations when foreign keys are not present in the related entities.

Claims

1. A computer-implemented business system, comprising:

a client system for accessing business data in selectively one of an online mode or an offline mode;

a backend system for storing the business data;

a runtime component of the client system for enabling read/write access by a client application of the client system to the business data based on a declarative data access model;

a communications component of the client system for communicating access operations to the business data, stored on the backend system, in the online mode;

a cache component of the client system for storing at least a portion of the business data during an offline mode, to enable uninterrupted access to the business data on the client system; and

a processor operable to execute computer-executable instructions associated with at least one of the client system, the backend system, the runtime component, the communications component, or the cache component.

3. The system of claim 1 wherein the runtime component accesses the business data of the backend system via a mid-tier system.

4. The system of claim 1, wherein the runtime component includes a dispatcher component for executing data requests of the client application against the business data.

5. The system of claim 1, wherein the cache component further comprises a synchronization component for synchronization to the backend system during an online mode.

6. The system of claim 1, wherein the communications component includes a remoting system that allows client application CRUD and query operations to be applied against business data sources with restricted access.

10. The system of claim 5, wherein the synchronization component further comprises an automatic synchronization component for automatically bi-directionally synchronizing the portions of the business data to the backend system and changes in the business data of the backend system to the cache component.

11. The system of claim 5, further comprising a cache manager for managing a queue of pending changes and state of cached entities in the cache component.

12. The system of claim 5, wherein the declarative data access model enables the client to execute create, read, update, delete (CRUD) query and association operations against the portions of the business data of the cache component and the business data of the backend system.

13. The system of claim 5, further comprising a cache refresh and cleanup component for propagating changes in the business data from the backend system to the cache component and flushing unneeded business data from the cache component.

2. A computer-implemented method, comprising acts of:

accessing business data in selectively one of an online mode or an offline mode;

storing the business data on a backend system;

enabling read/write access by a client application to the business data based on a declarative data access model; and

communicating access operations to the business data stored on the backend system, in the online mode;

storing at least a portion of the business data during an offline mode, to enable uninterrupted access to the business data; and

utilizing a processor to execute instructions stored in memory to perform at least one of the acts of accessing, storing, enabling, communicating, or storing.

7. The method of claim 2, further comprising accessing the business data of the backend system via a mid-tier system.

8. The method of claim 2, further comprising executing data requests of the client application against the business data.

9. The method of claim 2, further comprising enabling client application CRUD and query operations to be applied against business data sources with restricted access.

14. The method of claim 8, further comprising synchronizing to the backend system during an online mode.

15. The method of claim 14, further comprising automatically bi-directionally synchronizing the portions of the business data to the backend system.

16. The method of claim 14, further comprising managing a queue of pending changes and state of cached entities.

17. The method of claim 14, further comprising enabling the client application to execute create, read, update, delete (CRUD) query and association operations against at least the portions of the business data.

18. The method of claim 14, further comprising propagating changes in the business data from the backend system and flushing unneeded business data.