US 12,321,322 B2
Systems and methods for secure database schema migration
Mark Edward Scott, Jr., Waco, TX (US)
Assigned to Dell Products, L.P., Round Rock, TX (US)
Filed by Dell Products, L.P., Round Rock, TX (US)
Filed on Apr. 21, 2023, as Appl. No. 18/304,545.
Prior Publication US 2024/0354290 A1, Oct. 24, 2024
Int. Cl. G06F 16/21 (2019.01)
CPC G06F 16/213 (2019.01) [G06F 16/214 (2019.01)] 18 Claims
OG exemplary drawing
 
1. An Information Handling System (IHS) comprising:
a processor; and
a memory coupled to the processor, the memory having program instructions stored thereon that, upon execution, cause the processor to:
calculate a first hash of schema objects for a relational database;
compare the calculated first hash of the schema objects with an expected second hash of the schema objects for the relational database;
determine that the schema objects comprise a previous version of the relational database;
execute scripts to migrate the schema objects for the relational database to an upgraded version of the relational database;
calculate a third hash of the migrated schema objects for the upgraded version of the relational database;
compare the calculated third hash of the migrated schema objects with the expected second hash of the schema objects for the relational database;
validate, based on the comparison of the calculated third hash of the migrated schema objects with the expected second hash of the schema objects providing a match, the migrated schema objects for the upgraded version of the relational database;
determine a cryptographic signature of the third hash using a private encryption key;
combine data retained by the upgraded version of the relational database with the migrated schema objects, the third hash, and the cryptographic signature into a validated database migration package; and
provide at least one of: the validated database migration package, or an indication of the validation to a network-based recipient via a communication network.