公开(公告)号：US20200380379A1

公开(公告)日：2020-12-03

申请号：US16429632

申请日：2019-06-03

Applicant: Bank of America Corporation

Inventor： Deviprasad Tatti ,  Suresh V. Kamboji ,  Vibhash K. Jha

IPC: G06N5/02 ,  G06F16/215 ,  G06F16/22 ,  G06F17/16 ,  G06N20/00

Abstract: An apparatus includes a database and a processor. The database stores a set of columns and rules assigned to each column. The rules are used to assess the quality of the data stored in the columns. The processor determines, based in part on the set of rules, the set of columns, and metadata and statistical properties of the columns, a machine learning policy adapted to generate a set of candidate rules for a given column. The processor further determines those columns of the set of columns that are similar to a subject column based on the names of the columns and the names of the tables storing the columns. The processor applies the machine learning policy to the subject column of data, rules of the similar columns, and metadata and statistical properties of the subject column to determine a set of candidate rules for the subject column.

公开(公告)号：US11528234B2

公开(公告)日：2022-12-13

申请号：US17490708

申请日：2021-09-30

Applicant: BANK OF AMERICA CORPORATION

Inventor： Deviprasad Tatti ,  Gaurav Bansal ,  Sandeep Kumar Chauhan ,  Shekhar Singh Mehra

IPC: H04L47/74 ,  H04L47/70 ,  H04L47/78 ,  G06F11/07 ,  G06Q20/00

Abstract: Embodiments of the invention are directed to systems, methods and computer program products for utilizing resources from multiple sources to complete a resource distribution. The invention may receive a distribution request from an entity, where the distribution request includes information identifying a first resource distribution device provided by a user to the entity, a first source associated with the user, and a request amount of resources. The invention may determine whether the requested amount of resources is greater than a first amount of resources in the first source, determine whether the first resource distribution device is associated with one or more other sources associated with the user, and determine whether a sum of the first amount of resources in the first source and a second amount of resources in the one or more other sources is greater than or equal to the requested amount of resources.

公开(公告)号：US11269899B2

公开(公告)日：2022-03-08

申请号：US16900953

申请日：2020-06-14

Applicant: Bank of America Corporation

Inventor： Gaurav Bansal ,  Ashwin Kumar Yedte ,  Deviprasad Tatti

IPC: G06F16/2457 ,  G06F16/22 ,  G06F16/23 ,  G06F16/21 ,  G06N20/00

Abstract: A memory stores a first log and a collection of queries. A processor accesses a second log that includes a first, second, third and fourth historical query, determines that the first and second historical queries belong to a first similarity group and the third and fourth historical queries belong to a second similarity group, and ranks the queries within groups based on static and dynamic features. The processor further determines the third historical query is frequently submitted and copies the highest ranked similar queries into the collection. The processor receives a first database query, stores it in both logs, determines it is not similar to queries stored in memory, further determines that it belongs to the first similarity group, copies the highest ranked similar queries to the first log, and returns a report containing the similar queries. The processor further receives and executes a second query selected from the report.

公开(公告)号：US11184292B1

公开(公告)日：2021-11-23

申请号：US16939368

申请日：2020-07-27

Applicant: BANK OF AMERICA CORPORATION

Inventor： Deviprasad Tatti ,  Gaurav Bansal ,  Sandeep Kumar Chauhan ,  Shekhar Singh Mehra

IPC: H04L12/911 ,  G06F11/07 ,  G06Q20/00

Abstract: Embodiments of the invention are directed to systems, methods and computer program products for utilizing resources from multiple sources to complete a resource distribution. The invention may receive a distribution request from an entity, where the distribution request includes information identifying a first resource distribution device provided by a user to the entity, a first source associated with the user, and a request amount of resources. The invention may determine whether the requested amount of resources is greater than a first amount of resources in the first source, determine whether the first resource distribution device is associated with one or more other sources associated with the user, and determine whether a sum of the first amount of resources in the first source and a second amount of resources in the one or more other sources is greater than or equal to the requested amount of resources.

