Bank of America Corporation

Anshuman Mohanty

Venugopala Rao Randhi

Praveen Kumar Trivedi

Ritesh Kumar Dash

Rama Venkata Kavali

Methods and systems are provided for restoring a source database to a target environment. The methods and systems may include calculating an amount of data on each drive of the source database. The methods and systems may include calculating free space of each drive of the target environment. The methods and systems may include shrinking filegroups in the drives of the source database. The methods and systems may include fetching historical transactional queries run on tables in the filegroups. The methods and systems may include identifying interdependencies between tables using the queries. The methods and systems may include ingesting, by an AI engine, the calculations, the queries, the identified interdependent tables, historical information of table movement and a business use case. The methods and systems may include the AI engine determining how to restore the source database using the ingested information.

Intelligent file and filegroup reorganizer for backup and restore in multi environments

A system includes one or more source memory devices of a source computing environment that store a database comprising data files, wherein each of a plurality of data tables of the source computing environment includes data from one or more of the data files, one or more target memory devices of a target computing environment and at least one processor configured to receive a command to copy data files from the source memory devices to the target memory devices, detect that the target memory devices have insufficient memory, calculate a value coefficient for each data table, assign a priority index to each data table based on the value coefficient, order the data files in a copy queue based on the priority index of the data tables, and copy the ordered data files to the target memory devices.

Table prioritization for data copy in a multi- environment setup

A system includes one or more source memory devices of a source computing environment that store a database comprising data files grouped in a plurality of file groups, wherein each of a plurality of data tables of 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 and at least one processor configured to receive a command to copy data files from the source memory devices to the target memory devices, detect that the target memory devices have insufficient memory, calculate a value coefficient for each data table, assign a priority index to each data table based on the value coefficient, re-arrange the file groups based on priority indices of the data tables, and copy the re-arranged file groups to the target memory devices.

Table prioritization for data copy in a multi-environment setup

A system includes one or more source memory devices of a source computing environment that store a database comprising data files grouped in a plurality of file groups, wherein each of a plurality of data tables of the source computing environment includes data from one or more of the data files grouped into one or more of the file groups, one or more target memory devices of a target computing environment and at least one processor configured to calculate a number of read operations per megabyte (MB) for a data table, a number of write operations per MB, obtain an importance index of the table, weight the reads per MB, writes per MB and the importance index by respective user-defined weights, determine a criticality index of the table, calculate a value coefficient of the table, and assign a data file based on the value coefficient of the table.

Growing community of inventors

Hyderabad Telangana, India

Anshuman Mohanty