Membership tracking and data eviction in mobile middleware scenarios

• US 8,200,624 B2
• Filed: 07/20/2010
• Issued: 06/12/2012
• Est. Priority Date: 07/20/2010
• Status: Active Grant

• Current Assignee: Sybase Incorporated (SAP SE)
• Original Assignee: Sybase Incorporated (SAP SE)
• Inventors: Clegg, David, Ireland, Evan, Balakrishnan, Harikrishnan, Pandya, Hemal, Alberti, Johannes
• Primary Examiner(s): DANG, THANH HA T
• Application Number:
  US12/839,843
• Publication Number:
  US 20120023067A1
• Time in Patent Office: 693 Days
• Field of Search: 707/609, 707/610, 707/611, 707/791, 707/829, 707/955, 707/956, 707/960
• US Class Current: 707/610
• 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: Y10S 707/956 Hierarchical
• CPC Class Codes: Y10S 707/96 Object-relational

Abstract

Systems, methods, and computer program products are provided for ensuring coherency between user data in a client and their corresponding state in enterprise information systems (EIS) wherein data migrates and subscriptions change over time. A mobile business object (MBO) identifies an update to a subscription or a change in set membership in order to provide updates to a client device and EIS systems. Cached data is filtered for client device users who synchronize data they are interested in (i.e., subscribed to). In an embodiment, the method keeps track of set membership by remembering on a per remote identifier/business object basis the set membership for a parent business object. When set membership changes, the method sends delete notifications to the device to remove ex-members. The method recognizes common relationship types in a business scenario and handles reference-type relationships as well as containment-type relationships. The methods include key tracking and membership tracking.

Claims

1. A method comprising:

mapping native attributes for a mobile business object (MBO) to a relational structure;

building a list of unique surrogate keys that should currently be part of a subscription for a client, wherein the surrogate keys include values to be used by the client to account for an inability to access a key creation process, and wherein the list includes child mobile business objects (MBOs) referenced by parent MBOs that are expected to be on the client upon completion of a synchronization;

determining a set of deleted surrogate keys that the client currently has that are no longer in the list of unique surrogate keys that should currently be part of the subscription;

removing the deleted surrogate keys for the client from a client device database;

updating a surrogate key list the client is expected to have, wherein the updating comprises;

for surrogate keys the client already has, doing nothing; and

for each new surrogate key the client does not yet have;

inserting a row in the surrogate key list; and

setting a timestamp indicating when the new surrogate key first became part of what the client is expected to have.

2. The method of claim 1, wherein the building further comprises storing the list of unique surrogate keys in a temporary table, and wherein the method further comprises, after the updating:

cleaning up the temporary table.

3. The method of claim 1, wherein the mapping is performed by middleware.

4. The method of claim 1, wherein the mapping is based upon the subscription for the client.

5. The method of claim 4, wherein the subscription for the client indicates interest in one or more members of a set.

6. The method of claim 5, wherein the subscription for the client indicates interest in members of a set related to a geographic region.

7. The method of claim 1, further comprising:

repeating the determining step while additional surrogate keys need to be deleted.

8. The method of claim 1, wherein the building further comprises:

determining whether the client should have an MBO based on one or more of;

the client has an explicit pull query subscription on the MBO;

or

the MBO is the child of a relationship of another MBO for which the client has a subscription.

9. The method of claim 1, further comprising:

creating a download delete cursor for the client for the set of deleted surrogate keys.

10. The method of claim 2, wherein the set of deleted surrogate keys are stored in a second temporary table.

11. The method of claim 1, wherein the removing and the updating are part of database transactions that can be rolled back in response to determining that a subsequent data synchronization fails.

12. A non-transitory computer-readable medium having computer-executable instructions stored thereon that, in response to execution by a computing device, cause the computing device to perform a method comprising:

mapping native attributes for a mobile business object (MBO) to a relational structure;

building a list of unique surrogate keys that should currently be part of a subscription for a client, wherein the surrogate keys include values to be used by the client to account for an inability to access a key creation process, and wherein the list includes child mobile business objects (MBOs) referenced by parent MBOs that are expected to be on the client upon completion of a synchronization;

determining a set of deleted surrogate keys the client currently has that are no longer in the list of unique surrogate keys that should currently be part of the subscription;

removing the deleted surrogate keys for the client from a client device database;

updating a surrogate key list the client is expected to have, wherein the updating comprises;

for surrogate keys the client already has, doing nothing; and

for each new surrogate key the client does not yet have;

inserting a row in the surrogate key list; and

setting a timestamp indicating when the new surrogate key first became part of what the client is expected to have.

13. A system comprising:

a memory configured to store modules comprising;

a mapping module configured to map native attributes for a mobile business object (MBO) to a relational structure;

a building module configured to build a list of unique surrogate keys that should currently be part of a subscription for a client, wherein the surrogate keys include values to be used by the client to account for an inability to access a key creation process, and wherein the list includes child mobile business objects (MBOs) referenced by parent MBOs that are expected to be on the client upon completion of a synchronization;

a determining module configured to determine a set of deleted surrogate keys the client currently has that are no longer in the list of unique surrogate keys that should currently be part of the subscription;

an eviction module configured to remove the deleted surrogate keys for the client from a client device database;

an upsert module configured to update a surrogate key list the client is expected to have, wherein the upsert module is further configured to, for each new surrogate key the client does not yet have;

insert a row in the surrogate key list; and

set a timestamp indicating when the new surrogate key first became part of what the client is expected to have.

14. A method for synchronizing data updates between a mobile client device and an enterprise information system (EIS), the method comprising:

detecting an update to a subscription for a mobile client device or a change in set membership for a mobile business object (MBO);

building a surrogate key list of globally unique surrogate keys that should currently be part of the subscription, wherein the surrogate keys include values to be used by the mobile client device to account for an inability to access a key creation process, and wherein the surrogate key list includes child mobile business objects (MBOs) referenced by the MBO that are expected to be on the mobile client device upon completion of a synchronization;

filtering cached EIS data for a user associated with the mobile client device, wherein the filtering selects a subset of the cached EIS data to which the mobile client device is subscribed;

in response to detecting an eviction of a member from a set;

sending a delete notification to the mobile client device to remove the evicted member; and

updating a row in the surrogate key list corresponding to the evicted member to indicate that data associated with the surrogate key is not expected to be on the mobile client device; and

in response to detecting a change to or addition of a member in a set;

sending an upsert notification to the mobile client device to update the changed or added member;

updating a row in the surrogate key list corresponding to the changed or added member to indicate that the data associated with the surrogate key is expected to be on the mobile client device; and

setting a timestamp in the surrogate key list indicating when data associated with the surrogate key first became a part of the subscription data that the mobile client device is expected to have.

15. The method of claim 14, wherein the detecting further comprises:

detecting a change in set membership for a parent of the MBO.