Database comparison system

• US 10,628,395 B2
• Filed: 05/17/2016
• Issued: 04/21/2020
• 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:
  US15/156,695
• Publication Number:
  US 20160378794A1
• Time in Patent Office: 1,435 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 method for detecting changes in database schema, the method comprising:

receiving a first database schema, wherein the first database schema is metadata corresponding to a first database;

creating 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;

receiving a second database schema, wherein the second database schema is metadata corresponding to a second database;

creating a second value corresponding to the second database schema by utilizing the compressed value algorithm;

determining 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 method of claim 1, wherein the compressed value algorithm is a hash value algorithm.

3. The method of claim 1, further comprising:

creating a third value corresponding to a portion of the first database schema;

creating a fourth value corresponding to a portion of the second database schema;

determining 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 method 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 method of claim 4, wherein the first database schema corresponds to the first database at installation of the first database.

6. The method of claim 1, further comprising indicating to a user whether the difference exists between the first database schema and the second database schema.

7. The method of claim 1, further comprising storing the first value in memory.