Methods and systems for managing distributed concurrent data updates of business objects

• US 9,411,844 B2
• Filed: 03/29/2013
• Issued: 08/09/2016
• Est. Priority Date: 03/29/2012
• Status: Active Grant

• Current Assignee: TraceLink Incorporated
• Original Assignee: TraceLink Incorporated
• Inventors: Leckband, Craig, Spellman, Peter J., Wellington, Sean A.
• Primary Examiner(s): Reyes, Mariela
• Assistant Examiner(s): VU, THONG H
• Application Number:
  US13/853,530
• Publication Number:
  US 20130262376A1
• Time in Patent Office: 1,229 Days
• Field of Search: 707/609, 707/200, 707/100, 707/797, 707/803, 707/608, 711/150
• US Class Current: 1/1
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/2336 Pessimistic concurrency control approaches, e.g. locking or multiple versions without time stamps
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/245 Query processing

Abstract

A computer-implemented method and system for distributed concurrent data updating of a business object having a structured format.

Claims

1. A computer-implemented method, performed by a client computer system, for distributed concurrent data updating of a business object having a structured format, the method comprising:

retrieving a stored business object from an object repository accessible by a plurality of client computer systems, said stored business object divided into a plurality of subsections based on semantics of the stored business object, each subsection of the plurality of subsections including a sentry having a given value based on content in the subsection, the given value of the sentry for the subsection computed by concatenating the content in the subsection as a string, and obtaining a hash value from the concatenated string;

modifying content in one or more subsections of the retrieved stored business object to form a modified business object;

acquiring a lock on the stored business object in the object repository;

for each subsection of the modified business object;

comparing the value of the sentry for a subsection of the modified business object to a value of the sentry in the corresponding subsection of the retrieved stored business object;

signaling a conflict when the values of the compared sentries are different;

determining whether the subsection has been changed in the modified business object when the values of the compared sentries are the same;

computing a new value for the sentry for the subsection, and updating the modified business object to include the new value of the sentry for the subsection when the subsection of the modified business object has been determined to have been changed; and

storing the modified business object in the object repository.

2. The method of claim 1, further comprising signaling a conflict when the values of the compared sentries are different and the subsection has been changed in the modified business object.

3. The method of claim 1, further comprising signaling a conflict when the values of the compared entries are different and the subsection has been changed in the modified business object, and using the corresponding subsection from the stored business object in the modified business object when the subsection has not been changed in the modified business object.

4. The method of claim 1, wherein the business object has a structured file representation.

5. The method of claim 4, wherein the structured file representation comprises XML.

6. The method of claim 1, wherein the value for each sentry is computed by calculating a checksum using contents of fields in a subsection being protected by the sentry.

7. The method of claim 1, wherein storing the modified business object in the repository comprises merging each subsection of the modified business object into the stored business object in the repository.

8. The method of claim 1, wherein the stored business object is retrieved from an object repository through a collaborative workspace environment.

9. The method of claim 1, wherein each subsection includes one or more fields that can be modified.

10. A computer-implemented method, performed by a client computer system, for distributed concurrent data updating of a business object having a structured file representation, the method comprising:

retrieving a stored business object from an object repository accessible by a plurality of client computer systems, said stored business object divided into a plurality of subsections based on semantics of the stored business object, each subsection of the plurality of subsections including a sentry having a given value based on content in the subsection, the given value of the sentry for the subsection computed by concatenating the content in the subsection as a string, and obtaining a hash value from the concatenated string;

modifying content in one or more subsections of the retrieved stored business object to form a modified business object;

determining whether the stored business object was changed by another client computer system since the stored business object was retrieved;

signaling a conflict when the stored business object is determined to have been changed; and

when the stored business object is determined not to have been changed, for each subsection in the modified business object;

determining whether the subsection was modified,

when the subsection is determined to have been modified, computing a new value for the sentry for that subsection and updating the value for the sentry in the modified business object;

and storing the modified business object in the object repository.

11. The method of claim 10, further comprising:

acquiring a lock on the stored business object in the object repository; and

comparing the value of the sentry for each subsection of the modified business object to a value of the sentry in the corresponding subsection of the retrieved stored business object.

12. The method of claim 10, wherein the structured file representation comprises XML.

13. The method of claim 10, wherein the value for each sentry is computed by calculating a checksum using contents of fields in a subsection being protected by the sentry.

14. The method of claim 10, wherein storing the modified business object in the repository comprises merging each subsection of the modified business object into the stored business object in the repository.

15. The method of claim 10, wherein the stored business object is retrieved from the object repository through a collaborative workspace environment.

16. The method of claim 10, wherein the business object comprises one of a purchase order, a work order, a material order, forecast information, quality information, inventory disposition information, inventory movement information, and product serialization information.