Database schema upgrade validation using denormalization
AssigneeRed Hat, Inc.
InventorsMilan Zazrivec, Jan Pazdziora
Life of this patent
Estimating the term…
Abstract
Some embodiments of a system and a method to validate database schema upgrade using denormalization have been presented. For instance, a database deployment engine may upgrade a database from a first version to a second version. The database upgraded stores a set of entities. By applying denormalization to both the upgraded database and a reference database (which contains a newly installed second version of the database), a database validation engine may reduce false positives during validation of the database schema upgrade scripts usable by customers to upgrade their database schema to the latest version.
Claims21
A computer-implemented method comprising:
- upgrading, by a processing device executing a database schema upgrade script, a database schema of a database from a first version to a second version, the database storing a plurality of entities;
- and
- applying, by the processing device, denormalization to the database upgraded and a reference database to reduce false positives during validation of the database schema upgrade script, wherein the reference database comprises a newly installed database of the second version.
An apparatus comprising:
- a database schema upgrade engine executable on a server, to upgrade a database schema of a database from a first version to a second version, the database storing a plurality of entities;
- and
- a database validation engine executable on the server, to apply denormalization to the database and a reference database to reduce false positives during validation of the database schema upgrade engine, wherein the reference database comprises a newly installed database of the second version.
A computer-readable storage medium embodying instructions that, when executed by a processing device, will cause the processing device to perform a method comprising:
- executing a database schema upgrade script to upgrade a database schema of a database from a first version to a second version, the database storing a plurality of entities;
- and
- applying denormalization to the database and a reference database to reduce false positives during validation of the database schema upgrade script, wherein the reference database comprises a newly installed database of the second version.
Dependencies are inferred from the claim text.