公开(公告)号：US20210224289A1

公开(公告)日：2021-07-22

申请号：US17221996

申请日：2021-04-05

Applicant: Bank of America Corporation

Inventor： Ravikanth Tadepally ,  Sudhansu Mohanty ,  Utkarsh Singhal ,  Suki Ramasamy

IPC: G06F16/25 ,  G06F16/21

Abstract: An apparatus includes a processor. The processor extracts a column from an external source for import into a database configured to store a set of columns including a first and second column. The processor splits the entries of the import column into a set of terms. The processor generates a first, second, and third vector based on the frequency of each term of the set of terms in the first, second, and import columns, respectively. The processor determines a first similarity measure between the first and third vectors and a second similarity measure between the second and third vectors. The first similarity measure is greater than the second. In response, the processor provides an indication to a user that the first column is a mapping candidate for the import column, such that entries of the import column may be stored in the database as additional entries in the first column.

公开(公告)号：US10997194B1

公开(公告)日：2021-05-04

申请号：US16684906

申请日：2019-11-15

Applicant: Bank of America Corporation

Inventor： Ravikanth Tadepally ,  Sudhansu Mohanty ,  Utkarsh Singhal ,  Suki Ramasamy

IPC: G06F16/00 ,  G06F16/25 ,  G06F16/21

Abstract: An apparatus includes a processor. The processor extracts a column from an external source for import into a database configured to store a set of columns including a first and second column. The processor splits the entries of the import column into a set of terms. The processor generates a first, second, and third vector based on the frequency of each term of the set of terms in the first, second, and import columns, respectively. The processor determines a first similarity measure between the first and third vectors and a second similarity measure between the second and third vectors. The first similarity measure is greater than the second. In response, the processor provides an indication to a user that the first column is a mapping candidate for the import column, such that entries of the import column may be stored in the database as additional entries in the first column.

公开(公告)号：US11709856B2

公开(公告)日：2023-07-25

申请号：US17221996

申请日：2021-04-05

Applicant: Bank of America Corporation

Inventor： Ravikanth Tadepally ,  Sudhansu Mohanty ,  Utkarsh Singhal ,  Suki Ramasamy

IPC: G06F16/00 ,  G06F16/25 ,  G06F16/21

CPC classification number: G06F16/254 ,  G06F16/212 ,  G06F16/252

Abstract: An apparatus includes a processor. The processor extracts a column from an external source for import into a database configured to store a set of columns including a first and second column. The processor splits the entries of the import column into a set of terms. The processor generates a first, second, and third vector based on the frequency of each term of the set of terms in the first, second, and import columns, respectively. The processor determines a first similarity measure between the first and third vectors and a second similarity measure between the second and third vectors. The first similarity measure is greater than the second. In response, the processor provides an indication to a user that the first column is a mapping candidate for the import column, such that entries of the import column may be stored in the database as additional entries in the first column.

公开(公告)号：US20210149910A1

公开(公告)日：2021-05-20

申请号：US16684906

申请日：2019-11-15

Applicant: Bank of America Corporation

Inventor： Ravikanth Tadepally ,  Sudhansu Mohanty ,  Utkarsh Singhal ,  Suki Ramasamy

IPC: G06F16/25 ,  G06F16/21

Abstract: An apparatus includes a processor. The processor extracts a column from an external source for import into a database configured to store a set of columns including a first and second column. The processor splits the entries of the import column into a set of terms. The processor generates a first, second, and third vector based on the frequency of each term of the set of terms in the first, second, and import columns, respectively. The processor determines a first similarity measure between the first and third vectors and a second similarity measure between the second and third vectors. The first similarity measure is greater than the second. In response, the processor provides an indication to a user that the first column is a mapping candidate for the import column, such that entries of the import column may be stored in the database as additional entries in the first column.