IP Library › Granted Patent US 12,079,210
Granted Patent B2
US 12,079,210 · App. 17/557,456 · Granted Sep 3, 2024

System and method for efficient transliteration of machine interpretable languages

Inventors: Carl M. Benda (Charlotte, NC); Maharaj Mukherjee (Poughkeepsie, NY); Utkarsh Raj (Charlotte, NC); Elvis Nyamwange (Little Elm, TX); Suman Roy Choudhury (Jersey City, NJ)
Assignee: Bank of America Corporation
G06F16/2452G06F16/214G06F16/2425G06F16/2433G06F16/2448G06F16/24534G06F16/248G06F16/258G06F40/205
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,079,210
App. No.
17/557,456
Filed
Dec 21, 2021
Granted
Sep 3, 2024
Kind
B2
Art Unit
2153
USPC
707/722
Abstract

Aspects of the disclosure relate to transliteration of machine interpretable languages. A computing platform may configure a client application to use a custom driver when communicating with an enterprise database. The computing platform may receive a database query formatted in a first database format corresponding to a first database. The computing platform may translate, using a query translation library, the database query from the first database format into a second database format corresponding to a second database, which may cause the custom driver to execute a transliteration process using pre-verified query keys stored in the query translation library to convert the database query from the first database format into the second database format. The computing platform may execute the translated database query on the second database to obtain a query result, and may send the query result to the client application.

Claims (67)

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:

configure a client application to use a custom driver of the computing platform when communicating with an enterprise database;

receive, from the client application and at the custom driver, a database query, wherein the database query is formatted in a first database format corresponding to a first database;

translate, at the custom driver and using a query translation library, the database query from the first database format into a second database format corresponding to a second database, wherein translating the database query comprises causing the custom driver to execute a transliteration process using pre-verified query keys stored in the query translation library to convert the database query from the first database format into the second database format, and wherein:

the first database format comprises a first machine interpretable language, and

the second database format comprises a second machine interpretable language;

execute, by the custom driver, the translated database query on the second database to obtain a query result; and

send, to the client application and by the custom driver, the query result.

2. The computing platform of claim 1 , wherein communicating with the enterprise database comprises establishing a connection with the enterprise database, sending database queries to the enterprise database, and returning query results to the client application.

3. The computing platform of claim 1 , wherein executing the transliteration process comprises:

parsing the database query to create a query key;

storing query parameters;

executing a lookup function on a query library to identify a translated database query; and

updating the translated database query to include the query parameters to create an output query.

4. The computing platform of claim 3 , wherein parsing the database query to create the query key comprises:

extracting non-essential portions of the database query; and

replacing the non-essential portions of the database query with pointers.

5. The computing platform of claim 4 , wherein the translated database query includes the pointers.

6. The computing platform of claim 5 , wherein updating the translated database query to include the query parameters comprises, replacing the pointers with the query parameters.

7. The computing platform of claim 3 , 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, during execution of the lookup function, that the query library includes portions of the query key rather than the query key, recursively identify the translated database query by nesting portions of the query key.

8. The computing platform of claim 7 , wherein recursively identifying the translated database 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.

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

update, after obtaining the query result, the query library to include the combination query key.

10. 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 database query is formatted for execution at the second database, wherein translating the database query is responsive to identifying that the database query is not formatted for execution at the second database.

11. The computing platform of claim 1 , wherein the translation is performed using a machine learning model, wherein the machine learning model is refined based on the query result.

12. A method comprising:

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

configuring a client application to use a custom driver of the computing platform when communicating with an enterprise database;

receiving, from the client application and at the custom driver, a database query, wherein the database query is formatted in a first database format corresponding to a first database;

translating, at the custom driver and using a query translation library, the database query from the first database format into a second database format corresponding to a second database, wherein translating the database query comprises causing the custom driver to execute a transliteration process using pre-verified query keys stored in the query translation library to convert the database query from the first database format into the second database format, and wherein:

the first database format comprises a first machine interpretable language, and

the second database format comprises a second machine interpretable language;

executing, by the custom driver, the translated database query on the second database to obtain a query result; and

sending, to the client application and by the custom driver, the query result.

13. The method of claim 12 , wherein communicating with the enterprise database comprises establishing a connection with the enterprise database, sending database queries to the enterprise database, and returning query results to the client application.

14. The method of claim 12 , wherein executing the transliteration process comprises:

parsing the database query to create a query key;

storing query parameters;

executing a lookup function on a query library to identify a translated database query; and

updating the translated database query to include the query parameters to create an output query.

15. The method of claim 14 , wherein parsing the database query to create the query key comprises:

extracting non-essential portions of the database query; and

replacing the non-essential portions of the database query with pointers.

16. The method of claim 15 , wherein the translated database query includes the pointers.

17. The method of claim 16 , wherein updating the translated database query to include the query parameters comprises, replacing the pointers with the query parameters.

18. The method of claim 14 , further comprising:

based on identifying, during execution of the lookup function, that the query library includes portions of the query key rather than the query key, recursively identifying the translated database query by nesting portions of the query key.

19. The method of claim 18 , wherein recursively identifying the translated database 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.

20. 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:

configure a client application to use a custom driver of the computing platform when communicating with an enterprise database;

receive, from the client application and at the custom driver, a database query, wherein the database query is formatted in a first database format corresponding to a first database;

translate, at the custom driver and using a query translation library, the database query from the first database format into a second database format corresponding to a second database, wherein translating the database query comprises causing the custom driver to execute a transliteration process using pre-verified query keys stored in the query translation library to convert the database query from the first database format into the second database format, and wherein:

the first database format comprises a first machine interpretable language, and

the second database format comprises a second machine interpretable language;

execute, by the custom driver, the translated database query on the second database to obtain a query result; and

send, to the client application and by the custom driver, the query result.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 21, 2021
From: BENDA, CARL M.; MUKHERJEE, MAHARAJ; RAJ, UTKARSH; NYAMWANGE, ELVIS; CHOUDHURY, SUMAN ROY
To: BANK OF AMERICA CORPORATION
Reel/Frame 058448/0158 →
Continuity (2)
Provisional Application 63272263 · Oct 27, 2021
Related Publication 20230129782A1 · Apr 27, 2023
Cited By (1)
US 12,670,152