System and method of assessing the state of a database product for installation consistency

• US 9,720,919 B1
• Filed: 12/05/2014
• Issued: 08/01/2017
• Est. Priority Date: 10/31/2012
• Status: Active Grant

• Current Assignee: CA, Inc. (d/b/a CA Technologies) (Broadcom, Inc.)
• Original Assignee: CA, Inc. (d/b/a CA Technologies) (Broadcom, Inc.)
• Inventors: Rose, Robert C., Schertz, Richard L.
• Primary Examiner(s): Coby, Frantz
• Application Number:
  US14/561,487
• Time in Patent Office: 970 Days
• Field of Search: 707610, 707611, 707612, 707613, 707614, 707617, 707618, 707638, 707806, 709201, 709203, 709213, 709217
• CPC Class Codes: G06F 16/11 File system administration, e.g. details of archiving or snapshots file system backup G06F11/14
• CPC Class Codes: G06F 16/113 Details of archiving lifecycle management in storage systems G06F3/0649; backup systems G06F11/1446
• CPC Class Codes: G06F 16/16 File or folder operations, e.g. details of user interfaces specifically adapted to file systems
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 3/0643 Management of files

Abstract

A computer-implemented system and method performs an iterative process to assess the installation of an upgrade version of a database product for consistency with a baseline version of the database product. To assess the installation, the baseline version and the upgrade version are reconciled by modifying one or both of the baseline and upgrade versions. The modified baseline and upgrade versions are then analyzed to determine whether any remaining inconsistencies exist. Any remaining inconsistencies are then identified and classified, and reconciled. Thereafter, the process is repeated iteratively until the upgrade version is reconciled with the baseline version.

Claims

1. A computer-implemented method comprising:

reconciling known inconsistencies between a baseline version of a database product that is installed on a first computing device and an upgrade version of the database product that is installed on the first or a second computing device, wherein reconciling the known inconsistencies comprises modifying one or both of the baseline version and the upgrade version; and

determining whether the upgrade version differs from the baseline version after the reconciling, wherein the determining comprises;

comparing the baseline version to the upgrade version;

identifying remaining inconsistencies between the baseline version and the upgrade version based on the comparison; and

classifying each remaining inconsistency as being a corresponding one of a plurality of pre-determined inconsistency types.

2. The computer-implemented method of claim 1 wherein modifying one or both of the baseline version and the upgrade version comprises modifying at least one of a data value, a data structure, and application code associated with one or both of the baseline version and the upgrade version.

3. The computer-implemented method of claim 2 wherein modifying one or both of the baseline version and the upgrade version comprises sorting a database table associated with one of the baseline version and the upgrade version to match a sorting of a corresponding table associated with the other of the baseline version and the upgrade version based on the known inconsistencies.

4. The computer-implemented method of claim 1 wherein reconciling the known inconsistencies further comprises eliminating an artifact associated with one or both of the baseline version and the upgrade version based on the known inconsistencies.

5. The computer-implemented method of claim 1 wherein reconciling the known inconsistencies further comprises marking a known inconsistency in at least one of the baseline version and the upgrade version.

6. The computer-implemented method of claim 1 further comprising analyzing the remaining inconsistencies between the baseline version and the upgrade version, and wherein classifying each remaining inconsistency as being a corresponding one of a plurality of pre-determined inconsistency types comprises classifying each remaining inconsistency based on the analysis.

7. The computer-implemented method of claim 6 wherein classifying each remaining inconsistency based on the analysis comprises classifying a given remaining inconsistency as being one of:

a defect in one or both of the baseline version and the upgrade version;

a deficiency in one or both of the baseline version and the upgrade version that occurred while the baseline and upgrade versions were being reconciled; and

an inconsistency between the baseline version and the upgrade version that cannot be reconciled.

8. A computing device comprising:

a user input/output interface;

a communications interface configured to communicate with a remote device via a communications network; and

a programmable controller circuit configured to;

reconcile known inconsistencies between a baseline version of a database product that is installed on a first computing device and an upgrade version of the database product that is installed on the first or a second computing device, wherein to reconcile the known inconsistencies the programmable controller modifies one or both of the baseline version and the upgrade version; and

