System for updating a database

• US 20030135480A1
• Filed: 12/03/2002
• Published: 07/17/2003
• Est. Priority Date: 01/14/2002
• Status: Abandoned Application

• Current Assignee: Siemens Medical Solutions Health Services Corporation (Siemens AG)
• Original Assignee: Siemens Medical Solutions Health Services Corporation (Siemens AG)
• Inventors: Tellup, Michael E., Van Arsdale, Robert S., Parrish, David G.
• Application Number:
  US10/308,686
• Publication Number:
  US 20030135480A1
• Time in Patent Office: Days
• US Class Current: 707/1
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

A method converts data in a database from a current value to a different replacement value. The method receives information identifying a database data field to be updated and data including a current value and a corresponding replacement value for replacing existing data in the identified data field. The method examines the database to determine whether the data field is associated with a trigger for initiating amendment of a database element upon alteration of the data field content, and/or an index used for locating said data field. The method disables a trigger and an index when identified by the examination. The method replaces existing data in the data field with the received replacement value. The method verifies successful replacement of the data field current value.

Claims

1. A method for converting data in a database from a current value to a different replacement value, comprising the steps of:

receiving information identifying a database data field to be updated and data comprising a current value and corresponding replacement value for replacing existing data in said identified data field;

examining said database to determine whether said data field is associated with at least one of,

(a) a trigger for initiating amendment of a database element upon alteration of said data field content, and

(b) an index used for locating said data field;

disabling a trigger and an index when identified by said examination;

replacing said existing data in said data field with said received replacement value; and

verifying successful replacement of said data field current value.

2. A method according to claim 1, including the step of:

restoring a disabled trigger and index, in response to replacement of said data field current value.

3. A method according to claim 1, including the step of:

comparing said existing data in said identified data field with said received current value and replacing said existing data in said data field with said received replacement value in response to a substantial match between said existing data and said received current value.

4. A method according to claim 1, including the steps of:

identifying a plurality of additional data fields containing data of similar data type as said data in said identified data field based on at least one of, (a) a data type synonym search and (b) use of a data field cross-reference map, and

replacing existing data in said plurality of additional data fields with received replacement values.

5. A method according to claim 4, wherein

said data fields comprise different database table columns of data, and

said cross-reference map identifies whether a database table column is used in another location in said database.

6. A method according to claim 4, wherein

said step of replacing existing data in said plurality of additional data fields is responsive to a parameter identifying at least one of, (a) a number of data field rows to be replaced, (b) a maximum number of database tables to be processed and (c) a status indicator identifying a status of a database.

7. A method according to claim 4, including the step of:

employing a control table containing database table characteristics concerning progress of data replacement.

8. A method according to claim 4, including the step of:

creating an SQL (Structured Query Language) compatible data element comprising said received current value and said corresponding replacement value and a database table containing said plurality of additional data fields to receive said replacement values.

9. A method according to claim 4, including the step of:

creating a data element containing items identifying an index and a trigger for said plurality of additional data fields to receive said replacement values.

10. A method according to claim 4, including the step of:

limiting a rate at which said data fields are provided for update to ensure at least one of, (a) data update resources are not exceeded and (b) a predetermined update rate limit is not exceeded.

11. A method according to claim 4, wherein

said identified data fields to receive replacement values are grouped, and including the step of:

employing scheduling information for scheduling said groups of data fields for update.

12. A method according to claim 11, wherein

said groups of data fields comprise at least one database table.

13. A method according to claim 4, including the step of:

generating a status indicator determining progress of individual steps involved in replacing values of said identified additional data fields.

14. A method according to claim 4, wherein

said identified data fields to receive replacement values comprise a database table and including the step of:

creating a copy of said database table to receive replacement values including a column identifying a sequences of rows in said database table.

15. A method according to claim 14, including the steps of:

processing said identified data fields to receive replacement values one row at a time,

verifying successful replacement of individual data fields by row.

16. A method according to claim 14, including the step of:

identifying duplicate rows, and

processing duplicate rows differently.

17. A user interface system for use in converting data in a database from a current value to a different replacement value, comprising the steps of:

initiating generation of at least one display image supporting,

receiving information identifying a database data field to be updated and data comprising a current value and corresponding replacement value for replacing existing data in said identified data field;

initiating processing comprising,

examining said database to determine whether said data field is associated with at least one of,

(a) a trigger for initiating amendment of a database element upon alteration of said data field content, and

(b) an index used for locating said data field;

disabling a trigger and index when identified by said examination;

replacing said existing data in said data field with said received replacement value; and

viewing an updated data field.