Granted Patent B2

US 12,298,972 · App. 17/557,366 · Granted May 13, 2025

Inventors: Maharaj Mukherjee (Poughkeepsie, NY); Utkarsh Raj (Charlotte, NC); Carl M. Benda (Charlotte, NC); Suman Roy Choudhury (Jersey City, NJ); Elvis Nyamwange (Little Elm, TX)

Assignee: Bank of America Corporation

G06F16/2452G06F16/214G06F16/2425G06F16/2433G06F16/2448G06F16/24534G06F16/248G06F16/258G06F40/205

Abstract

Claims (73)

1. A computing platform comprising:

at least one processor;

a communication interface communicatively coupled to the at least one processor; and memory storing computer-readable instructions that, when executed by the at least one processor, cause the computing platform to:

receive a query, wherein the query is formatted in a first format for execution on a first database, wherein the first format comprises a first machine interpretable language;

translate the query to a second format for execution on a second database, wherein the second format comprises a second machine interpretable language, wherein the query comprises a SQL query and wherein the translated query comprises a non-SQL query, and wherein translating the query comprises:

extracting non-essential parameters from the query to create a query key;

storing the non-essential parameters;

executing a lookup function on a query library to identify a translated query corresponding to the query key;

based on identifying that the query library includes portions of the query key rather than the query key, recursively identifying the translated query by nesting the portions of the query key, wherein recursively identifying the translated query comprises:

identifying a first stored query key corresponding to a first portion of the query key,

identifying a second stored query key corresponding to a second portion of the query key, and

combining the first stored query key with the second stored query key to create a combination query key that matches the query key, wherein the translated query comprises the combination query key, wherein the combination query key includes the second stored query key nested within the first stored query key;

and inputting the non-essential parameters into the translated query to create an output query;

execute the output query on the first database to produce a first query result:

execute the output query on the second database to produce a second query result;

compare the second query result to the first query result;

based on identifying a discrepancy between the first query result and the second query result, update a query translation model used to produce the output query, wherein updating the query translation model causes the query translation model to adjust for the discrepancy, and wherein the query translation model is trained, maintained, and refined by a machine learning engine; and

based on identifying that the first query result matches the second query result, validate the output query.

2. The computing platform of claim 1 , wherein extracting the non-essential parameters from the query to create the query key comprises replacing the non-essential parameters with pointers, wherein the first stored query key and the second stored query key include corresponding pointers.

3. The computing platform of claim 2 , wherein inputting the non-essential parameters into the translated query to create the output query comprises replacing the corresponding pointers of the first stored query key and the second stored query key with the non-essential parameters.

4. The computing platform of claim 1 , wherein the memory stores additional computer-readable instructions that, when executed by the at least one processor, cause the computing platform to:

update, after executing the output query on the second database, the query library to include the combination query key.

5. The computing platform of claim 1 , wherein the query is received from a client application, and wherein the computing platform configures the client application to send the query to a custom driver configured to perform the query translation.

6. The computing platform of claim 1 , wherein executing the lookup function on the query library to identify the translated query corresponding to the query key comprises comparing the query key to a plurality of pre-verified query keys.

7. The computing platform of claim 6 , wherein the memory stores additional computer-readable instructions that, when executed by the at least one processor, cause the computing platform to:

based on identifying that the query library matches one of the plurality of pre-verified query keys, input the non-essential parameters into the matching pre-verified query key to create the output query.

8. The computing platform of claim 1 , wherein the memory stores additional computer-readable instructions that, when executed by the at least one processor, cause the computing platform to:

identify whether the query is formatted for execution at the second database, wherein translating the query is responsive to identifying that the query is not formatted for execution at the second database.

9. A method comprising:

at a computing platform comprising at least one processor, a communication interface, and memory:

receiving a query, wherein the query is formatted in a first format for execution on a first database, wherein the first format comprises a first machine interpretable language;

translating the query to a second format for execution on a second database, wherein the second format comprises a second machine interpretable language, wherein the query comprises a SQL query and wherein the translated query comprises a non-SQL query, and wherein translating the query comprises:

extracting non-essential parameters from the query to create a query key;

storing the non-essential parameters;

executing a lookup function on a query library to identify a translated query corresponding to the query key;

