Validation of database schema upgrades using a data differencing tool
AssigneeRed Hat, Inc.
InventorsMilan Zázrivec, Jan Pazdziora
Life of this patent
Estimating the term…
Abstract
An upgrade controller that compares the contents of a reference database with an upgraded database is described. In one embodiment, the upgrade controller connects to the reference and upgraded database and retrieves the list of tables. For each of the tables, the upgrade controller compares the content of the reference and the upgraded table. The upgrade controller compares the table contents by comparing the contents on a record-by-record basis. In addition, the upgrade controller can use a whitelist of tables and columns to reduce the number of false positive(s) that could be generated during the comparison.
Claims20
A computer-implemented method to compare a reference database with an upgraded database, the method comprising:
- connecting to the reference database and the upgraded database, wherein the reference database has a reference schema and the upgraded database has an upgraded schema;
- obtaining a list of reference tables of the reference database using the reference schema and a list of upgraded tables of the upgraded database using the upgraded schema;
- and
- for each table that is common in the list of reference tables and the list of upgraded tables,
- comparing, with an upgrade controller, contents of a corresponding table from the reference database with contents of a corresponding table from the upgraded database if the common table is not included in a whitelist of tables.
A computer readable storage medium having instructions stored thereon that, when executed by a processing system, cause the processing system to perform a method comprising:
- connecting to a reference database and an upgraded database wherein the reference database has a reference schema and the upgraded database has an upgraded schema;
- obtaining a list of reference tables of the reference database using the reference schema and a list of upgraded tables of the upgraded database using the upgraded schema;
- and
- for each table that is common in the list of reference tables and the list of upgraded tables,
- comparing contents of a corresponding table from the reference database with contents of a corresponding table from the upgraded database if the common table is not included in a whitelist of tables.
An upgrade processing device comprising:
- a connection module to connect to a reference database and a upgraded database, wherein the reference database has a reference schema and the upgraded database has an upgraded schema;
- a table retrieval module, coupled to the connection module, to obtain a list of reference tables of the reference database using the reference schema and a list of upgraded tables of the upgraded database using the upgraded schema;
- and
- a table comparison module, coupled to the table retrieval module, to compare, for each table that is common in the list of reference tables and the list of upgraded tables, contents of a corresponding table from the reference database with contents of a corresponding table from the upgraded database if the common table is not included in a whitelist of tables.
Dependencies are inferred from the claim text.