Method, system, and program product for using analysis views to identify data synchronization problems between databases

• US 20060253485A1
• Filed: 05/05/2005
• Published: 11/09/2006
• Est. Priority Date: 05/05/2005
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Bangel, Matthew J., Martin, James A. Jr., Madsen, Robert G., Feeney, Gregory V.
• Granted Patent: US 9,053,164 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation

Abstract

The present invention provides a method, system, and computer program product for identifying data synchronization problems between data in different databases. The method includes: providing first and second databases containing common data; generating a summary of the common data as present in the first database; generating a summary of the common data as present in the second database; determining at least one delta value for the common data between the first and second databases; and generating an analysis view displaying the summary of the common data as present in the first database, the summary of the common data as present in the second database, and the at least one delta value for the common data between the first and second databases.

Claims

1. A method for identifying data synchronization problems, comprising:

providing first and second databases containing common data;

generating a summary of the common data as present in the first database;

generating a summary of the common data as present in the second database;

determining at least one delta value for the common data between the first and second databases; and

generating an analysis view displaying the summary of the common data as present in the first database, the summary of the common data as present in the second database, and the at least one delta value for the common data between the first and second databases.

2. The method of claim 1, wherein a data synchronization problem is indicated by a delta value having a predetermined value.

3. The method of claim 2, wherein the predetermined value is any value other than zero.

4. The method of claim 1, further comprising:

refreshing the analysis view to include updated common data from the first and second databases.

5. The method of claim 1, further comprising:

formulating the at least one delta value to help identify a source of a data synchronization problem between the first and second databases.

6. Deploying an application for identifying data synchronization problems, comprising:

providing a computer infrastructure being operable to perform the method of claim 1.

7. Computer software embodied in a propagated signal for identifying data synchronization problems, the computer software comprising instructions to cause a computer system to perform the method of claim 1.

8. A system for identifying data synchronization problems, comprising:

means for providing first and second databases containing common data;

means for generating a summary of the common data as present in the first database;

means for generating a summary of the common data as present in the second database;

means for determining at least one delta value for the common data between the first and second databases; and

means for generating an analysis view displaying the summary of the common data as present in the first database, the summary of the common data as present in the second database, and the at least one delta value for the common data between the first and second databases.

9. The system of claim 8, wherein a data synchronization problem is indicated by a delta value having a predetermined value.

10. The system of claim 9, wherein the predetermined value is any value other than zero.

11. The system of claim 8, further comprising:

means for refreshing the analysis view to include updated common data from the first and second databases.

12. The system of claim 8, further comprising:

means for formulating the at least one delta value to help identify a source of a data synchronization problem between the first and second databases.

13. A program product stored on a computer readable medium for identifying data synchronization problems, the computer readable medium comprising program code for performing the following steps:

providing first and second databases containing common data;

generating a summary of the common data as present in the first database;

generating a summary of the common data as present in the second database;

determining at least one delta value for the common data between the first and second databases; and

generating an analysis view displaying the summary of the common data as present in the first database, the summary of the common data as present in the second database, and the at least one delta value for the common data between the first and second databases.

14. The program product of claim 13, wherein a data synchronization problem is indicated by a delta value having a predetermined value.

15. The program product of claim 14, wherein the predetermined value is any value other than zero.

16. The program product of claim 13, further comprising program code for:

refreshing the analysis view to include updated common data from the first and second databases.

17. The program product of claim 13, further comprising program code for:

formulating the at least one delta value to help identify a source of a data synchronization problem between the first and second databases.