Invention Grant
- Patent Title: Automatic database script generation for copying data between relational databases
-
Application No.: US17060282Application Date: 2020-10-01
-
Publication No.: US11321285B2Publication Date: 2022-05-03
- Inventor: Madhusudhanan Krishnamoorthy , Manikandan Madhu
- Applicant: BANK OF AMERICA CORPORATION
- Applicant Address: US NC Charlotte
- Assignee: BANK OF AMERICA CORPORATION
- Current Assignee: BANK OF AMERICA CORPORATION
- Current Assignee Address: US NC Charlotte
- Main IPC: G06F16/21
- IPC: G06F16/21 ; G06F16/22 ; G06N20/00

Abstract:
An apparatus includes a memory and processor. The memory stores a graphical representation of a first database that includes source tables and columns. The graphical representation includes nodes associated with source tables and columns. The processor receives an instruction to transfer data from the first database to columns of a second database specified by destination column names. The processor identifies a subset of source columns such that a similarity score for each is greater than a threshold. The similarity score indicates a degree of similarity between a specific destination column name and either the assigned source column name or a related term. The processor uses the subset to generate a pruned graphical representation that includes a subset of nodes. The processor uses this to generate executable code configured to copy data from the first database, determined from the pruned graphical representation, into the second database.
Public/Granted literature
- US20220107922A1 AUTOMATIC DATABASE SCRIPT GENERATION FOR COPYING DATA BETWEEN RELATIONAL DATABASES Public/Granted day:2022-04-07
Information query