Repairing corrupted references

Patent metadata

Field	Value
Publication number	US-2016357789-A1
Application number	US-201514729102-A
Country	US
Kind code	A1
Filing date	Jun 3, 2015
Priority date	Jun 3, 2015
Publication date	Dec 8, 2016
Grant date	—

Abstract

Repairing corrupt database references. Identifying a corrupt reference within a database, whereby the corrupt reference includes a reference with a broken connection between one or more data objects within the database and the corrupt reference is associated with one or more reference corruption types. Recording reference information for the corrupt reference, whereby the reference information includes a location of the corrupt reference within the database and one or more identification numbers of the one or more data objects associated with the corrupt reference. Determining a repair procedure based on the one or more reference corruption types associated with the corrupt reference. Generating one or more lines of computer code associated with the repair procedure and based on the recorded reference information. Executing the one or more lines, whereby the one or more lines are executed in a database manager.

First claim

What is claimed is:

1 . A method for repairing corrupt database references, the method comprising:
identifying, by a computer, one or more corrupt references within a database, wherein the one or more corrupt references includes a reference with a broken connection between two or more data objects within the database, and wherein the one or more corrupt references has an associated reference corruption type; recording, by the computer, reference information for the one or more corrupt references, wherein the reference information includes a location of the two or more data objects within the database and an identification number of the two or more data objects; determining, by the computer, a repair procedure based on the reference corruption type associated with the one or more corrupt references and based on the reference information; and executing, by the computer, the repair procedure.

2 . The method of claim 1 , wherein the associated reference corruption type includes an abandoned reference, a dangling reference, and an unbalanced reference, and wherein the abandoned reference includes a destination data object referenced by an improper source data object, and wherein the dangling reference includes source data object referencing an improper destination data object, and wherein the unbalanced reference includes a bidirectional reference with at least one broken connection.

3 . The method of claim 1 , further comprising:
repairing, by the computer, the one or more identified corrupt references, wherein repairing the one or more identified corrupt references further comprises determining the one or more data objects associated with the one or more identified corrupt references are not associated with one or more other corrupt references and determining a conflict is not created by repairing the one or more identified corrupt references.

4 . The method of claim 1 , wherein the repair procedure includes at least one of nulling out the one or more corrupt references associated with the one or more data objects, editing the reference information associated with the one or more corrupt references to replace a first set of data objects of the two or more data objects with a second set of data objects of the two or more data objects, and deleting the one or more corrupt references.

5 . The method of claim 1 , wherein recording the reference information further comprises generating a text file and saving the reference information to the generated text file, and wherein the text file includes at least one of a batch file and an extensible markup language file.

6 . The method of claim 1 , wherein determining the repair procedure is based on one of a user preconfigured priority list of one or more repair procedures and determining the repair procedure based on a user selected repair procedure from a list, wherein the list includes one or more repair procedures.

7 . The method of claim 1 , wherein the one or more corrupt references includes a first data object and a second data object, and wherein recording the reference information includes recording reference information for the first and the second data objects, and wherein determining the repair procedure includes determining a first repair procedure corresponding to the first data object and a second repair procedure corresponding to the second data object after recording the reference information for the first and the second data objects.

8 . A computer system for repairing corrupt database references, the computer system comprising:
one or more processors, one or more computer-readable memories, one or more computer-readable tangible storage medium, and program instructions stored on at least one of the one or more tangible storage medium for execution by at least one of the one or more processors via at least one of the one or more memories, wherein the computer system is capable of performing a method comprising: identifying, by a computer, one or more corrupt references within a database, wherein the one or more corrupt references includes a reference with a broken connection between two or more data objects within the database, and wherein the one or more corrupt references has an associated reference corruption type; recording, by the computer, reference information for the one or more corrupt references, wherein the reference information includes a location of the two or more data objects within the database and an identification number of the two or more data objects; determining, by the computer, a repair procedure based on the reference corruption type associated with the one or more corrupt references and based on the reference information; and executing, by the computer, the repair procedure.

9 . The computer system of claim 8 , wherein the associated reference corruption type includes an abandoned reference, a dangling reference, and an unbalanced reference, and wherein the abandoned reference includes a destination data object referenced by an improper source data object, and wherein the dangling reference includes source data object referencing an improper destination data object, and wherein the unbalanced reference includes a bidirectional reference with at least one broken connection.

10 . The computer system of claim 8 , further comprising:
repairing, by the computer, the one or more identified corrupt references, wherein repairing the one or more identified corrupt references further comprises determining the one or more data objects associated with the one or more identified corrupt references are not associated with one or more other corrupt references and determining a conflict is not created by repairing the one or more identified corrupt references.

11 . The computer system of claim 8 , wherein the repair procedure includes at least one of nulling out the one or more corrupt references associated with the one or more data objects, editing the reference information associated with the one or more corrupt references to replace a first set of data objects of the two or more data objects with a second set of data objects of the two or more data objects, and deleting the one or more corrupt references.

12 . The computer system of claim 8 , wherein recording the reference information further comprises generating a text file and saving the reference information to the generated text file, and wherein the text file includes at least one of a batch file and an extensible markup language file.

13 . The computer system of claim 8 , wherein determining the repair procedure is based on one of a user preconfigured priority list of one or more repair procedures and determining the repair procedure based on a user selected repair procedure from a list, wherein the list includes one or more repair procedures.

14 . The computer system of claim 8 , wherein the one or more corrupt references includes a first data object and a second data object, and wherein recording the reference information includes recording reference information for the first and the second data objects, and wherein determining the repair procedure includes determining a first repair procedure corresponding to the first data object and a second repair procedure corresponding to the second data object after recording the reference information for the first and the second data objects.

15 . A computer program product for repairing corrupt database references, the computer program product comprising:
one or more computer-readable tangible storage medium and program instructions stored on at least one of the one or more tangible storage medium, the program instructions exe

Assignees

• IBM

Inventors

• Contessa Luca
• Hagelberg Jeffrey N

Classifications

• G06F17/30303 Primary

  Physics · mapped topic

• G06F17/30371

  Physics · mapped topic

• G06F17/30604

  Physics · mapped topic

• G06F16/2365

  Ensuring data consistency and integrity · CPC title

• G06F16/215 Primary

  Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors · CPC title