公开(公告)号：US10719520B2

公开(公告)日：2020-07-21

申请号：US16217395

申请日：2018-12-12

Applicant: Bank of America Corporation

Inventor： Gaurav Bansal ,  Ashwin Kumar Yedte ,  Deviprasad Tatti

IPC: G06F16/2457 ,  G06F16/22 ,  G06N20/00 ,  G06F16/23 ,  G06F16/21

Abstract: A memory stores a first log and a collection of queries. A processor accesses a second log that includes a first, second, third and fourth historical query, determines that the first and second historical queries belong to a first similarity group and the third and fourth historical queries belong to a second similarity group, and ranks the queries within groups based on static and dynamic features. The processor further determines the third historical query is frequently submitted and copies the highest ranked similar queries into the collection. The processor receives a first database query, stores it in both logs, determines it is not similar to queries stored in memory, further determines that it belongs to the first similarity group, copies the highest ranked similar queries to the first log, and returns a report containing the similar queries. The processor further receives and executes a second query selected from the report.

公开(公告)号：US11461671B2

公开(公告)日：2022-10-04

申请号：US16429632

申请日：2019-06-03

Applicant: Bank of America Corporation

Inventor： Deviprasad Tatti ,  Suresh V. Kamboji ,  Vibhash K. Jha

IPC: G06F16/00 ,  G06N5/02 ,  G06F16/215 ,  G06N20/00 ,  G06F17/16 ,  G06F16/22

Abstract: An apparatus includes a database and a processor. The database stores a set of columns and rules assigned to each column. The rules are used to assess the quality of the data stored in the columns. The processor determines, based in part on the set of rules, the set of columns, and metadata and statistical properties of the columns, a machine learning policy adapted to generate a set of candidate rules for a given column. The processor further determines those columns of the set of columns that are similar to a subject column based on the names of the columns and the names of the tables storing the columns. The processor applies the machine learning policy to the subject column of data, rules of the similar columns, and metadata and statistical properties of the subject column to determine a set of candidate rules for the subject column.

公开(公告)号：US20220029928A1

公开(公告)日：2022-01-27

申请号：US17490708

申请日：2021-09-30

Applicant: BANK OF AMERICA CORPORATION

Inventor： Deviprasad Tatti ,  Gaurav Bansal ,  Sandeep Kumar Chauhan ,  Shekhar Singh Mehra

IPC: H04L12/911 ,  G06F11/07

Abstract: Embodiments of the invention are directed to systems, methods and computer program products for utilizing resources from multiple sources to complete a resource distribution. The invention may receive a distribution request from an entity, where the distribution request includes information identifying a first resource distribution device provided by a user to the entity, a first source associated with the user, and a request amount of resources. The invention may determine whether the requested amount of resources is greater than a first amount of resources in the first source, determine whether the first resource distribution device is associated with one or more other sources associated with the user, and determine whether a sum of the first amount of resources in the first source and a second amount of resources in the one or more other sources is greater than or equal to the requested amount of resources.

公开(公告)号：US20200334263A1

公开(公告)日：2020-10-22

申请号：US16900953

申请日：2020-06-14

Applicant: Bank of America Corporation

Inventor： Gaurav Bansal ,  Ashwin Kumar Yedte ,  Deviprasad Tatti

IPC: G06F16/2457 ,  G06F16/22 ,  G06N20/00 ,  G06F16/23 ,  G06F16/21

Abstract: A memory stores a first log and a collection of queries. A processor accesses a second log that includes a first, second, third and fourth historical query, determines that the first and second historical queries belong to a first similarity group and the third and fourth historical queries belong to a second similarity group, and ranks the queries within groups based on static and dynamic features. The processor further determines the third historical query is frequently submitted and copies the highest ranked similar queries into the collection. The processor receives a first database query, stores it in both logs, determines it is not similar to queries stored in memory, further determines that it belongs to the first similarity group, copies the highest ranked similar queries to the first log, and returns a report containing the similar queries. The processor further receives and executes a second query selected from the report.