Online propagation of data updates

• US 9,405,785 B2
• Filed: 07/12/2013
• Issued: 08/02/2016
• 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): Kerzhner, Aleksandr
• Assistant Examiner(s): ELLIS, MATTHEW J
• Application Number:
  US13/940,897
• Publication Number:
  US 20130304696A1
• Time in Patent Office: 1,117 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing

Abstract

Various embodiments include a system for online propagation of data updates. The system can include: a computer system for storing a plurality of records; and a record update utility configured to: initiate a record update process for any of the records responsive to a modification of a trigger data item, wherein the process is performed while the system is online; create an update process timestamp indicating a time at which the record update process is begun; and determine if a last-modified timestamp associated with any of the records indicates an earlier time than the update process timestamp, and, if so: update the record to reflect the modification to the trigger data item, and modify the last-modified timestamp to reflect a time that is later than the update process timestamp.

Claims

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

a computer system for storing a plurality of records; and

a record update utility configured to;

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

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

determine if a last-modified timestamp associated with any of the records indicates an earlier time than the update process timestamp, and, in response to the determination that the last-modified timestamp indicates an earlier time than the update process timestamp;

update 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 the computer system after the record update process has begun on the computer system; and

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

2. The system according to claim 1, wherein 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. The system according to claim 2, wherein the record update utility is configured to update all records in the database that are affected by the modification to the trigger data item in response to determining that the database'"'"'s last-modified timestamp indicates an earlier time than the update process timestamp.

4. The system 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.

5. The system 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.

6. The system according to claim 1, wherein the record update utility is configured to send 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.

7. A computer-implemented program embodied on a non-transitory computer-readable storage medium, the computer program comprising:

a code segment operative to initiate 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;

a code segment operative to create an update process timestamp indicating a time at which the record update process is begun; and

a code segment operative to determine if a last-modified timestamp associated with any of the records indicates an earlier time than the update process timestamp, and, in response to the determination that the last-modified timestamp indicates an earlier time than the update process timestamp;

update 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 the computer system after the record update process has begun on the computer system; and

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

8. The computer-implemented program according to claim 7, wherein 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, and wherein the record update utility is configured to update all records in the database that are affected by the modification to the trigger data item in response to determining that the database'"'"'s last-modified timestamp indicates an earlier time than the update process timestamp.

9. The computer-implemented program according to claim 7, 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.

10. The computer-implemented program according to claim 7, 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.

11. The computer-implemented program according to claim 7, wherein the record update utility is configured to send 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.

12. A system for online propagation of data updates, the system comprising:

a record update utility configured to;

initiate a record update process for any of the 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;

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

determine if a last-modified timestamp associated with any of the records indicates an earlier time than the update process timestamp, and, in response to the determination that the last-modified timestamp indicates an earlier time than the update process timestamp;

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.

13. The system according to claim 12, wherein the determining includes 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.

14. The system according to claim 13, wherein the updating includes updating all records in the database that are affected by the modification to the trigger data item in response to determining that the database'"'"'s last-modified timestamp indicates an earlier time than the update process timestamp.