Granted Patent B2

US 12,299,477 · App. 18/237,257 · Granted May 13, 2025

Inventors: Hari Vuppala (Concord, NC); Rahul Shashidhar Phadnis (Charlotte, NC); Pratap Dande (Saint Johns, FL); Sailesh Vezzu (Hillsborough, NJ); Amer Ali (Jersey City, NJ); Rahul Yaksh (Austin, TX); Elvis Nyamwange (Little Elm, TX); Brian Neal Jacobson (Los Angeles, CA); Erik Dahl (Newark, DE)

Assignee: BANK OF AMERICA CORPORATION

G06F9/485G06F16/24575

Abstract

Claims (58)

1. A system for determining data migration using an automated query analyzer tool, the system comprising:

a memory device with computer-readable program code stored thereon;

at least one processing device, wherein executing the computer-readable code is configured to cause the at least one processing device to perform the following operations:

identify at least one input data set associated with at least one application;

analyze, by an automated query analyzer tool, the at least one input data set;

classify, by the automated query analyzer tool, data of the at least one data set as at least one of a standard classification or a non-standard classification;

determine, by the automated query analyzer tool, at least one metric for the data of the at least one data set;

generate, based on the at least one metric, a query complexity score for the at least one application;

generate, based on the query complexity score for the at least one application, an application migration complexity report and an application migration complexity report interface component; and

transmit the application migration complexity report interface component to a user device and configure a graphical user interface of the user device with the application migration complexity report interface component.

2. The system of claim 1 , wherein the at least one input data set is identified from at least one of a database, an index, or a query log associated with the at least one application.

3. The system of claim 1 , wherein the standard classification comprises an American National Standard Institute (ANSI) classification, and wherein the non-standard classification comprises a non-ANSI classification.

4. The system of claim 1 , wherein the data comprises a query, and wherein the at least one metric for the data of the at least one data set comprises a metric for at least one of query join counts, datatype count, function count, or keyword count of the query.

5. The system of claim 1 , wherein the computer-readable code is configured to cause the at least one processing device to perform the following operations:

receive a user input identifying the at least one application for migration to a target database, wherein the user input comprises an identification of at least one input data type for the input data set; and

trigger, based on receiving the user input identifying the at least one application, the automated query analyzer tool to analyze the at least one input data set.

6. The system of claim 1 , wherein the computer-readable code is configured to cause the at least one processing device to perform the following operations:

generate a knowledgebase comprising training data associated with the at least one application, wherein the training data comprises at least one of a database specific keyword, a function, a datatype, the standard classification, or the non-standard classification;

apply the training data to the automated query analyzer tool; and

train, based on applying the training data, the automated query analyzer tool.

7. The system of claim 6 , wherein the training data comprises at least one user input.

8. The system of claim 1 , wherein the query complexity score is generated by a query complexity scoring model, and wherein the query complexity scoring model is specific for a database identifier of the at least one application.

9. The system of claim 1 , wherein the application migration complexity report is interactive.

10. The system of claim 1 , wherein the application migration complexity report comprises a ranked list of the at least one application based on the query complexity score.

11. A computer program product for determining data migration using an automated query analyzer tool, wherein the computer program product comprises at least one non-transitory computer-readable medium having computer-readable program code portions embodied therein, the computer-readable program code portions which when executed by a processing device are configured to cause the processor to perform the following operations:

identify at least one input data set associated with at least one application;

analyze, by an automated query analyzer tool, the at least one input data set;

classify, by the automated query analyzer tool, data of the at least one data set as at least one of a standard classification or a non-standard classification;

determine, by the automated query analyzer tool, at least one metric for the data of the at least one data set;

generate, based on the at least one metric, a query complexity score for the at least one application;

generate, based on the query complexity score for the at least one application, an application migration complexity report and an application migration complexity report interface component; and

transmit the application migration complexity report interface component to a user device and configure a graphical user interface of the user device with the application migration complexity report interface component.

12. The computer program product of claim 11 , wherein the data comprises a query, and wherein the at least one metric for the data of the at least one data set comprises a metric for at least one of query join counts, datatype count, function count, or keyword count of the query.

13. The computer program product of claim 11 , wherein the processing device is configured to cause the processor to perform the following operations:

receive a user input identifying the at least one application for migration to a target database, wherein the user input comprises an identification of at least one input data type for the input data set; and

trigger, based on receiving the user input identifying the at least one application, the automated query analyzer tool to analyze the at least one input data set.

14. The computer program product of claim 11 , wherein the processing device is configured to cause the processor to perform the following operations:

generate a knowledgebase comprising training data associated with the at least one application, wherein the training data comprises at least one of a database specific keyword, a function, a datatype, the standard classification, or the non-standard classification;

apply the training data to the automated query analyzer tool; and

train, based on applying the training data, the automated query analyzer tool.

15. The computer program product of claim 11 , wherein the query complexity score is generated by a query complexity scoring model, and wherein the query complexity scoring model is specific for a database identifier of the at least one application.

16. A computer implemented method for determining data migration using an automated query analyzer tool, the computer implemented method comprising:

identifying at least one input data set associated with at least one application;

analyzing, by an automated query analyzer tool, the at least one input data set;

classifying, by the automated query analyzer tool, data of the at least one data set as at least one of a standard classification or a non-standard classification;

determining, by the automated query analyzer tool, at least one metric for the data of the at least one data set;

generating, based on the at least one metric, a query complexity score for the at least one application;

generating, based on the query complexity score for the at least one application, an application migration complexity report and an application migration complexity report interface component; and

transmitting the application migration complexity report interface component to a user device and configure a graphical user interface of the user device with the application migration complexity report interface component.

17. The computer implemented method of claim 16 , wherein the data comprises a query, and wherein the at least one metric for the data of the at least one data set comprises a metric for at least one of query join counts, datatype count, function count, or keyword count of the query.

18. The computer implemented method of claim 16 , the computer implemented method further comprising:

receiving a user input identifying the at least one application for migration to a target database, wherein the user input comprises an identification of at least one input data type for the input data set; and

triggering, based on receiving the user input identifying the at least one application, the automated query analyzer tool to analyze the at least one input data set.

19. The computer implemented method of claim 16 , the computer implemented method further comprising:

generating a knowledgebase comprising training data associated with the at least one application, wherein the training data comprises at least one of a database specific keyword, a function, a datatype, the standard classification, or the non-standard classification;

applying the training data to the automated query analyzer tool; and

training, based on applying the training data, the automated query analyzer tool.

20. The computer implemented method of claim 16 , wherein the query complexity score is generated by a query complexity scoring model, and wherein the query complexity scoring model is specific for a database identifier of the at least one application.

Assignments (1)

Continuity (1)

References Cited (25)