Database comparison system

• US 10,169,379 B2
• Filed: 06/26/2015
• Issued: 01/01/2019
• Est. Priority Date: 06/26/2015
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Simon, Nisanth M., Truong, Tuong C., Zhou, Ruiming
• Primary Examiner(s): Jacob, Ajith
• Application Number:
  US14/751,232
• Publication Number:
  US 20160378793A1
• Time in Patent Office: 1,285 Days
• CPC Class Codes: G06F 16/137 Hash-based content-based indexing of textual data G06F16/31
• CPC Class Codes: G06F 16/211 Schema design and management

Abstract

Embodiments of the present invention disclose a method, computer program product, and system for detecting changes in database schema. The embodiments may include receiving a first database schema. The embodiments may include creating a first value corresponding to the first database schema by utilizing a compressed value algorithm. The compressed value algorithm may create a single value corresponding to each database schema. The embodiments may include receiving a second database schema. The embodiments may include creating a second value corresponding to the second database schema by utilizing the compressed value algorithm. The embodiments may include determining whether there is a difference between the first database schema and the second database schema by comparing the first value and the second value.

Claims

1. A computer program product for detecting changes in database schema, the computer program product comprising:

one or more computer-readable storage devices and program instructions stored on at least one of the one or more tangible storage devices, the program instructions comprising;

program instructions to receive a first database schema, wherein the first database schema is metadata corresponding to a first database;

program instructions to create a first value corresponding to the first database schema by utilizing a compressed value algorithm, wherein the compressed value algorithm creates a single value corresponding to each database schema;

program instructions to receive a second database schema, wherein the second database schema is metadata corresponding to a second database;

program instructions to create a second value corresponding to the second database schema by utilizing the compressed value algorithm;

program instructions to determine whether a difference exists between the first database schema and the second database schema by comparing the first value and the second value.

2. The computer program product of claim 1, wherein the compressed value algorithm is a hash value algorithm.

3. The computer program product of claim 1, further comprising:

program instructions to create a third value corresponding to the portion of the first database schema;

program instructions to create a fourth value corresponding to the portion of the second database schema;

program instructions to determine whether a difference exists between the portion of the first database schema and the portion of the second database schema by comparing the third value and the fourth value.

4. The computer program product of claim 1, wherein the second database is a later version of the first database, and wherein the second database schema is received from the first database some period of time after the first database schema is received from the first database.

5. The computer program product of claim 4, wherein the first database schema corresponds to the first database at installation of the first database.

6. The computer program product of claim 1, further comprising program instructions indicate to a user whether the difference exists between the first database schema and the second database schema.

7. The computer program product of claim 4, further comprising computer instructions to store the first value in memory.

8. A computer system for detecting changes in database schema, the computer system comprising:

one or more processors, one or more computer-readable memories, one or more computer-readable tangible storage devices, and program instructions stored on at least one of the one or more storage devices for execution by at least one of the one or more processors via at least one of the one or more memories, the program instructions comprising;

program instructions to receive a first database schema, wherein the first database schema is metadata corresponding to a first database;

program instructions to create a first value corresponding to the first database schema by utilizing a compressed value algorithm, wherein the compressed value algorithm creates a single value corresponding to each database schema;

program instructions to receive a second database schema, wherein the second database schema is metadata corresponding to a second database;

program instructions to create a second value corresponding to the second database schema by utilizing the compressed value algorithm;

program instructions to determine whether a difference exists between the first database schema and the second database schema by comparing the first value and the second value.

9. The computer system of claim 8, wherein the compressed value algorithm is a hash value algorithm.

10. The computer system of claim 8, further comprising:

program instructions to create a third value corresponding to the portion of the first database schema;

program instructions to create a fourth value corresponding to the portion of the second database schema;

program instructions to determine whether a difference exists between the portion of the first database schema and the portion of the second database schema by comparing the third value and the fourth value.

11. The computer system of claim 8, second database is a later version of the first database, and wherein the second database schema is received from the first database some period of time after the first database schema is received from the first database.

12. The computer system of claim 11, wherein the first database schema corresponds to the first database at installation of the first database.

13. The computer system of claim 8, further comprising program instructions to indicate to a user whether the difference exists between the first database schema and the second database schema.