US 11,797,393 B2
Table prioritization for data copy in a multi-environment setup
Praveen Kumar Trivedi, Gandhinagar (IN); Venugopala Rao Randhi, Hyderabad (IN); Anshuman Mohanty, Hyderabad (IN); and Ritesh Kumar Dash, Hyderabad (IN)
Assigned to Bank of America Corporation, Charlotte, NC (US)
Filed by Bank of America Corporation, Charlotte, NC (US)
Filed on Mar. 23, 2022, as Appl. No. 17/656,060.
Prior Publication US 2023/0305932 A1, Sep. 28, 2023
Int. Cl. G06F 11/14 (2006.01); G06F 9/48 (2006.01)
CPC G06F 11/1469 (2013.01) [G06F 9/4881 (2013.01); G06F 11/1451 (2013.01); G06F 11/1456 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A system comprising:
one or more source memory devices of a source computing environment that store a database comprising a plurality of data files grouped in a plurality of file groups, wherein each of a plurality of data tables defined for the source computing environment includes data from one or more of the data files grouped in to one or more of the file groups;
one or more target memory devices of a target computing environment that store at least a portion of the data files from the one or more source memory devices;
at least one processor communicatively coupled to the one or more source memory devices and the one or more target memory devices and configured to:
receive a command to copy the plurality of data files from the one or more source memory devices to the one or more target memory devices;
detect that the one or more target memory devices have insufficient memory space to accommodate the plurality of data files;
calculate a value coefficient for each of the plurality of data tables, wherein the value coefficient corresponding to each data table is indicative of a relative importance of the data table among the plurality of data tables, wherein the value coefficient is determined for each data table based at least on one or more interaction metrics related to the data table indicating an amount of one or more types of data interactions performed in relation to the data table, an importance index assigned to the data table, user-defined numerical weights for each interaction metric and the importance index, and a criticality index based on a relationship of the data table with other data tables of the database;
assign a priority index to each data table based on the calculated value coefficient of the data table, wherein a higher priority is assigned to a data table having a higher value coefficient;
re-arrange the file groups by assigning the data files to the file groups based on the priority index of the data tables associated with the data files, wherein a data file that includes data associated with a data table with a higher priority index is assigned to one or more file groups that are earlier in a copy queue for copying to the target memory devices; and
schedule copy of the re-arranged data file groups to the target memory devices according to the copy queue.