based on identifying that the query library includes portions of the query key rather than the query key, recursively identifying the translated query by nesting the portions of the query key, wherein recursively identifying the translated query comprises:

identifying a first stored query key corresponding to a first portion of the query key,

identifying a second stored query key corresponding to a second portion of the query key, and

combining the first stored query key with the second stored query key to create a combination query key that matches the query key, wherein the translated query comprises the combination query key, wherein the combination query key includes the second stored query key nested within the first stored query key; and

inputting the non-essential parameters into the translated query to create an output query;

executing the output query on the first database to produce a first query result;

executing the output query on the second database to produce a second query result;

comparing the second query result to the first query result;

based on identifying a discrepancy between the first query result and the second query result, updating a query translation model used to produce the output query, wherein updating the query translation model causes the query translation model to adjust for the discrepancy, and wherein the query translation model is trained, maintained, and refined by a machine learning engine; and

based on identifying that the first query result matches the second query result, validating the output query.

10. The method of claim 9 , wherein extracting the non-essential parameters from the query to create the query key comprises replacing the non-essential parameters with pointers, wherein the first stored query key and the second stored query key include corresponding pointers.

11. The method of claim 10 , wherein inputting the non-essential parameters into the translated query to create the output query comprises replacing the corresponding pointers of the first stored query key and the second stored query key with the non-essential parameters.

12. The method of claim 9 , further comprising:

updating, after executing the output query on the second database, the query library to include the combination query key.

13. The method of claim 9 , wherein the query is received from a client application, and wherein the computing platform configures the client application to send the query to a custom driver configured to perform the query translation.

14. The method of claim 9 , wherein executing the lookup function on the query library to identify the translated query corresponding to the query key comprises comparing the query key to a plurality of pre-verified query keys.

15. The method of claim 14 , further comprising:

based on identifying that the query library matches one of the plurality of pre-verified query keys, input the non-essential parameters into the matching pre-verified query key to create the output query.

16. One or more non-transitory computer-readable media storing instructions that, when executed by a computing platform comprising at least one processor, a communication interface, and memory, cause the computing platform to:

receive a query, wherein the query is formatted in a first format for execution on a first database, wherein the first format comprises a first machine interpretable language;

translate the query to a second format for execution on a second database, wherein the second format comprises a second machine interpretable language, and wherein translating the query comprises:

extracting non-essential parameters from the query to create a query key;

storing the non-essential parameters;

executing a lookup function on a query library to identify a translated query corresponding to the query key;

based on identifying that the query library includes portions of the query key rather than the query key, recursively identifying the translated query by nesting the portions of the query key, wherein the query comprises a SQL query and wherein the translated query comprises a non-SQL query, and wherein recursively identifying the translated query comprises:

identifying a first stored query key corresponding to a first portion of the query key,

identifying a second stored query key corresponding to a second portion of the query key, and

combining the first stored query key with the second stored query key to create a combination query key that matches the query key, wherein the translated query comprises the combination query key, wherein the combination query key includes the second stored query key nested within the first stored query key; and

inputting the non-essential parameters into the translated query to create an output query;

execute the output query on the first database to produce a first query result;

execute the output query on the second database to produce a second query result;

compare the second query result to the first query result;

based on identifying a discrepancy between the first query result and the second query result, update a query translation model used to produce the output query, wherein updating the query translation model causes the query translation model to adjust for the discrepancy, and wherein the query translation model is trained, maintained, and refined by a machine learning engine; and

based on identifying that the first query result matches the second query result, validate the output query.

17. The computing platform of claim 1 , wherein the query comprises a first type of SQL query and wherein the output query comprises a second type of SQL query.

18. The computing platform of claim 1 , wherein neither the first stored query key nor the second stored query key comprise exact matches with the query, and wherein identifying the first stored query key and the second stored query key comprises identifying, using fuzzy matching, the first stored query key and the second stored query key.

19. The computing platform of claim 1 , wherein the memory stores additional computer-readable instructions that, when executed by the at least one processor, cause the computing platform to:

identify whether or not the first format is executable on the second database, wherein translating the query to the second format for execution on the second database is in response to identifying that the first format is not executable on the second database.

Assignments (1)

Continuity (2)

References Cited (137)