US 12,277,039 B1
Intelligent file and filegroup reorganizer for backup and restore in multi environments
Praveen Kumar Trivedi, Gujarat (IN); Anshuman Mohanty, Telangana (IN); Venugopala Rao Randhi, Telangana (IN); and Rama Venkata Kavali, Frisco, TX (US)
Assigned to Bank of America Corporation, Charlotte, NC (US)
Filed by Bank of America Corporation, Charlotte, NC (US)
Filed on Oct. 26, 2023, as Appl. No. 18/383,923.
Int. Cl. G06F 11/14 (2006.01); G06F 16/22 (2019.01)
CPC G06F 11/1469 (2013.01) [G06F 11/1448 (2013.01); G06F 11/1464 (2013.01); G06F 16/2282 (2019.01); G06F 2201/80 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method for using an artificial intelligence (“AI”) engine to restore a source database including a plurality of drives, each drive including a plurality of filegroups, to a target environment including a plurality of drives, the method comprising:
calculating an amount of data on each drive of the source database and a cumulative amount of data on all the drives of the source database;
calculating free space on each drive of the target environment and a cumulative amount of free space on all the drives of the target environment, wherein:
the cumulative amount of free space exceeds the cumulative amount of data; and
each drive of the target environment has a corresponding drive on the source database;
detecting that the source database includes at least one additional drive that does not correspond to any of the drives in the target environment; and
detecting that the drives of the target environment cannot accommodate the data of the corresponding drives of the source database and the data of the at least one additional drive without splitting the data of the at least one additional drive between the drives of the target environment;
sorting tables in the filegroups in descending size order;
shrinking the filegroups;
fetching historical transactional queries run on the tables;
using the historical transactional queries to identify dependencies of one table upon another table within a filegroup;
fetching historical information of table movement from one filegroup of the plurality of filegroups to a different filegroup of the plurality of filegroups;
ingesting, by the AI engine, the calculated amount of data, the calculated free space, the historical transactional queries, the identified dependent tables and the historical information of table movement;
determining, in a first determination by the AI engine, the determination being based on ingested information, into which filegroups of the corresponding drives to move the tables and the dependent tables thereof of the additional drives;
moving the tables and the dependent tables thereof of the additional drives to the corresponding drives according to the first determination; and
restoring the drives of the target environment.