determine whether the upgrade version differs from the baseline version after reconciling, wherein to determine whether the upgrade version differs from the baseline version, the programmable controller circuit is further configured to;

compare the baseline version to the upgrade version after reconciling;

identify remaining inconsistencies between the baseline version and the upgrade version based on the comparison; and

classify each remaining inconsistency as being a corresponding one of a plurality of pre-determined inconsistency types.

9. The computing device of claim 8 wherein to modify one or both of the baseline version and the upgrade version, the programmable controller circuit is further configured to modify at least one of a data value, a data structure, and application code associated with one or both of the baseline version and the upgrade version.

10. The computing device of claim 9 wherein to modify one or both of the baseline version and the upgrade version, the programmable controller circuit is further configured to sort a database table associated with one of the baseline version and the upgrade version to match a sorting of a corresponding table associated with the other of the baseline version and the upgrade version based on the known inconsistencies.

11. The computing device of claim 8 wherein to reconcile the known inconsistencies, the programmable controller circuit is further configured to eliminate an artifact associated with one or both of the baseline version and the upgrade version based on the known inconsistencies.

12. The computing device of claim 8 wherein to reconcile the known inconsistencies, the programmable controller circuit is further configured to mark a known inconsistency in at least one of the baseline version and the upgrade version.

13. The computing device of claim 8 wherein the programmable controller circuit is further configured to analyze the remaining inconsistencies between the baseline version and the upgrade version, and wherein to classify each remaining inconsistency as being a corresponding one of a plurality of pre-determined inconsistency types, the programmable controller circuit is configured to classify the remaining inconsistencies based on the analysis.

14. The computing device of claim 13 wherein to classify each remaining inconsistency based on the analysis, the programmable controller circuit is further configured to classify a remaining inconsistency as one of:

a defect in one or both of the baseline version and the upgrade version;

a deficiency in one or both of the baseline version and the upgrade version that occurred while the baseline and upgrade versions were being reconciled; and

an inconsistency between the baseline version and the upgrade version that cannot be reconciled.

15. A computer readable storage medium storing computer program code thereon, wherein the computer program code, when executed by a processing circuit of a computing device, configures the processing circuit to:

reconcile known inconsistencies between a baseline version of a database product that is installed on a first computing device and an upgrade version of the database product that is installed on the first or a second computing device, wherein to reconcile the known inconsistencies the computer program code configures the processing circuit to modify one or both of the baseline version and the upgrade version; and

determine whether the upgrade version differs from the baseline version after reconciling, wherein to determine whether the upgrade version differs from the baseline version, the computer program code further configures the processing circuit to;

compare the baseline version to the upgrade version after reconciling;

identify remaining inconsistencies between the baseline version and the upgrade version based on the comparison; and

classify each remaining inconsistency as being a corresponding one of a plurality of pre-determined inconsistency types.

16. The computer readable storage medium of claim 15 wherein the computer program code further configures the processing circuit to modify at least one of a data value, a data structure, and application code associated with one or both of the baseline version and the upgrade version.

17. The computer readable storage medium of claim 16 wherein the computer program code further configures the processing circuit to sort a database table associated with one of the baseline version and the upgrade version to match a sorting of a corresponding table associated with the other of the baseline version and the upgrade version based on the known inconsistencies.

18. The computer readable storage medium of claim 15 wherein the computer program code further configures the processing circuit to eliminate an artifact associated with one or both of the baseline version and the upgrade version based on the known inconsistencies.

19. The computer readable storage medium of claim 15 wherein the computer program code further configures the processing circuit to mark a known inconsistency in at least one of the baseline version and the upgrade version.

20. The computer readable storage medium of claim 15 wherein the computer program code further configures the processing circuit to:

analyze the remaining inconsistencies between the baseline version and the upgrade version; and

based on the analysis, classify a remaining inconsistency as one of;

a defect in one or both of the baseline version and the upgrade version;

a deficiency in one or both of the baseline version and the upgrade version that occurred while the baseline and upgrade versions were being reconciled; and

an inconsistency between the baseline version and the upgrade version that cannot be reconciled.