Online propagation of data updates

• US 8,515,929 B2
• Filed: 06/05/2006
• Issued: 08/20/2013
• Est. Priority Date: 06/05/2006
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Goulko, Igor, Rubinshtein, Galina, Schejter, Marjorie, Segev, Uri
• Primary Examiner(s): Btit, Jacob F
• Assistant Examiner(s): Hocker, John P
• Application Number:
  US11/422,203
• Publication Number:
  US 20070282790A1
• Time in Patent Office: 2,633 Days
• Field of Search: 707/705, 707/781
• US Class Current: 707/705
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing

Abstract

A method for online propagation of data updates, the method including initiating a record update process for any of a plurality of records in a system responsive to a modification of a trigger data item, where the process is performed while the system is online, creating an update process timestamp indicating a time at which the record update process is begun, and determining if a last-modified timestamp associated with any of the records indicates an eariler time than the update process timestamp, and, if so updating the record to reflect the modification to the trigger data item, and modifying the last-modified timestamp to reflect a time that is later than the update process timestamp.

Claims

1. A method for online propagation of data updates, the method comprising:

initiating a record update process for any of a plurality of records in a system responsive to a modification of a trigger data item, wherein the process is performed while the system is online;

creating an update process timestamp indicating a time at which the record update process is begun; and

determining if a last-modified timestamp associated with any of the records indicates an earlier time than the update process timestamp, and, if so

updating the record to reflect the modification to the trigger data item, wherein update priority is given to all of the records associated with a user who logs into a computer system after the record update process has begun on the computer system; and

modifying the last-modified timestamp to reflect a time that is later than the update process timestamp.

2. A method according to claim 1 wherein the determining step comprises determining where the last-modified timestamp is maintained for an entire database in which any of the records reside, indicating the last time that any of the records in the database was modified.

3. A method according to claim 2 wherein the updating step comprises updating all records in the database that are affected by the modification to the trigger data item if the database'"'"'s last-modified timestamp indicates an earlier time than the update process timestamp.

4. A method according to claim 2 wherein the modifying step comprises modifying the database'"'"'s last-modified timestamp.

5. A method according to claim 1 wherein a request to modify any of the records that is received after the record update process has begun is withheld until after the record has been updated.

6. A method according to claim 1 wherein a request to modify any of the records that is received after the record update process has begun is withheld until after the record update process has finished.

7. A method according to claim 1 and further comprising sending any of the following notifications:

a notification informing a user that any of the records to which the user has access is about to be updated;

a notification informing a user that any of the records to which the user has access has been updated; and

a notification describing the nature of an update to any of the records.