US 2020/0004847 A1Published application

Dynamic network database integration system

AssigneeBank of America Corporation

InventorsCharanjit S. Bagga, Pawan Kumar Shetty, Abdul Rahim F. Mohammed, Igor Alksnin, Karthikeyan Bimmanaar Velayudhasamy, Matthew David Ngou, Nagesh Mansabdar, Muralidhar Chowdarapu

Life of this patent

Estimating the term…

patentgrep

Loading patent…

Abstract

Embodiments of the present invention relate to apparatuses, systems, methods and computer program products for dynamic network database integration. Specifically, the system typically provides dynamic correlation, transformation and combination of data stored at a plurality of database locations. In some aspects, the system receives a retrieval request for retrieving one or more records. The system then typically retrieves, transforms and dynamically integrates unstructured data stored at disparate database locations to construct one or more structured records. The system may also construct the one or more structured records such that the one or more structured records are compatible with the user interface of the user device application API. The system may also be configured to facilitate dynamic modification of the retrieval request, in run-time, using custom HTTP headers.

Claims20

Dependent claims

A computerized system for dynamic network database integration, wherein the computerized system is configured for dynamic correlation, transformation and combination of data stored at a plurality of database locations, comprising:

a memory device with computer-readable program code stored thereon;
a communication device, wherein the communication device is configured to establish operative communication with a plurality of networked devices via a communication network;
a processing device operatively coupled to the memory device and the communication device, wherein the processing device is configured to execute the computer-readable program code to:
receive, from a user device, a retrieval request for retrieving one or more records, wherein receiving the retrieval request comprises:
receiving a plurality of data elements to be integrated for each of the one or more records;
and
receiving a data element transformation structure for integrating the plurality of data elements;
determine that (i) first unstructured data associated with a first data element of the plurality of data elements is stored at a first database location associated with a first application programming interface (API) and (ii) second unstructured data associated with a second data element of the plurality of data elements is stored at a second database location associated with a second API;
construct a data schema structured for retrieving the first unstructured data stored at the first database location and the second unstructured data stored at the second database location;
retrieve the first unstructured data from the first database location and the second unstructured data from the second database location based on executing the data schema;
determine a user API format of a user device application API of the user device, wherein the user device application API is configured to present a user interface on the user device, wherein the first unstructured data and the second unstructured data are not compatible with the user interface of the user device application API;
construct one or more structured records associated with the retrieval request, wherein the one or more structured records comprise the plurality of data elements, wherein constructing the one or more structured records comprises transforming the first unstructured data and the second unstructured data into structured data such that at least (i) the one or more structured records comprise the data element transformation structure and (ii) the one or more structured records are associated with the user API format such that the one or more structured records are compatible with the user interface of the user device application API;
and
initiate, via the user device, a presentation of the one or more structured records on the user interface of the user device application API.

11 more elements

A computer program product for dynamic network database integration, wherein the computer program product is configured for dynamic correlation, transformation and combination of data stored at a plurality of database locations, the computer program product comprising a non-transitory computer-readable storage medium having computer-executable instructions for causing a computer processor to:

receive, from a user device, a retrieval request for retrieving one or more records, wherein receiving the retrieval request comprises:
receiving a plurality of data elements to be integrated for each of the one or more records;
and
receiving a data element transformation structure for integrating the plurality of data elements;
determine that (i) first unstructured data associated with a first data element of the plurality of data elements is stored at a first database location associated with a first application programming interface (API) and (ii) second unstructured data associated with a second data element of the plurality of data elements is stored at a second database location associated with a second API;
construct a data schema structured for retrieving the first unstructured data stored at the first database location and the second unstructured data stored at the second database location;
retrieve the first unstructured data from the first database location and the second unstructured data from the second database location based on executing the data schema;
determine a user API format of a user device application API of the user device, wherein the user device application API is configured to present a user interface on the user device, wherein the first unstructured data and the second unstructured data are not compatible with the user interface of the user device application API;
construct one or more structured records associated with the retrieval request, wherein the one or more structured records comprise the plurality of data elements, wherein constructing the one or more structured records comprises transforming the first unstructured data and the second unstructured data into structured data such that at least (i) the one or more structured records comprise the data element transformation structure and (ii) the one or more structured records are associated with the user API format such that the one or more structured records are compatible with the user interface of the user device application API;
and
initiate, via the user device, a presentation of the one or more structured records on the user interface of the user device application API.

8 more elements

A method for dynamic network database integration, wherein the method is configured for dynamic correlation, transformation and combination of data stored at a plurality of database locations, the method comprising:

receiving, from a user device, a retrieval request for retrieving one or more records, wherein receiving the retrieval request comprises:
receiving a plurality of data elements to be integrated for each of the one or more records;
and
receiving a data element transformation structure for integrating the plurality of data elements;
determining that (i) first unstructured data associated with a first data element of the plurality of data elements is stored at a first database location associated with a first application programming interface (API) and (ii) second unstructured data associated with a second data element of the plurality of data elements is stored at a second database location associated with a second API;
constructing a data schema structured for retrieving the first unstructured data stored at the first database location and the second unstructured data stored at the second database location;
retrieving the first unstructured data from the first database location and the second unstructured data from the second database location based on executing the data schema;
determining a user API format of a user device application API of the user device, wherein the user device application API is configured to present a user interface on the user device, wherein the first unstructured data and the second unstructured data are not compatible with the user interface of the user device application API;
constructing one or more structured records associated with the retrieval request, wherein the one or more structured records comprise the plurality of data elements, wherein constructing the one or more structured records comprises transforming the first unstructured data and the second unstructured data into structured data such that at least (i) the one or more structured records comprise the data element transformation structure and (ii) the one or more structured records are associated with the user API format such that the one or more structured records are compatible with the user interface of the user device application API;
and
initiating, via the user device, a presentation of the one or more structured records on the user interface of the user device application API.

8 more elements

Dependencies are inferred from the claim text.

Facts

Application: 16/022,497Filed 28 Jun 2018
Published: 2 Jan 2020
Term ends: Not estimatedThe source records don’t support an estimate.

Classification12 codes

G06F 16/211
Design, administration or maintenance of databases: schema design and management
G06F 16/27
Of structured data, e.g. relational data: replication, distribution or synchronisation of data between databases or within a distributed database…
G06F 16/2455
Query processing: query execution
G06F 16/252
Integrating or interfacing systems involving database management systems: between a Database Management System and a front-end application

Family

US 10,642,804 B2Related patent
US 2020/0004847 A1This patent

From the US filing history. Foreign family members aren’t listed.

Timeline

Citations

Open elsewhere

Building an agent or pulling many patents? Use the API or MCP server instead of scraping pages. Get an API key