MESSAGE BASED SYNCHRONIZATION FOR MOBILE BUSINESS OBJECTS

• US 20110161349A1
• Filed: 06/10/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: IRELAND, Evan, Pandya, Hemal, Clegg, David, Ho, Michael, Zhang, Guo-ping
• Granted Patent: US 9,336,291 B2
• Time in Patent Office: Days
• US Class Current: 707/769
• 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

Abstract

A system, method, and computer program product are provided for executing a notification query derived from a download cursor for a business object to identify an updated subscription in order to provide updates to a client device in an import message. Additional systems, methods, and computer program products are provided for guaranteeing at-least-once delivery of a message.

Claims

1. A method comprising:

executing a notification query derived from a download cursor for a business object to identify an updated subscription;

running the download cursor against the updated subscription to generate result rows; and

sending the result rows to a client device in an import message.

2. The method of claim 1, further comprising:

generating a cache table for the business object, wherein the download cursor and notification query are run against the cache table.

3. The method of claim 1, further comprising:

updating a last download time for the updated subscription.

4. The method of claim 1, wherein the notification query is configured to determine the updated subscription based on identifying subscriptions which reference at least one updated entity.

5. The method of claim 1, further comprising:

creating a batch message comprising a set of import messages, comprising;

determining whether a buffer has additional room for a next import message from the set of import messages, and adding the next import message to the buffer if additional room exists;

repeating the determining step while additional room exists; and

sending the batch message.

6. The method of claim 1, further comprising:

sending a synchronization request to the client device.

7. A computer-readable medium having computer-executable instructions stored thereon that, if executed by a computing device, cause the computing device to perform a method comprising:

executing a notification query derived from a download cursor for a business object to identify an updated subscription;

running the download cursor against the updated subscription to generate result rows; and

sending the result rows to a client device in an import message.

8. The computer program product of claim 7, the method further comprising:

generating a cache table for the business object, wherein the download cursor and notification query are run against the cache table.

9. The computer program product of claim 7, the method further comprising:

updating a last download time for the updated subscription.

10. The computer program product of claim 7, wherein the notification query is configured to determine the updated subscription based on identifying subscriptions which reference at least one updated entity.

11. The computer program product of claim 7, the method further comprising:

creating a batch message comprising a set of import messages, comprising;

determining whether a buffer has additional room for a next import message from the set of import messages, and adding the next import message to the buffer if additional room exists;

repeating the determining step while additional room exists; and

sending the batch message.

12. The computer program product of claim 7, the method further comprising:

sending a synchronization request to the client device.

13. A system comprising:

a memory configured to store modules comprising;

an executing module configured to execute a notification query derived from a download cursor for a business object to identify an updated subscription,

a running module configured to run the download cursor against the updated subscription to generate result rows, and

a sending module configured to send the result rows to a client device in an import message; and

one or more processors configured to process the modules.

14. A method comprising:

receiving a message from a client, the message comprising a client identifier and a message identifier and a replay instruction;

searching a list of client identifier and message identifier pairs corresponding to previously received messages to determine whether the message corresponding to the client identifier and the message identifier has been previously received;

processing the message upon determination that the message has not been previously received; and

adding the client identifier and the message identifier to the list of client identifier and message identifier pairs corresponding to previously received messages.

15. The method of claim 14, further comprising:

replaying the replay instruction against an enterprise system.

16. The method of claim 14, wherein at-least-once delivery is guaranteed by sequential transmission of the message and application of the list of client identifier and message identifier pairs corresponding to previously received messages.

17. A computer-readable medium having computer-executable instructions stored thereon that, if executed by a computing device, cause the computing device to perform a method comprising:

receiving a message from a client, the message comprising a client identifier and a message identifier and a replay instruction;

searching a list of client identifier and message identifier pairs corresponding to previously received messages to determine whether the message corresponding to the client identifier and the message identifier has been previously received;

processing the message upon determination that the message has not been previously received; and

adding the client identifier and the message identifier to the list of client identifier and message identifier pairs corresponding to previously received messages.

18. The computer program product of claim 17, the method further comprising:

replaying the replay instruction against an enterprise system.

19. The computer program product of claim 17, wherein at-least-once delivery is guaranteed by sequential transmission of the message and application of the list of client identifier and message identifier pairs corresponding to previously received messages.

20. A system comprising:

a memory configured to store modules comprising;

a receiving module configured to receive a message from a client, the message comprising a client identifier and a message identifier and a replay instruction,

a searching module configured to search a list of client identifier and message identifier pairs corresponding to previously received messages to determine whether the message corresponding to the client identifier and the message identifier has been previously received,

processing the message upon determination that the message has not been previously received, and

an adding module configured to add the client identifier and the message identifier to the list of client identifier and message identifier pairs corresponding to previously received messages; and

one or more processors configured to process the modules.